Example of Loading Overtime Period

You can define overtime periods at the assignment-level for your workers by loading them with HCM Data Loader.

Let's look at a Worker.dat file that uses Overtime Period or Overtime Period Name.

Overtime Period

METADATA|WorkTerms|AssignmentNumber|PersonNumber|LegalEmployerName|DateStart|WorkerType|ActionCode|ReasonCode|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence
MERGE|WorkTerms|E100068|100068|City of San Luis Obispo|2023/01/19|E|ORA_POS_SYNC||2025/06/11|4712/12/31|Y|1
METADATA|Assignment|AssignmentNumber|PersonNumber|LegalEmployerName|DateStart|WorkerType|ActionCode|ReasonCode|WorkTermsNumber|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|OvertimePeriod
MERGE|Assignment|E100068|100068|City of San Luis Obispo|2023/01/19|E|ORA_POS_SYNC||E100068|2025/06/11|4712/12/31|Y|1|<HWM_RP_TM_PERIODS_VL.REPEATING_TM_PERIOD_ID>

Overtime Period Name

METADATA|WorkTerms|AssignmentNumber|PersonNumber|LegalEmployerName|DateStart|WorkerType|ActionCode|ReasonCode|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence
MERGE|WorkTerms|E100068|100068|City of San Luis Obispo|2023/01/19|E|ORA_POS_SYNC||2025/06/11|4712/12/31|Y|1
METADATA|Assignment|AssignmentNumber|PersonNumber|LegalEmployerName|DateStart|WorkerType|ActionCode|ReasonCode|WorkTermsNumber|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|OvertimePeriodName
MERGE|Assignment|E100068|100068|City of San Luis Obispo|2023/01/19|E|ORA_POS_SYNC||E100068|2025/06/11|4712/12/31|Y|1|<HWM_RP_TM_PERIODS_VL.NAME>

Note:

Replace <HWM_RP_TM_PERIODS_VL.REPEATING_TM_PERIOD_ID> / <HWM_RP_TM_PERIODS_VL.NAME> with the database value.