1. HCM Data Loading Business Objects
  2. Example of Updating Employee Tax Cards for Mexico

Example of Updating Employee Tax Cards for Mexico

This example updates an auto-generated Employee Tax Card card to override Employee ISR Tax and Employee Social Security values.

User keys are used to identify the card and card component as the source keys may not be known for auto-generated cards. Use the CalculationCard.dat file to update Employee Tax Card card component information with HCM Data Loader.

The Employee ISR Tax card component is updated, overriding this value:

Value Definition Value
Pay Subsidy For Employment No

The Employee Social Security card component is updated, overriding these values:

Value Definition Value
Additional Quota Exempt No
Additional Quota Percentage 1 
METADATA|CalculationCard|LegislativeDataGroupName|DirCardDefinitionName|EffectiveStartDate|AssignmentNumber|CardSequence
MERGE|CalculationCard|MX LDG|Employee Tax Card|2023/01/01|E1515|1

METADATA|CardComponent|LegislativeDataGroupName|DirCardDefinitionName|EffectiveStartDate|AssignmentNumber|DirCardCompDefName|CardSequence|ComponentSequence
MERGE|CardComponent|MX LDG|Employee Tax Card|2023/01/01|E1515|Employee ISR Tax|1|1
MERGE|CardComponent|MX LDG|Employee Tax Card|2023/01/01|E1515|Employee Taxation|1|1
MERGE|CardComponent|MX LDG|Employee Tax Card|2023/01/01|E1515|Employee Social Security|1|1

METADATA|CalculationValueDefinition|LegislativeDataGroupName|DirCardDefinitionName|EffectiveStartDate|AssignmentNumber|DirCardCompDefName|CardSequence|ComponentSequence|ValueDefinitionName
MERGE|CalculationValueDefinition|MX LDG|Employee Tax Card|2023/01/01|E1515|Employee ISR Tax|1|1|Pay Subsidy For Employment
MERGE|CalculationValueDefinition|MX LDG|Employee Tax Card|2023/01/01|E1515|Employee Social Security|1|1|Additional Quota Exempt
MERGE|CalculationValueDefinition|MX LDG|Employee Tax Card|2023/01/01|E1515|Employee Social Security|1|1|Additional Quota Percentage

METADATA|EnterableCalculationValue|LegislativeDataGroupName|DirCardDefinitionName|EffectiveStartDate|AssignmentNumber|DirCardCompDefName|CardSequence|ComponentSequence|ValueDefinitionName|Value1
MERGE|EnterableCalculationValue|MX LDG|Employee Tax Card|2023/01/01|E1515|Employee ISR Tax|1|1|Pay Subsidy For Employment|No
MERGE|EnterableCalculationValue|MX LDG|Employee Tax Card|2023/01/01|E1515|Employee Social Security|1|1|Additional Quota Exempt|No
MERGE|EnterableCalculationValue|MX LDG|Employee Tax Card|2023/01/01|E1515|Employee Social Security|1|1|Additional Quota Percentage|0.1