Shift Pattern Import Interface field specification

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

Col. Field Name Type Size/Format Description
1/A Emp_Name Varchar2 40 Employee name
2/B Ovr_Start_Date String 8/yyyyMMdd Date of the employee effective start date (defaults to transaction date)
3/C Over_End_Date String 8/yyyyMMdd Date of the employee effective end date (defaults to 30000101)
4/D Shftpat_Name String 40 Shift pattern name
5/E Shftpat_Desc String 200 Shift pattern description
6/F Shftpat_Start_Date String 8/yyyyMMdd The start date of the pattern (defaults to 19000101 Monday)
7/G Shftpat_Day_Start_Time String 4/hh24mm The start time of the pattern
8/H Shftgrp_Name String 40 Shift group name
9/I Shftpat_UDF1 String 40 Customizable field 1
10/J Shftpat_UDF2 String 40 Customizable field 2
11/K Shftpat_UDF3 String 40 Customizable field 3
12/L Shftpat_UDF4 String 40 Customizable field 4
13/M Shftpat_UDF5 String 40 Customizable field 5
14/N Shftpat_FLAGS String 5 Customizable flags
15/O Reserved For importing shift pattern of more than 22 shifts into the system.

To import a shift pattern of more than 22 shifts, the asterisk symbol (*) is required in this column.
16/P Sch_Identifier* String 2/Day~shiftNo An identifier that determines the day and shift number to which the next 4 columns belong.

For example, 1~1 means day1 and shift1.

17/Q Sch_Start_End_Time* hh24mm~hh-24mm The start and time of shift.

The OFF keyword can be used to denote that the day is not scheduled. In this case, the SCH_BREAK_STRING and SHFTPAT_LABOR_STRING columns are ignored and the standard WFM OFF shift is assigned for this day of shift pattern.

18/R Sch_Break_String String Breaks supplied in a certain format. See Break logic.
19/S Shftpat_Labor_String String Shift pattern shift labor allocation. See Shift pattern labor allocation logic.
20/T Sch_Identifier2 Columns 16 to 19 can recur for multiple days (multiple shifts can be specified for a shift pattern record).