Examples of Updating Worker Schedules

This topic provides examples showing how to update existing worker schedules using HCM Data Loader.

Updating a Shift

To update an existing shift, you load the Schedule Request, Schedule Event, and Schedule Shift Event components. On the Schedule Event component, you set the ImportMode attribute to UPDATE. On the Schedule Shift Event component, you specify the shift number and set the ShiftAction attribute to UPDATE.

This example ScheduleRequest.dat file updates an existing worker shift from a third-party application.

METADATA|ScheduleRequest|ScheduleRequestNumber|RequestSource|RequestTime
MERGE|ScheduleRequest|SR1234503|3RD_PARTY_ABC|2017-01-01T13:25:20.010+01:00
METADATA|ScheduleEvent|ScheduleRequestNumber|ScheduleEventNumber|ImportMode|PersonNumber|PeriodStartDate|PeriodEndDate|AllowEdits|Publish|WorkerNotification
MERGE|ScheduleEvent|SR1234503|SE001|UPDATE|955160008272091|2017/01/01|2017/01/07|Y|Y|N
METADATA|ScheduleShiftEvent|ScheduleRequestNumber|ScheduleEventNumber|ScheduleShiftEventNumber|ShiftNumber|ShiftAction|ReferenceDay|ShiftStartTime|ShiftEndTime|ShiftTimeNotWorked|ShiftCode|ShiftCategory|ShiftType|AllowEdits
MERGE|ScheduleShiftEvent|SR1234503|SE001|SSE101|SN001|UPDATE|2017/01/01|2017-01-01T07:00:00+01:00|2017-01-01T11:00:00+01:00|60|MORNTIME|WORK|TIME|N

Deleting a Shift

To delete a shift, you load the Schedule Request, Schedule Event, and Schedule Shift Event components. On the Schedule Event component, you set the ImportMode attribute to UPDATE. On the Schedule Shift Event component, you specify the shift number and set the ShiftAction attribute to DELETE.

This example ScheduleRequest.dat file deletes an existing shift

METADATA|ScheduleRequest|ScheduleRequestNumber|RequestSource|RequestTime
MERGE|ScheduleRequest|SR1234504|3RD_PARTY_ABC|2017-01-01T13:25:20.010+01:00
METADATA|ScheduleEvent|ScheduleRequestNumber|ScheduleEventNumber|ImportMode|PersonNumber|PeriodStartDate|PeriodEndDate|AllowEdits|Publish|WorkerNotification
MERGE|ScheduleEvent|SR1234504|SE001|UPDATE|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|SR1234504|SE001|SSE101|SN001|DELETE|2017/01/01|2017-01-01T07:00:00+01:00|2017-01-01T11:00:00+01:00||60|MORNTIME|WORK|TIME|N

Clearing a Schedule

To clear a worker schedule, load the Schedule Request and Schedule Event components. On the Schedule Event component, you set the ImportMode attribute to FULL. Because you aren't providing Schedule Shift Event components, the Process Imported Shifts process deletes all shifts for the given period.

This example ScheduleRequest.dat file clears all existing shifts for a worker for a specified period.

METADATA|ScheduleRequest|ScheduleRequestNumber|RequestSource|RequestTime
MERGE|ScheduleRequest|SR1234537|3RD_PARTY_ABC|2017-05-01T13:25:20.010+01:00
METADATA|ScheduleEvent|ScheduleRequestNumber|ScheduleEventNumber|ImportMode|PersonNumber|PeriodStartDate|PeriodEndDate|AllowEdits|Publish|WorkerNotification
MERGE|ScheduleEvent|SR1234537|SE002|FULL|955160008182092|2017/05/01|2017/05/31|Y|Y|N