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