Examples of Loading Worker Working Hour Pattern

You can define shift types and working hours for your workers by loading working hour patterns with HCM Data Loader.

If the daily working hours are a fixed number of hours per day, use Elapsed as the Work Shift Type to load. If you need to track the start and end times per day, use Time as the Work Shift Type to load. Let's look at some Worker.dat files that create worker hour patterns.

Load Working Hour Pattern by Shift Type

To get started with working hour patterns, see the topic Create a Default Working-Hour Pattern. Then, you can use the following examples to load worker hours with the work shift type of your choice.

Let's say you want to define the specific times of day in a worker's daily shift. To do this, load the Working Hour Pattern using Time as the Work Shift Type.

METADATA|WorkTerms|ActionCode|AssignmentStatusTypeCode|AssignmentType|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|AssignmentNumber|LegalEmployerName|PrimaryWorkTermsFlag|DateStart|PersonNumber|WorkerType
MERGE|WorkTerms|HIRE|ACTIVE_PROCESS|ET|4712/12/31|Y|1|2019/03/29|E51323|V1_LE0227|Y|2019/03/13|51323|E
METADATA|Assignment|ActionCode|AssignmentStatusTypeCode|AssignmentType|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|WorkTermsNumber|AssignmentNumber|PrimaryFlag|PrimaryAssignmentFlag|HourlySalariedCode|PersonNumber
MERGE|Assignment|HIRE|ACTIVE_PROCESS|E|4712/12/31|Y|1|2019/03/29|ET966169008889921|E51323|Y|Y|Salaried|51323
METADATA|WorkingHourPattern|Object|AssignmentNumber|EffectiveStartDate|WorkDayDefinitionCode|WorkingHoursType|WorkShiftType|SatEndTime|SatStartTime|FriStartTime|FriEndTime|MonStartTime|MonEndTime|SunEndTime|SunStartTime|ThuEndTime|ThuStartTime|TueEndTime|TueStartTime|WedStartTime|WedEndTime
MERGE|WorkingHourPattern|ASSIGNMENT|E51323|2019/03/29|TIME ENTRY STOP DAY|ORA_WORK_WEEK|ORA_TIME|18:00|10:00|10:00|18:00|10:00|18:00|18:00|10:00|18:00|10:00|18:00|10:00|10:00|18:00

If you would rather record how many hours worked per shift, you can set Work Shift Type as Elapsed.

METADATA|WorkTerms|ActionCode|AssignmentStatusTypeCode|AssignmentType|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|AssignmentNumber|LegalEmployerName|PrimaryWorkTermsFlag|DateStart|PersonNumber|WorkerType
MERGE|WorkTerms|HIRE|ACTIVE_PROCESS|ET|4712/12/31|Y|1|2019/03/29|E51323|V1_LE0227|Y|2019/03/13|51323|E
METADATA|Assignment|ActionCode|AssignmentStatusTypeCode|AssignmentType|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|WorkTermsNumber|AssignmentNumber|PrimaryFlag|PrimaryAssignmentFlag|HourlySalariedCode|PersonNumber
MERGE|Assignment|HIRE|ACTIVE_PROCESS|E|4712/12/31|Y|1|2019/03/29|ET966169008889921|E51323|Y|Y|Salaried|51323
METADATA|WorkingHourPattern|Object|AssignmentNumber|EffectiveStartDate|WorkDayDefinitionCode|WorkingHoursType|WorkShiftType|WedHours|TueHours|ThuHours|SunHours|MonHours|FriHours|SatHours
MERGE|WorkingHourPattern|ASSIGNMENT|E51323|2019/03/29|TIME ENTRY STOP DAY|ORA_WORK_WEEK|ORA_ELAPSED|8|8|8|8|8|8|8