Guidelines for Loading Canadian Workers Compensation Overrides at the Location Level

Workers Compensation overrides at the location level are created using the Location HCM Data Loader business object.

Component Functional Description File Discriminator
Location The location to override Workers Compensation data for. Location
Location Legislative Extra Information Worker Compensation details are held within flexfield segments and are loaded by the LocationLegislative record. LocationLegislative

Location Attributes

Supply one Location record for each location to provide overrides for.

The Location record uses these attributes to identify the existing location you are updating:

HCM Data Loader Attribute Functional Description
EffectiveStartDate The start date of the location override.
SetCode The set code of the location override. The default is 'COMMON'.
LocationCode The code that identifies the location override.

Location Legislative Extra Information Attributes

Supply one LocationLegislative component record for each location to provide overrides for. These are held on the PER_LOCATION_LEG_EFF flexfield.

The attributes to supply are different for Provincial Medical and Workers Compensation overrides.

Workers Compensation

Workers Compensation overrides at the location level are held on the on HCM_LOC_LEG flexfield category with this flexfield context:

  • Canada Workers Compensation Location Information (ORA_HRX_CA_WC_LOC)

Supply these attributes:

HCM Data Loader Attribute Functional Description
EffectiveStartDate The start date of the Workers Compensation override information.
SetCode The set code of the location override. Specify the same value as in the SetCode of the Location component record.
LocationCode The code that identifies the location. Specify the same value as in the LocationCode of the Location component record.
LegislationCode The code of the legislation. Specify ‘CA’.
EFF_CATEGORY_CODE The flexfield context category code that is used to supply the Workers Compensation overrides. Specify ‘HCM_LOC_LEG‘.
FLEX:PER_JOBS_LEG_EFF The flexfield context code, specify ‘ORA_HRX_CA_WC_LOC’
InformationCategory The flexfield context code, specify ‘ORA_HRX_CA_WC_LOC’
SequenceNumber 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.
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.
oraHrxCaWcLocUniqueSeg(PER_LOCATION_LEG_EFF= ORA_HRX_CA_WC_LOC) 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.
oraHrxCaWcLocPsu(PER_LOCATION_LEG_EFF= ORA_HRX_CA_WC_LOC) The ID used to identify the Payroll Statutory Unit override value of the component record.
oraHrxCaWcLocClUnit(PER_LOCATION_LEG_EFF= ORA_HRX_CA_WC_LOC) The Workers Compensation Classification Unit override value of the component record.
Note: 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>).
Note: Refer to the Cloud Customer Connect topic: BI Publisher Report: Canada Workers Compensation Classification Units for Overrides for a report that extracts the values required for the PSU and Classification Unit flexfield segment attributes.