Example of Loading Employee INFONAVIT

This example creates the Employee INFONAVIT component for the automatically generated Employee Tax Card for employee assignment E234116 on 1-Jan-23.

The calculation card is identified using user keys as the source key may be unknown for an auto-generated card. Source keys are used to identify the new card component, value definition and override value records.

The CalculationCard.dat file is used to upload the Employee Tax Card with HCM Data Loader.

METADATA|CalculationCard|SourceSystemOwner|DirCardDefinitionName|LegislativeDataGroupName|AssignmentNumber|EffectiveStartDate|CardSequence
MERGE|CalculationCard|VISION|Employee Tax Card|MX LDG|E234116|2023/01/01|1

METADATA|CardComponent|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|AssignmentNumber|EffectiveStartDate|DirCardCompDefName|DirCardDefinitionName|CardSequence
MERGE|CardComponent|VISION|ETC_234116_INF|MX LDG|E234116|2023/01/01|Employee INFONAVIT|Employee Tax Card|1

METADATA|CalculationValueDefinition|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|SourceId(SourceSystemId)|EffectiveStartDate|DirCardCompDefName|ValueDefinitionName
MERGE|CalculationValueDefinition|VISION|ETC_234116_INF_VD1|MX LDG|ETC_234116_INF|2023/01/01|Employee INFONAVIT|Discount Type
MERGE|CalculationValueDefinition|VISION|ETC_234116_INF_VD2|MX LDG|ETC_234116_INF|2023/01/01|Employee INFONAVIT|Credit Number
MERGE|CalculationValueDefinition|VISION|ETC_234116_INF_VD3|MX LDG|ETC_234116_INF|2023/01/01|Employee INFONAVIT|Credit Start date
MERGE|CalculationValueDefinition|VISION|ETC_234116_INF_VD4|MX LDG|ETC_234116_INF|2023/01/01|Employee INFONAVIT|Discount Value
MERGE|CalculationValueDefinition|VISION|ETC_234116_INF_VD5|MX LDG|ETC_234116_INF|2023/01/01|Employee INFONAVIT|Mexico SUA INFONAVIT Transaction

METADATA|EnterableCalculationValue|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|ValueDefnId(SourceSystemId)|EffectiveStartDate|Value1|ValueDefinitionName
MERGE|EnterableCalculationValue|VISION|ETC_234116_INF_VD1|MX LDG|ETC_234116_INF_VD1|2023/01/01|Fix quota in currency|Discount Type
MERGE|EnterableCalculationValue|VISION|ETC_234116_INF_VD2|MX LDG|ETC_234116_INF_VD2|2023/01/01|100123|Credit Number
MERGE|EnterableCalculationValue|VISION|ETC_234116_INF_VD3|MX LDG|ETC_234116_INF_VD3|2023/01/01|2023/01/01|Credit Start date
MERGE|EnterableCalculationValue|VISION|ETC_234116_INF_VD4|MX LDG|ETC_234116_INF_VD4|2023/01/01|20|Discount Value
MERGE|EnterableCalculationValue|VISION|ETC_234116_INF_VD5|MX LDG|ETC_234116_INF_VD5|2023/01/01|15 - Beginning of housing credit|Mexico SUA INFONAVIT Transaction