Examples of Creating Worker Schedules
This topic provides examples showing how to create worker schedules using HCM Data Loader.
Creating a Schedule for a Worker for a Specific Week
For each worker whose schedule you're creating, you must load Schedule Request, Schedule Event, and Schedule Shift Event components. On the Schedule Event component, you set the ImportMode attribute to FULL. On the Schedule Shift Event components, you set the ShiftAction attribute to CREATE.
This example ScheduleRequest.dat file creates a schedule for a worker for a specified week. It uses user keys.
METADATA|ScheduleRequest|ScheduleRequestNumber|RequestSource|RequestTime
MERGE|ScheduleRequest|SR1234501|3RD_PARTY_ABC|2017-01-01T13:25:20.010+01:00
METADATA|ScheduleEvent|ScheduleRequestNumber|ScheduleEventNumber|ImportMode|PersonNumber|PeriodStartDate|PeriodEndDate|AllowEdits|Publish|WorkerNotification
MERGE|ScheduleEvent|SR1234501|SE001|FULL|955160008182092|2017/01/01|2017/01/07|Y|Y|N
METADATA|ScheduleShiftEvent|ScheduleRequestNumber|ScheduleEventNumber|ScheduleShiftEventNumber|ShiftAction|ReferenceDay|ShiftStartTime|ShiftEndTime|ShiftTimeNotWorked|ShiftCode|ShiftCategory|ShiftType|AllowEdits
MERGE|ScheduleShiftEvent|SR1234501|SE001|SSE101|CREATE|2017/01/01|2017-01-01T09:00:00+01:00|2017-01-01T17:00:00+01:00|60|MORNTIME|WORK|TIME|N
MERGE|ScheduleShiftEvent|SR1234501|SE001|SSE102|CREATE|2017/01/02|2017-01-02T09:00:00+01:00|2017-01-02T17:00:00+01:00|60|MORNTIME|WORK|TIME|N
MERGE|ScheduleShiftEvent|SR1234501|SE001|SSE103|CREATE|2017/01/03|2017-01-03T09:00:00+01:00|2017-04-03T17:00:00+01:00|60|MORNTIME|WORK|TIME|N
MERGE|ScheduleShiftEvent|SR1234501|SE001|SSE104|CREATE|2017/01/04|2017-01-04T09:00:00+01:00|2017-04-04T17:00:00+01:00|60|MORNTIME|WORK|TIME|N
MERGE|ScheduleShiftEvent|SR1234501|SE001|SSE105|CREATE|2017/01/05|2017-01-05T09:00:00+01:00|2017-04-05T17:00:00+01:00|60|MORNTIME|WORK|TIME|N
METADATA|ScheduleShiftAttribute|ScheduleRequestNumber|ScheduleEventNumber|ScheduleShiftEventNumber|ScheduleShiftAttributeNumber|AttributeName|AttributeValue
MERGE|ScheduleShiftAttribute|SR1234501|SE001|SSE101|SSA001|PayrollTimeType|WFM_PAY_REGULAR_US
MERGE|ScheduleShiftAttribute|SR1234501|SE001|SSE101|SSA002|GD_Department_CHAR|1000
MERGE|ScheduleShiftAttribute|SR1234501|SE001|SSE102|SSA001|PayrollTimeType|WFM_PAY_REGULAR_US
MERGE|ScheduleShiftAttribute|SR1234501|SE001|SSE102|SSA002|GD_Department_CHAR|1000
MERGE|ScheduleShiftAttribute|SR1234501|SE001|SSE103|SSA001|PayrollTimeType|WFM_PAY_REGULAR_US
MERGE|ScheduleShiftAttribute|SR1234501|SE001|SSE103|SSA002|GD_Department_CHAR|1000
MERGE|ScheduleShiftAttribute|SR1234501|SE001|SSE104|SSA001|PayrollTimeType|WFM_PAY_REGULAR_US
MERGE|ScheduleShiftAttribute|SR1234501|SE001|SSE104|SSA002|GD_Department_CHAR|1000
MERGE|ScheduleShiftAttribute|SR1234501|SE001|SSE105|SSA001|PayrollTimeType|WFM_PAY_REGULAR_US
MERGE|ScheduleShiftAttribute|SR1234501|SE001|SSE105|SSA002|GD_Department_CHAR|1000
Creating a Shift for a Worker for a Specific Day
To create a single shift for a worker, you load the Schedule Request, Schedule Event, and Schedule Shift Event components. On the Schedule Event component, you set the ImportMode attribute to FULL. On the Schedule Shift Event component, you set the ShiftAction attribute to CREATE.
This example ScheduleRequest.dat file creates a shift for a worker on a specific day. It uses user keys.
METADATA|ScheduleRequest|ScheduleRequestNumber|RequestSource|RequestTime
MERGE|ScheduleRequest|SR1234502|3RD_PARTY_ABC|2017-01-01T13:25:20.010+01:00
METADATA|ScheduleEvent|ScheduleRequestNumber|ScheduleEventNumber|ImportMode|PersonNumber|PeriodStartDate|PeriodEndDate|AllowEdits|Publish|WorkerNotification
MERGE|ScheduleEvent|SR1234502|SE001|FULL|955160008272091|2017/01/01|2017/01/07|Y|Y|N
METADATA|ScheduleShiftEvent|ScheduleRequestNumber|ScheduleEventNumber|ScheduleShiftEventNumber|ShiftNumber|ShiftAction|ReferenceDay|ShiftStartTime|ShiftEndTime|ShiftDuration|ShiftTimeNotWorked|ShiftCode|ShiftCategory|ShiftType|AllowEdits
MERGE|ScheduleShiftEvent|SR1234502|SE001|SSE101|SN001|CREATE|2017/01/01|2017-01-01T06:00:00+01:00|2017-01-01T09:00:00+01:00||60|MORNTIME|WORK|TIME|N
METADATA|ScheduleShiftAttribute|ScheduleRequestNumber|ScheduleEventNumber|ScheduleShiftEventNumber|ScheduleShiftAttributeNumber|AttributeName|AttributeValue
MERGE|ScheduleShiftAttribute|SR1234502|SE001|SSE101|SSA001|PayrollTimeType|WFM_PAY_REGULAR_US
MERGE|ScheduleShiftAttribute|SR1234502|SE001|SSE101|SSA002|GD_Department_CHAR|1000