1. HCM Data Loading Business Objects
  2. Guidelines for Loading Canadian Provincial Medical Account Overrides at the Location Level

Guidelines for Loading Canadian Provincial Medical Account Overrides at the Location Level

Provincial Medical account overrides at the location level are created using the Location HCM Data Loader business object.

To upload Provincial Medical account overrides these components of the Location object hierarchy are used:

Component Functional Description File Discriminator
Location The location to override Provincial Medical data for. Location
Location Legislative Extra Information Provincial Medical Account 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.

Provincial Medical:

Provincial Medical account overrides at the location level are held on the on HCM_LOC_LEG flexfield category with this flexfield context:

  • Canada Provincial Medical Location Information (ORA_HRX_CA_PM_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.
JobCode The code that identifies the overridden 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_PM_LOC’
InformationCategory The flexfield context code, specify ‘ORA_HRX_CA_PM_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 Provincial Medical Accounts for Overrides for a report that extracts the values required for the PSU and account flexfield segment attributes..

Example of Loading Provincial Medical Overrides against a Location

This Location.dat file will update the existing Manitoba location to define the Provincial Medical Account override.

METADATA|Location|EffectiveStartDate|SetCode|LocationCode
MERGE|Location|2018/01/01|COMMON|Manitoba, CA

METADATA|LocationLegislative|EffectiveStartDate|SetCode|LocationCode|LegislationCode|EFF_CATEGORY_CODE|FLEX:PER_LOCATION_LEG_EFF|LleInformationCategory|SequenceNumber|oraHrxCaPmLocUniqueSeg(PER_LOCATION_LEG_EFF=ORA_HRX_CA_PM_LOC)|oraHrxCaPmLocPsu(PER_LOCATION_LEG_EFF=ORA_HRX_CA_PM_LOC)|oraHrxCaPmLocAccount(PER_LOCATION_LEG_EFF=ORA_HRX_CA_PM_LOC)
MERGE|LocationLegislative|2018/01/01|COMMON|Manitoba, CA|CA|HCM_LOC_LEG|ORA_HRX_CA_PM_LOC|ORA_HRX_CA_PM_LOC|1|1|300100023301253|MBP22222