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