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

Note: Shift numbers are optional when you create a schedule. Typically, they're generated by a third-party scheduling system. You must specify a shift number when updating or deleting a shift.