Guidelines for Loading Employee INFONAVIT for the Mexico Employee Tax Card
These are the guidelines for loading the INFONAVIT card component.
Employee INFONAVIT Card Component
The Employee INFONAVIT card component captures all housing loan related information which is needed to calculate employee INFONAVIT loan deductions.
Card Component Attributes for Employee INFONAVIT
| HCM Data Loader Attribute | Alternative User Key Attributes | Functional Description |
|---|---|---|
| SourceSystemId | CardSequence, ComponentSequence, AssignmentNumber, DirCardDefinitionName, LegislativeDataGroupName, DirCardCompDefName | A unique identifier for the Employee INFONAVIT card component. For new card components supply the source key attributes. You can also identify card components with the user key attributes. |
| SourceSystemOwner | N/A | The name of the source system owner used to generate the source system ID. |
| LegislativeDataGroupName | N/A | The name of the legislative data group for the card component definition. |
| DirCardId(SourceSystemId) | CardSequence, AssignmentNumber, DirCardDefinitionName, LegislativeDataGroupName | The parent Employee Tax Card calculation card should be
identified by using the same key type used to identify the
calculation card. When using source keys, supply this attribute with the value supplied for the calculation card’s SourceSystemId attribute. Otherwise, supply the user key attributes with the same values as the parent calculation card. |
| EffectiveStartDate | N/A | The start date of the Employee INFONAVIT card component, typically the employee’s start date. This must be on or after the EffectiveStartDate on the Employee Tax Card calculation card. |
| EffectiveEndDate | N/A | The end date is optional for the card component |
| DirCardCompDefName | N/A | The component definition name. Specify ‘Employee INFONAVIT’. |
| ComponentSequence | N/A | Specify ‘1’. |
Employee INFONAVIT Value Definitions
| Value Definition Name | Functional Description |
|---|---|
| Credit Number | Employee’s INFONAVIT credit number. |
| Credit Start Date | The start date of the credit. |
| Deduction Table | Specify Yes/No |
| Discount Type | The type of discount for the credit, such as percentage. Validated by lookup type ORA_HRX_MX_INFONAVIT_DISCOUNT. |
| Discount Value | The value of the discount. |
| Mexico SUA INFONAVIT Transaction | The SUA INFONAVIT transaction type. Validated by the lookup type ORA_HRX_MX_SUA_INFONAVIT_TRANS. |
| Use Integrated Daily Wage Cap | Specify Yes/No |
Calculation Value Definition Attributes for Employee INFONAVIT
The Calculation Value Definition record type specifies the name of the value definition you are supplying an override value for.
| HCM Data Loader Attribute | Alternative User Key Attributes | Functional Description |
|---|---|---|
| SourceSystemId | CardSequence, ComponentSequence, AssignmentNumber, DirCardDefinitionName, LegislativeDataGroupName, DirCardCompDefName | A unique identifier for the calculation value definition record. For new records supply the source key attributes. You can also identify calculation value definition records with the user key attributes. |
| SourceSystemOwner | N/A | The name of the source system owner used to generate the source system ID. |
| LegislativeDataGroupName | N/A | The name of the legislative data group for the card component definition. |
| SourceId(SourceSystemId) | CardSequence, ComponentSequence, AssignmentNumber, DirCardDefinitionName, LegislativeDataGroupName, DirCardCompDefName | The parent Employee INFORNAVIT card component should be referenced by using the same key type used to identify the card component. When using source keys, supply this attribute with the value supplied for the card component’s SourceSystemId attribute. Otherwise, supply the user key attributes with the same values as the parent card component. |
| EffectiveStartDate | N/A | The start date of the parent Employee INFONAVIT card component or the date the calculation value definition starts, if later. |
| DirCardCompDefName | N/A | The definition name of the parent Employee INFONAVIT card component. Specify the same value as provided on the parent card component record. |
| ValueDefinitionName | N/A | The name of the value being overridden. The list of value definitions applicable to this card component are listed above. |
Enterable Calculation Value Attributes for Employee INFONAVIT
These attributes are supplied against the CalculationValueDefinition file discriminator and must be supplied along with a CardComponent record for the parent Employee INFONAVIT card component and a CalculationCard record for the owning Employee Tax Card.
| HCM Data Loader Attribute | Alternative User Key Attributes | Functional Description |
|---|---|---|
| SourceSystemId | CardSequence, ComponentSequence, AssignmentNumber, DirCardDefinitionName, LegislativeDataGroupName, DirCardCompDefName | A unique identifier for the enterable calculation value record. For new records supply the source key attributes. You can also identify calculation value definition records with the user key attributes. |
| SourceSystemOwner | N/A | The name of the source system owner used to generate the source system ID. |
| LegislativeDataGroupName | N/A | The name of the legislative data group for the override value. |
| ValueDefnId(SourceSystemId) | CardSequence, ComponentSequence, AssignmentNumber, DirCardDefinitionName, LegislativeDataGroupName, DirCardCompDefName, ValueDefinitionName | Identify the parent Calculation Value Definition record using the
same key type used to identify the calculation value definition.
When using source keys, supply this attribute with the value supplied for the calculation value definition’s SourceSystemId attribute. Otherwise, supply the user key attributes with the same values as the parent record. |
| EffectiveStartDate | N/A | The effective start date of the parent calculation value definition record, or the update to the override value if supplying date-effective history. |
| EffectiveEndDate | N/A | The optional end date of the override value, or if you are providing date-effective history, the last day of the date-effective changes |
| Value1 | N/A | The value for the value definition identified by the parent
calculation value definition record. Unlike other calculation cards, if you supply a value definition but have no value for it supply ‘-999999999’ to indicate a null value. |