Guidelines for Loading Employee Social Insurance Details for Qatar
You must have one Calculation Card record for every Qatar employee and TRU they report to.
Even if you are updating an existing Employee Social Insurance 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.
Employee Social Insurance Details Calculation Card Attributes
| HCM Data Loader Attribute | Alternative User Key Attributes | Functional Description |
|---|---|---|
| SourceSystemId | CardSequence, AssignmentNumber, DirCardDefinitionName, LegislativeDataGroupName | A unique identifier for the Employee Social Insurance 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 ‘Employee Social Insurance 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. |
| CardSeqeunce | 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. |
Employee Social Insurance Details Card Component
The Social Insurance Details card component captures social insurance related information. It is created for you if the Employee Social Insurance Details card is autogenerated. If you need to update the defaulted social insurance information, provide an Social Insurance Details card component and related Component Detail.
Card Component Attributes for Social Insurance Details Information
| HCM Data Loader Attribute | Alternative User Key Attributes | Functional Description |
|---|---|---|
| SourceSystemId | CardSequence, ComponentSequence, AssignmentNumber, DirCardDefinitionName, LegislativeDataGroupName, DirCardCompDefName | A unique identifier for the Social Insurance 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 Employee Social Insurance 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 Social Insurance Details card component, typically the employee’s start date. This must be the same as the EffectiveStartDate on the Employee Social Insurance Details calculation card. |
| EffectiveEndDate | N/A | The end date is optional for the card component |
| DirCardCompDefName | N/A | The component definition name. Specify ‘Social Insurance Details’. |
| ComponentSequence | N/A | Specify '1' Note: A number to uniquely identify this card
component when multiple card components for the same card
component definition exist on the same card. Not required when
source keys are used. |
Component Detail Attributes for Social Insurance Details
Social Insurance Details uses three flexfield contexts. 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:
- Qatar Employee Social Insurance Details (ORA_HRX_QA_SI_PREL)
- Qatar Social Insurance Contributory Salary Override (ORA_HRX_QA_SI_CONT_SAL_ADJ_PREL)
- Qatar Social Insurance Contributory Salary Adjustment (ORA_HRX_QA_SI_CONT_SAL_ADJ_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 Social Insurance 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 Social Insurance 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 ‘ORA_HRX_QA_SI_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. |