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