Employee Temporary Team Import Interface logic
This section describes how the standard Employee Temporary Team Import Interface converts employee temporary team CSV data into the Workforce Management system. This section references field specifications in Employee Temporary Team Import Interface field specification.
The Employee Temporary Team Import file is a CSV text file with columns enclosed in quotes if there are commas in the column field value. The records in the file are processed sequentially from top to bottom.
EMP_NAME (column 1)
The EMP_NAME field identifies the employee that you are adding, updating, or deleting the temporary team assignment for. If the employee can not be found, an error is returned.
WBT_NAME (column 2)
The WBT_NAME field identifies the temporary team that is being assigned to the employee or whose assignment is being updated or deleted. If the team cannot be found, an error is returned.
START_DATE (column 3) and END_DATE (column 4)
The START_DATE and END_DATE fields specify the start date and end date of the employee's temporary team assignment. When not specified, the start date defaults to 01/01/1900 and the end date defaults to 01/01/3000.
ACTION (column 5)
The ACTION field specifies the action to be performed for the temporary team assignment.
This table describes the behavior of the ACTION field:
| Action | Description |
|---|---|
| ADD | Adds the temporary team assignment to the employee. If an employee is already assigned to the temporary team in WBT_NAME, and the start or end date in the import file fall within the duration of the existing temporary team assignment, then the start and end dates of the temporary team assignment are adjusted to the earliest possible start date and latest possible end date between the existing data and the imported data. If there is an existing temporary team assignment where the dates overlap with an incoming temporary team assignment but the EXT_CODE fields do not match, a new temporary team assignment will be added. If the EXT_CODE should be unique when adding option is selected in the interface task, the temporary team assignments work similar to home team assignments where the dates for the EXT_CODE cannot overlap for any team. See Setting up Employee Temporary Team Imports. |
| UPDATE | Searches the temporary team assignments of an employee and updates the start
and end dates accordingly. If the EXT_CODE field is not empty, the WBT_NAME and the EXT_CODE values in the import data are matched with the values in the EMPLOYEE_TEAM table for the temporary team assignment to update. If the EXT_CODE field is not empty and it matches to more than one existing temporary team assignments with the same EXT_CODE, the temporary team assignment where the dates of the existing and incoming temporary team assignments overlap or the temporary team assignment whose dates are closest to the incoming temporary team assignment is updated. If the EXT_CODE field is not empty and the import data WBT_NAME and start/end dates match an existing temporary team assignment whose EXT_CODE is empty, the dates and the EXT_CODE of the existing team assignment are updated to the dates and EXT_CODE in the import data. If the EXT_CODE field is empty, the temporary team assignments whose start or end date are within the new start and end dates in the import file are updated. If a record in the import file with an empty EXT_CODE matches an existing team assignment where the EXT_CODE has a value, an error is returned. If the temporary team assignment does not exist for an UPDATE action, an error is returned. If an update affects more than one existing temporary team assignments, then the records are combined into one temporary team assignment with the start and end dates set to the dates in the import file. |
| DELETE | Deletes the temporary team assignment of an employee during the
specified date range. If the EXT_CODE field is empty, the start and end dates in the import file must match the existing start and end dates in the existing data for the temporary team assignment to be deleted. If a record in the import file with an empty EXT_CODE matches an existing team assignment where the EXT_CODE has a value, an error is returned. If there is no matching temporary team assignment, no action is taken. |
EXT_CODE (column 6)
The EXT_CODE field is optional and can be used by the source system to reference their own team assignments. If the value exceeds 20 characters, an error is returned. For the UPDATE and DELETE actions, if a record in the import file with an empty EXT_CODE matches an existing team assignment where the EXT_CODE has a value, an error is returned. If the EXT_CODE should be unique when adding option is selected in the interface task and the EXT_CODE is not specified in the import file, an error is returned.