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. |