Change Log Report

The Change Log report, which Amazon service providers can find under Assignments, shows all the changes to the Ūsked database made during a given date range.

A vendor service provider may log into Ūsked and download this report in a .csv format, and use this file to either manually update their own scheduling software with all of the updates, or they may use some form of an upload feature to mass update jobs in their own system.

Note, when a  vendor utilizes the Change Log report option as a means of receipt of service requests from Amazon, confirmation of the vendor’s assigned service provider names are sent via email. 

When the Change Log report is run, the user must make sure to never overlap time frames.  Search criteria should be entered as starting exactly on the next minute from the last time the report was generated.

These are the instructions to use the Change Log Report to manage an internal API on the vendor’s end:

  • The change log is a .csv file
  • Column A is always the “command”

The Command list includes:

  • section
  • headings
  • comment
  • time range
  • unassigned
  • assigned
  • value
  • inactivated

When creating an importer, these commands may be ignored, as they are intended to assist in readability for humans:

  • section
  • headings
  • comment

What follows is a description of each command:

section

This is used to break up the .csv file into sections.

  • Column B - the name of the section, which can be one of:
    • time range for this change log
    • unassigneds
    • assigneds
    • jobs
    • updates

headings

These are the headings for the rows that follow.

comment

This is a human readable comment describing what is happening.

  • Column B - the comment text, which can be one of:
    • no unassigneds during this time range
    • no assigneds during this time range
    • there are no updates for job {job id}
    • you do not have any previously reported upcoming requests

time range

This indicates the time range for the .csv data, indicating when the changes were made:

  • Column B - the start date and time in the user’s time zone
  • Column C - the end date and time in the user’s time zone
  • Column D - the start date and time in the ET zone (America/New_York)
  • Column E - the end date and time in the ET zone (America/New_York)

unassigned

This indicates that you have been removed from an interpreter slot:

  • Column B - The job ID
  • Column C - The interpreter slot ID
  • Column D - The date and time this change was made in the user’s time zone
  • Column E - The date and time this change was made in the ET zone (America/New_York)

assigned

This indicates that you have been added to an interpreter slot:

  • Column B - The job ID
  • Column C - The interpreter slot ID
  • Column D - The date and time this change was made in the user’s time zone
  • Column E - The date and time this change was made in the ET zone (America/New_York)

Note that for each interpreter slot that you have been assigned to, the full details of that assignment will appear in the jobs section.  If you have not been assigned to any assignments during this time range, there will be no jobs section.

value

These are new or updated assignment detail values.

  • Column B - The job ID
  • Column C - The table that this value is from, which will be one of:
    • job
    • location
    • client
    • poc
    • file_attachment

Columns C and D are applicable only when the table is “client”, “poc”, or “file_attachment”:

  • Column D - The slot ID
  • Column E - The object ID - this is the ID of the object connected to this slot, and is one of:
    • client ID
    • poc ID
    • file_attachment ID

The remaining columns are:

  • Column F - This is the name of the field
  • Column G - This is the immediate value of this field
  • Column H - This is the indirect value of this field

The last two columns are present only in the “updates” section:

  • Column I - The date and time this change was made in the user’s time zone
  • Column J - The date and time this change was made in the ET zone (America/New_York)

inactivated

This indicates that either a “client”, “poc”, or “file_attachment” slot has been removed from the assignment:

  • Column B - The job ID
  • Column C - The table where the slot was removed, which will be one of -
    • client
    • poc
    • file_attachment
  • Column D - The slot ID
  • Columns E through H are blank.
  • Column I - The date and time this change was made in the user’s time zone
  • Column J - The date and time this change was made in the ET zone (America/New_York)