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 (&) in the flag position indicates the flag is to be blanked.

YYYYYNNNNN