Guidelines for Loading Canadian Provincial Medical Account Overrides at the Department Level
Provincial Medical account overrides at the department level are created using the Organization HCM Data Loader business object.
To upload Provincial Medical account overrides, these components of the Organization object hierarchy are used:
Component | Functional Description | File Discriminator |
---|---|---|
Organization | The department to override Provincial Medical 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 | Provincial Medical 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 Provincial Medical 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.
Provincial Medical:
Provincial Medical account overrides at the department level are held on the on DEPARTMENT flexfield category with this flexfield context:
- Canada Provincial Medical Department Information (ORA_HRX_CA_PM_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. |
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. |
oraHrxCaPmDeptUniqueSeg(PER_ORGANIZATION_INFORMATION_EFF =ORA_HRX_CA_PM_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 |
oraHrxCaPmDeptPsu(PER_ORGANIZATION_INFORMATION_EFF =ORA_HRX_CA_PM_DEPT) | The ID used to identify the Payroll Statutory Unit. |
oraHrxCaPmDeptProv(PER_ORGANIZATION_INFORMATION_EFF =ORA_HRX_CA_PM_DEPT) | The geocode that identifies the Provincial Medical Province override value. |
oraHrxCaPmDeptAccount(PER_ORGANIZATION_INFORMATION_EFF =ORA_HRX_CA_PM_DEPT) | The Provincial Medical Account Workers Compensation Classification Unit override value of the component record. |