Example of Creating a New Statutory Deductions card for France

This example creates a complete Statutory Deductions card with associations for assignment E5369

The CalculationCard.dat file is used to upload Statutory Deductions calculation cards with HCM Data Loader.

METADATA|CalculationCard|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|DirCardDefinitionName|EffectiveStartDate|AssignmentNumber
MERGE|CalculationCard|HRC_SQLLOADER|E5369_SD|FR LDG|Statutory Deductions|2026/01/01|E5369

METADATA|CardComponent|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|DirCardId(SourceSystemId)|EffectiveStartDate|AssignmentNumber|DirCardCompDefName|ComponentSequence
MERGE|CardComponent|HRC_SQLLOADER|E5369_EI|FR LDG|E5369_SD|2026/01/01|E5369|Employee Information|1
MERGE|CardComponent|HRC_SQLLOADER|E5369_WA|FR LDG|E5369_SD|2026/01/01|E5369|Work Accident|2


METADATA|ComponentDetail|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|DirCardCompId(SourceSystemId)|EffectiveStartDate|DirCardCompDefName|DirInformationCategory|FLEX:Deduction Developer DF|_DFS(Deduction Developer DF=HRX_FR_EMPLOYEE_INFO)|_EMPLOYEE_PENSION_SCHEME_Display(Deduction Developer DF=HRX_FR_EMPLOYEE_INFO)|_EMPLOYEE_SCHEME_Display(Deduction Developer DF=HRX_FR_EMPLOYEE_INFO)|_LOCAL_SCHEME_Display(Deduction Developer DF=HRX_FR_EMPLOYEE_INFO)|_RESIDENT_ABROAD(Deduction Developer DF=HRX_FR_EMPLOYEE_INFO)|socialSecurityCeilingReduction(Deduction Developer DF=HRX_FR_EMPLOYEE_INFO)|_STATE_PENSION(Deduction Developer DF=HRX_FR_EMPLOYEE_INFO)|_COMPLEMENTARY_PENSION(Deduction Developer DF=HRX_FR_EMPLOYEE_INFO)|residentAbroadTaxStatus_Display(Deduction Developer DF=HRX_FR_EMPLOYEE_INFO)|residentAbroadSsStatus_Display(Deduction Developer DF=HRX_FR_EMPLOYEE_INFO)|pensionnerStatus_Display(Deduction Developer DF=HRX_FR_EMPLOYEE_INFO)|riskCode_Display(Deduction Developer DF=ORA_HRX_FR_PREL_WA)
MERGE|ComponentDetail|HRC_SQLLOADER|E5369_SD_EI_DET|FR LDG|E5369_EI|2026/01/01|Employee Information|HRX_FR_EMPLOYEE_INFO|HRX_FR_EMPLOYEE_INFO|||General employee scheme|Other areas|Y|N|N|N|RAS Liable Nonresident Worker|Expatriate|No|
MERGE|ComponentDetail|HRC_SQLLOADER|E5369_SD_WA_DET|FR LDG|E5369_WA|2026/01/01|Work Accident|ORA_HRX_FR_PREL_WA|ORA_HRX_FR_PREL_WA||||||||||||602MD - 0.7

METADATA|CardAssociation|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|DirCardId(SourceSystemId)|EffectiveStartDate|TaxReportingUnitName
MERGE|CardAssociation|HRC_SQLLOADER|E5369_SD_TRU|FR LDG|E5369_SD|2026/01/01|FR TRU

METADATA|CardAssociationDetail|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|DirRepCardId(SourceSystemId)|EffectiveStartDate|AssociationAssignmentNumber
MERGE|CardAssociationDetail|HRC_SQLLOADER|E5369_SD_TRU_DED|FR LDG|E5369_SD_TRU|2026/01/01|E5369