Schedule Detail Import Interface field specification
Each line in the Schedule Detail Import file corresponds to a shift in the employee schedule.
This table lists the field-column specifications of the Schedule Detail Import. Fields with the asterisk symbol (*) are required. Fields with double asterisk (**) are required only when the OP_TYPE is set to the value I.
| Col. | Field Name | Type | Size/ Format | Description | Example |
|---|---|---|---|---|---|
| 01 | OP_TYPE* | CHAR | 1 | D for delete, I for Insert. Other values are not allowed | D |
| 02 | EMP_NAME * | VARCHAR2 | 40 | Unique identifier for employee | LLCOOLJ |
| 03 | SKD_DATE * | VARCHAR2 | yyyyMMdd | Date of the schedule | 20110125 |
| 04 | SKD_START ** | VARCHAR2 | yyyyMMdd HHmm | Schedule/break start date and time | 20110125 0800 |
| 05 | SKD_END ** | VARCHAR2 | yyyyMMdd HHmm | Schedule/break end date and time | 20110125 2000 |
| 06 | WBT_NAME ** | VARCHAR2 | 40 | Workforce Management team name | IT |
| 07 | JOB_NAME ** | VARCHAR2 | 40 | Job name | Clerk |
| 08 | TCODE_NAME | VARCHAR2 | 40 | Time code name | WRK |
| 09 | HTYPE_NAME | VARCHAR2 | 40 | Hour type name | REG |
| 10 | PROJ_NAME | VARCHAR2 | 40 | Project | |
| 11 | DOCK_NAME | VARCHAR2 | 40 | Docket | |
| 12 | DEPT_NAME | VARCHAR2 | 40 | Department | |
| 13 | STSKL_NAME | VARCHAR2 | 40 | Skill | |
| 14 | ACT_NAME | VARCHAR2 | 40 | Activity | |
| 15 | COMMENTS | VARCHAR2 | 100 | Override comment | Full day schedule |
| 16 | UDF1 | VARCHAR2 | 40 | User defined field | |
| 17 | UDF2 | VARCHAR2 | 40 | User defined field | |
| 18 | UDF3 | VARCHAR2 | 40 | User defined field | |
| 19 | UDF4 | VARCHAR2 | 40 | User defined field | |
| 20 | UDF5 | VARCHAR2 | 40 | User defined field | |
| 21 | UDF6 | VARCHAR2 | 40 | User defined field | |
| 22 | UDF7 | VARCHAR2 | 40 | User defined field | |
| 23 | UDF8 | VARCHAR2 | 40 | User defined field | |
| 24 | UDF9 | VARCHAR2 | 40 | User defined field | |
| 25 | UDF10 | VARCHAR2 | 40 | User defined field | |
| 26 | FLAGS1TO10 | VARCHAR2 | 10 | 10-one character flags for general use.
Use a space character in the flag position to indicate no processing is to be done for that flag. An ampersand ( |
YYYYYNNNNN |