Important Shift Pattern Import fields
Shftpat_Start_Date (column 6)
If Shftpat_Start_Date is not provided in the data file, the shift pattern start date defaults to 19000101. Supplying a good value for this field is important, as the employee's start day of the week for shift patterns is based on this date.
Shftpat_Day_Start_Time (column 7)
The Shftpat_Day_Start_Time field is required if all employees in this shift pattern need to have the same day start time and do not have a day start time that is defined at the employee level.