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.