Schedule Import Interface field specification

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

Col. Field Name Type Size/Format Description
1 Emp_Name Varchar2 40 Employee name.
2 Sch_Date* Varchar2 40/yyyyMMdd Date of the schedule.
3 Sch_Shift_In* Varchar2 40/yyyyMMdd-HHmm Schedule start date and time.
4 Sch_Shift_Out* Varchar2 40/yyyyMMdd-HHmm Schedule end date and time.
5 Sch_Break_String* Varchar2 Break Logic, 2. Breaks supplied for first schedule.
6 Sch_Shift2_In Varchar2 40/yyyyMMdd-HHmm Second schedule start date and time.
7 Sch_Shift2_Out Varchar2 40/yyyyMMdd-HHmm Second schedule end date and time.
8 Sch_Break2_String Varchar2 Break Logic, 2. Breaks for 2nd schedule.
9 Sch_Shift3_In Varchar2 40/yyyyMMdd-HHmm Third schedule start date and time.
10 Sch_Shift3_Out Varchar2 40/yyyyMMdd-HHmm Third schedule end date and time.
11 Sch_Break3_String Varchar2 Break Logic, 2. Breaks for third schedule.
12 Sch_Shift4_In Varchar2 40/yyyyMMdd-HHmm Fourth schedule start date and time.
13 Sch_Shift4_Out Varchar2 40/yyyyMMdd-HHmm Fourth schedule end date and time.
14 Sch_Break4_String Varchar2 Break Logic, 2. Breaks for fourth schedule.
15 Sch_Shift5_In Varchar2 40/yyyyMMdd-HHmm Fifth schedule start date and time.
16 Sch_Shift5_Out Varchar2 40/yyyyMMdd-HHmm Fifth schedule end date and time.
17 Sch_Break5_String Varchar2 Break Logic, 2. Breaks for fifth schedule.
18 Empskd_Flags String 10 Employee schedule flags.
19 Empskd_UDF1 Varchar2 40 Employee schedule UDF1.
20 Empskd_UDF2 Varchar2 40 Employee schedule UDF2.
21 Empskd_UDF3 Varchar2 40 Employee schedule UDF3.
22 Empskd_UDF4 Varchar2 40 Employee schedule UDF4.
23 Empskd_UDF5 Varchar2 40 Employee schedule UDF5.