Guidelines for Updating End of Service Details for UAE
You must have one Calculation Card record for every terminated UAE employee you are maintaining End of Service details for.
Even if you are updating an existing End of Service Details card and the calculation card itself isn’t being updated, you must still include the calculation card record to group other related data supplied in the file.
End of Service Details Calculation Card Attributes
| HCM Data Loader Attribute | Alternative User Key Attributes | Functional Description |
|---|---|---|
| SourceSystemId | CardSequence, AssignmentNumber, DirCardDefinitionName, LegislativeDataGroupName | A unique identifier for the End of Service Details calculation card. For new calculation card supply the source key attributes. You can also identify calculation cards 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 calculation card. |
| DirCardDefinitionName | N/A | The name of the card definition. Specify ‘End of Service Details’ |
| AssignmentId(SourceSystemId) | AssignmentNumber | Either supply the source system ID, or assignment number that identifies the employee assignment this calculation card is for. |
| EffectiveStartDate | N/A | The start date of the calculation card, typically the employee’s start date. |
| CardSequence | N/A | A number to uniquely identify this card when multiple calculation cards for the same card definition exist for the employee. Not required when source keys are used. |
Gratuity Details Card Component
The Gratuity Details card component captures the gratuity override amount and payment date information. It is created for you if the End of Service Details card is autogenerated. If you need to override the gratuity amount, provide a Gratuity Details card component and related Component Detail.
Card Component Attributes for Gratuity Details
| HCM Data Loader Attribute | Alternative User Key Attributes | Functional Description |
|---|---|---|
| SourceSystemId | CardSequence, ComponentSequence, AssignmentNumber, DirCardDefinitionName, LegislativeDataGroupName, DirCardCompDefName | A unique identifier for the Gratuity Details 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 End of Service Details 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 Gratuity Details card component, typically the employee’s start date. This must be the same or later than the EffectiveStartDate on the End of Service Details calculation card. |
| EffectiveEndDate | N/A | The end date is optional for the card component |
| DirCardCompDefName | N/A | The component definition name. Specify ‘Gratuity Details’. |
| ComponentSequence | N/A | Specify '1' |
Component Detail Attributes for Gratuity Details
Gratuity Details card component uses one flexfield context. Use the Component Detail record type to load the flexfield segment values.
In addition to the attributes defined here, include the necessary flexfield segment attribute values for these flexfield contexts:
- Gratuity Details (HRX_AE_GRATUITY_PREL)
| HCM Data Loader Attribute | Alternative User Key Attributes | Functional Description |
|---|---|---|
| SourceSystemId | CardSequence, ComponentSequence, DirInformationCategory, LegislativeDataGroupName, AssignmentNumber, DirCardDefinitionName, DirCardCompDefName | A unique identifier for the component detail. For new component detail records 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. |
| DirCardCompId(SourceSystemId) | CardSequence, ComponentSequence, AssignmentNumber, DirCardDefinitionName, LegislativeDataGroupName, DirCardCompDefName | The parent Gratuity Details card component should be referenced
using the same key type used to identify the parent record. 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 component detail, or update to the component detail if you are providing date-effective history. This must be after or equal to the EffectiveStartDate provided for the Gratuity Details card component. |
| EffectiveEndDate | N/A | The optional end date of the component detail, or if you are providing date-effective history the last day of the date-effective changes. |
| DirCardCompDefName | N/A | The name of the card component this detail is for. This is used to identify the flexfield context and should be supplied even when a source key is used to identify the parent card component. |
| DirInformationCategory | N/A | The code for the flexfield context, such as ‘HRX_AE_GRATUITY_PREL’. Flexfield context codes are visible on the Flexfield Attributes tab of the View Business Objects task. |
| FLEX:Deduction DeveloperDF | N/A | Supply the same value as for the DirInformationCategory attribute. |
End of Service Details Card Component
The End of Service Details card component is mainly used for reporting Form 2 terminations and submitted to the social insurance office.
Card Component Attributes for End of Service Details
| HCM Data Loader Attribute | Alternative User Key Attributes | Functional Description |
|---|---|---|
| SourceSystemId | CardSequence, ComponentSequence, AssignmentNumber, DirCardDefinitionName, LegislativeDataGroupName, DirCardCompDefName | A unique identifier for the End of Service Details 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 End of Service Details 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 End of Service Details card component, typically the employee’s start date. This must be the same or later than the EffectiveStartDate on the End of Service Details calculation card. |
| EffectiveEndDate | N/A | The end date is optional for the card component |
| DirCardCompDefName | N/A | The component definition name. Specify ‘End of Service Details’. |
| ComponentSequence | N/A | Specify '1' |
Component Detail Attributes for End of Service Details
End of Service Details card component uses one flexfield context. Use the Component Detail record type to load the flexfield segment values.
In addition to the attributes defined here, include the necessary flexfield segment attribute values for these flexfield contexts:
- End of Service Details (HRX_AE_EOS_PREL)
| HCM Data Loader Attribute | Alternative User Key Attributes | Functional Description |
|---|---|---|
| SourceSystemId | CardSequence, ComponentSequence, DirInformationCategory, LegislativeDataGroupName, AssignmentNumber, DirCardDefinitionName, DirCardCompDefName | A unique identifier for the component detail. For new component detail records 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. |
| DirCardCompId(SourceSystemId) | CardSequence, ComponentSequence, AssignmentNumber, DirCardDefinitionName, LegislativeDataGroupName, DirCardCompDefName | The parent End of Service Details card component should be
referenced using the same key type used to identify the parent
record. 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 component detail, or update to the component detail if you are providing date-effective history. This must be after or equal to the EffectiveStartDate provided for the End of Service Details card component. |
| EffectiveEndDate | N/A | The optional end date of the component detail, or if you are providing date-effective history the last day of the date-effective changes. |
| DirCardCompDefName | N/A | The name of the card component this detail is for. This is used to identify the flexfield context and should be supplied even when a source key is used to identify the parent card component. |
| DirInformationCategory | N/A | The code for the flexfield context, such as ‘HRX_AE_EOS_PREL. Flexfield context codes are visible on the Flexfield Attributes tab of the View Business Objects task. |
| FLEX:Deduction DeveloperDF | N/A | Supply the same value as for the DirInformationCategory attribute. |