How do I set the final close date for element duration dates using HCM Data Loader?

Load the element duration dates at the assigned payroll or payroll assignment levels to set the final close date.

  • To set the final close date at the assigned payroll level for an individual assignment, use the AssignedPayroll.dat file.

    Here's a sample code:

    METADATA|AssignedPayroll|EffectiveStartDate|FinalCloseDate|LegislativeDataGroupName|PayrollDefinitionCode|AssignmentNumber|StartDate
    MERGE|AssignedPayroll|2024/01/01|2024/04/30 00:00:00|Vision US LDG|Monthly Payroll|E10003|2024/01/01
  • To set the final close date at the payroll assignment level, which eventually rolls over to the payroll relationship level, use the ElementDurationDate.dat file.

    Here's a sample code:

    METADATA|ElementDurationDate|DateValue|SourceType|AssignmentNumber|TimeDefinitionCode
    MERGE|ElementDurationDate|2024/04/30|PA|E10003|Final Close