Guidelines for Loading Canadian Workers Compensation Overrides at the Department Level
Workers Compensation overrides at the department level are created using the Organization HCM Data Loader business object.
To upload Workers Compensation overrides, these components of the Organization object hierarchy are used:
| Component | Functional Description | File Discriminator |
|---|---|---|
| Organization | The department to override Workers Compensation data for. | Organization |
| Organization Classification | The organization classification. This is required even if the organization exists and is already defined as a department. | OrgUnitClassification |
| Organization Extra Information | Worker Compensation account details are held within flexfield segments and are loaded by the OrgInformation record. | OrgInformation |
Organization Attributes
Supply one Organization record for each department you are providing Provincial Medical account override details for.
| HCM Data Loader Attribute | Functional Description |
|---|---|
| EffectiveStartDate | The start date of the department override. |
| Name | The name of the department override. |
| ClassificationName | The name of the organization classification. Specify ‘DEPARTMENT’ |
Organization Classification Attributes
Supply one OrgUnitClassification record for each department you are providing Workers Compensation override details for. The OrgUnitClassification record type requires these attributes:
| HCM Data Loader Attribute | Functional Description |
|---|---|
| EffectiveStartDate | The start date of the department classification override. |
| OrganizationName | The name of the department to override. This must match the value supplied to the Name attribute on the parent Organization record. |
| ClassificationName | The name of the department classification. Specify ‘DEPARTMENT’. |
Organization Extra Information Attributes
Supply one OrgInformation record for each department to provide overrides for. These are held in the PER_ORGANIZATION_INFORMATION_EFF flexfield.
The attributes to supply are different for Provincial Medical and Workers Compensation overrides.
Workers Compensation:
Workers Compensation overrides at the department level are held on the on DEPARTMENT flexfield category with this flexfield context:
- Canada Workers Compensation Department Information (ORA_HRX_CA_WC_DEPT)
Supply these attributes:
| HCM Data Loader Attribute | Functional Description |
|---|---|
| EffectiveStartDate | The start date of the department override information. |
| OrganizationName | The name of the department. This must match the value supplied to the Name attribute on the parent Organization record. |
| ClassificationCode | The classification code of the component record for the override. Specify ‘DEPARTMENT’. |
| ClassificationName | The name of the organization classification. Specify ‘DEPARTMENT’. |
| SequenceNumber | The sequence number for the classification component record.
Enter a unique number for each record of this type. If multiple rows
for the same type, increase each row number by 1. Note: This is
sequential according to the component context. For example, if
loading 2 provincial medical records and 1 for workers
compensation, populate 1 and 2 for the provincial medical
records and 1 for the workers compensation
record. |
| EFF_CATEGORY_CODE | The flexfield context category code that is used to supply the Workers Compensation overrides. Specify ‘DEPARTMENT’. |
| FLEX:PER_ORGANIZATION_INFORMATION_EFF | The flexfield context code that is used to supply the Workers Compensation overrides. Specify ‘ORA_HRX_CA_PM_DEPT’. |
| OrgInformationContext | Supply the same value as the FLEX:PER_ORGANIZATION_INFORMATION_EFF attribute value. |
| oraHrxCaWcDeptUniqueSeg(PER_ORGANIZATION_INFORMATION_EFF =ORA_HRX_CA_WC_DEPT) | The sequence number for the component record. Enter a unique number for each record of this type. If multiple rows for the same type, increase each row number by 1. |
| oraHrxCaWcDeptPsu(PER_ORGANIZATION_INFORMATION_EFF =ORA_HRX_CA_WC_DEPT) | The ID used to identify the Payroll Statutory Unit. |
| oraHrxCaWcDeptProv(PER_ORGANIZATION_INFORMATION_EFF =ORA_HRX_CA_WC_DEPT) | The geocode that identifies the Workers Compensation Province override value. |
| oraHrxCaWcDeptClUnit(PER_ORGANIZATION_INFORMATION_EFF =ORA_HRX_CA_WC_DEPT) | The Workers Compensation Classification Unit override value of
the component record. Note: For the Workers Compensation override
value, this is a combination of the Workers Compensation Account
Number and Classification Unit value, concatenated with an
underscore value (for example, <Account
Number>_<Classification Unit>). |