Employee Temporary Team Import Interface field specification

This table lists the field-column specifications of the Employee Temporary Team Import Interface. Fields with the asterisk symbol (*) are required.

Col. Field Name Type Size/Format Description
1 EMP_NAME* Varchar2 40 Identifies the employee.
2 WBT_NAME* Varchar2 80 Identifies the temporary team to which the employee will be assigned.
3 START_DATE Date MM/DD/YYYY Specifies the start date of the employee's temporary team assignment. Defaults to 01/01/1900.
4 END_DATE Date MM/DD/YYYY Specifies the end date of the employee's temporary team assignment. Defaults to 01/01/3000.
5 ACTION* Specifies the action: ADD, UPDATE, or DELETE. See ACTION (column 5).
6 EXT_CODE Varchar2 20 Can be used by the source system to reference their own team assignments.

By default, this field is hidden in the Employee Team maintenance form.