Example of Creating a Statutory Deductions and Reporting Card for Netherlands

In this example the complete Statutory Deductions and Reporting card with associations is created for employee assignment E1414.

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

METADATA|CalculationCard|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|DirCardDefinitionName|EffectiveStartDate|AssignmentNumber
MERGE|CalculationCard|HRC_SQLLOADER|E1414_SD|NL LDG|Statutory Deductions and Reporting|2023/01/01|E1414

METADATA|CardComponent|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|DirCardId(SourceSystemId)|EffectiveStartDate|DirCardCompDefName|Context1|ParentDirCardCompId(SourceSystemId)
MERGE|CardComponent|HRC_SQLLOADER|E1414_SD_TX|NL LDG|E1414_SD|2023/01/01|Tax|NL Tax Reporting Unit|
MERGE|CardComponent|HRC_SQLLOADER|E1414_SD_STX|NL LDG|E1414_SD|2023/01/01|Special-Rate Tax||E1414_SD_TX
MERGE|CardComponent|HRC_SQLLOADER|E1414_SD_SI|NL LDG|E1414_SD|2023/01/01|Social Insurance||
MERGE|CardComponent|HRC_SQLLOADER|E1414_SD_SF|NL LDG|E1414_SD|2023/01/01|Sector Fund WW|1 - 01|E1414_SD_SI

METADATA|ComponentDetail|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|DirCardCompId(SourceSystemId)|EffectiveStartDate|DirCardCompDefName|DirInformationCategory|FLEX:Deduction Developer DF|_INCOME_CODE(Deduction Developer DF=HRX_NL_STD_TAX)|_TAX_TYPE(Deduction Developer DF=HRX_NL_STD_TAX)|_TAX_TABLE(Deduction Developer DF=HRX_NL_STD_TAX)|_PAYROLL_PERIOD(Deduction Developer DF=HRX_NL_STD_TAX)|_ZVW_INSURED(Deduction Developer DF=HRX_NL_SOCIAL_INSURANCE_INFO)|_WAO_DISCOUNT_ELIGIBLE(Deduction Developer DF=HRX_NL_SOCIAL_INSURANCE_INFO)|oraHrxNlNoRiskZwPol(Deduction Developer DF=HRX_NL_SOCIAL_INSURANCE_INFO)
MERGE|ComponentDetail|HRC_SQLLOADER|E1414_SD_TAX|NL LDG|E1414_SD_TX|2023/01/01|Tax|HRX_NL_STD_TAX|HRX_NL_STD_TAX|22|3|2|2|||
MERGE|ComponentDetail|HRC_SQLLOADER|E1414_SD_PREL|NL LDG|E1414_SD_SI|2023/01/01|Social Insurance|HRX_NL_SOCIAL_INSURANCE_INFO|HRX_NL_SOCIAL_INSURANCE_INFO|||||M|Y|Y

METADATA|CardAssociation|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|DirCardId(SourceSystemId)|EffectiveStartDate|TaxReportingUnitName
MERGE|CardAssociation|HRC_SQLLOADER|E1414_SD_TRU|NL LDG|E1414_SD|2023/01/01|NL Tax Reporting Unit

METADATA|CardAssociationDetail|SourceSystemOwner|SourceSystemId|DirRepCardId(SourceSystemId)|DirCardCompId(SourceSystemId)|EffectiveStartDate|AssociationAssignmentNumber
MERGE|CardAssociationDetail|HRC_SQLLOADER|E1414_SD_ASS|E1414_SD_TRU|E1414_SD_SF|2023/01/01|E1414