Examples of Loading Tax Withholding Pennsylvania PSD
Here's an example where HCM Data Loader is used to load the Pennsylvania PSD card component of the Tax Withholding card.
The CalculationCard.dat file is used to bulk-load Reporting Information cards with HCM Data Loader.
Source Key Example
Source keys are used to identify the Pennsylvania PSD card component, the calculation value definitions and enterable calculation value records. The parent Tax Withholding calculation card is also referenced using its source key, using the DirCardId attribute with the SourceSystemId hint. It is recommended that you supply records for all override values, so that you know the source key value when you maintain these values later.
METADATA|CalculationCard|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|EffectiveStartDate|DirCardDefinitionName|CardSequence|AssignmentId(SourceSystemId)
MERGE|CalculationCard|VISION|TW_5654332|US LDG|2020/03/08|Tax Withholding|1|5654332E
METADATA|CardComponent|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|EffectiveStartDate|DirCardId(SourceSystemId)|DirCardCompDefName|ComponentSequence|Context1|Context2
MERGE|CardComponent|VISION|PSD_5654332|US LDG|2020/03/08|TW_5654332|Pennsylvania PSD|1|39|300100003151520
METADATA|CalculationValueDefinition|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|EffectiveStartDate|SourceId(SourceSystemId)|Context1|ValueDefinitionName
MERGE|CalculationValueDefinition|VISION|PSD_RES_PSD_5654332|US LDG|2020/03/08|PSD_5654332|39|Resident PSD Code
MERGE|CalculationValueDefinition|VISION|PSD_RES_SCH_5654332|US LDG|2020/03/08|PSD_5654332|39|Resident School District
MERGE|CalculationValueDefinition|VISION|PSD_WRK_PSD_5654332|US LDG|2020/03/08|PSD_5654332|39|Work PSD Code
MERGE|CalculationValueDefinition|VISION|PSD_WRK_SCH_5654332|US LDG|2020/03/08|PSD_5654332|39|Work School District
METADATA|EnterableCalculationValue|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|EffectiveStartDate|ValueDefnId(SourceSystemId)|Value1
MERGE|EnterableCalculationValue|VISION|PSD_RES_PSD_5654332|US LDG|2020/03/08|PSD_RES_PSD_5654332|700102
MERGE|EnterableCalculationValue|VISION|PSD_RES_SCH_5654332|US LDG|2020/03/08|PSD_RES_SCH_5654332|2745
MERGE|EnterableCalculationValue|VISION|PSD_WRK_PSD_5654332|US LDG|2020/03/08|PSD_WRK_PSD_5654332|732001
MERGE|EnterableCalculationValue|VISION|PSD_WRK_SCH_5654332|US LDG|2020/03/08|PSD_WRK_SCH_5654332|2960
User Key Example
User keys are used to identify the parent Tax Withholding card and all records within the Pennsylvania PSD card component.
METADATA|CalculationCard|LegislativeDataGroupName|EffectiveStartDate|DirCardDefinitionName|CardSequence|AssignmentNumber
MERGE|CalculationCard|US LDG|2020/01/01|Tax Withholding|1|E53201
METADATA|CardComponent|LegislativeDataGroupName|EffectiveStartDate|DirCardDefinitionName|CardSequence|AssignmentNumber|DirCardCompDefName|ComponentSequence|Context1|Context2
MERGE|CardComponent|US LDG|2020/01/01|Tax Withholding|1|E53201|Pennsylvania PSD|1|39|300100003151520
METADATA|CalculationValueDefinition|LegislativeDataGroupName|EffectiveStartDate|DirCardDefinitionName|CardSequence|AssignmentNumber|DirCardCompDefName|ComponentSequence|Context1|Context2|ValueDefinitionName
MERGE|CalculationValueDefinition|US LDG|2020/01/01|Tax Withholding|1|E53201|Pennsylvania PSD|1|39||Resident PSD Code
MERGE|CalculationValueDefinition|US LDG|2020/01/01|Tax Withholding|1|E53201|Pennsylvania PSD|1|39||Resident School District
MERGE|CalculationValueDefinition|US LDG|2020/01/01|Tax Withholding|1|E53201|Pennsylvania PSD|1|39||Work PSD Code
MERGE|CalculationValueDefinition|US LDG|2020/01/01|Tax Withholding|1|E53201|Pennsylvania PSD|1|39||Work School District
METADATA|EnterableCalculationValue|LegislativeDataGroupName|EffectiveStartDate|DirCardDefinitionName|CardSequence|AssignmentNumber|DirCardCompDefName|ComponentSequence|ValueDefinitionName|Value1
MERGE|EnterableCalculationValue|US LDG|2020/01/01|Tax Withholding|1|E53201|Pennsylvania PSD|1|Resident PSD Code|700102
MERGE|EnterableCalculationValue|US LDG|2020/01/01|Tax Withholding|1|E53201|Pennsylvania PSD|1|Resident School District|2745
MERGE|EnterableCalculationValue|US LDG|2020/01/01|Tax Withholding|1|E53201|Pennsylvania PSD|1|Work PSD Code|732001
MERGE|EnterableCalculationValue|US LDG|2020/01/01|Tax Withholding|1|E53201|Pennsylvania PSD|1|Work School District|2960