1. HCM Data Loading Business Objects
  2. Example of Loading Provincial Medical and Worker Compensation for Ontario

Example of Loading Provincial Medical and Worker Compensation for Ontario

The following Organization.dat file uploads both Provincial Medical and Worker Compensation information against an existing PSU for Ontario.

A separate OrgInformation record is supplied for each flexfield context:

Provincial Medical:

  • Ontario Provincial Medical Account Details (ORA_HRX_CA_PSU_PM_ON_DETAIL)

Workers Compensation:

  • Ontario Account Details (ORA_HRX_CA_PSU_WC_ON_DETAIL)
  • Ontario Workers Compensation (ORA_HRX_CA_PSU_PM_ON_HEADER)

The flexfield attribute oraCalcLaibPayroll, available on the Ontario Workers Compensation flexfield context is only required for Ontario. It’s an option to calculate the liability in the payroll run for Ontario, with valid values of Y or N.

METADATA|Organization|EffectiveStartDate|Name|ClassificationName
MERGE|Organization|2001/01/01|CA PSU|Payroll Statutory Unit

METADATA|OrgUnitClassification|EffectiveStartDate|OrganizationName|ClassificationName|LegislationCode|CategoryCode|Status
MERGE|OrgUnitClassification|2001/01/01|CA PSU|Payroll Statutory Unit|CA|HCM_PSU_CA|A

METADATA|OrgInformation|EffectiveStartDate|OrganizationName|ClassificationName|LegislationCode|EFF_CATEGORY_CODE|FLEX:PER_ORGANIZATION_INFORMATION_EFF|OrgInformationContext|SequenceNumber|OrgUnitClassificationId|oraHrxCaOnUnique(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_WC_ON_DETAIL)|oraHrxCaOnAcctNumber(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_WC_ON_DETAIL)|oraHrxCaOnAcctName(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_WC_ON_DETAIL)|oraHrxCaOnDefault(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_WC_ON_DETAIL)|oraHrxCaOnClUnit(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_WC_ON_DETAIL)|oraHrxCaOnClUnitDesc(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_WC_ON_DETAIL)|oraHrxCaOnRate(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_WC_ON_DETAIL)|oraHrxCaOnDefaultRate(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_WC_ON_DETAIL)|oraHrxCaOnPmUnique(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_PM_ON_DETAIL)|oraHrxCaOnPmAcctNumber(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_PM_ON_DETAIL)|oraHrxCaOnPmAcctName(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_PM_ON_DETAIL)|oraHrxCaOnPmDefaultAcct(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_PM_ON_DETAIL)|oraHrxCaOnPmStartAnnPay(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_PM_ON_DETAIL)|oraHrxCaOnPmEndAnnPay(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_PM_ON_DETAIL)|oraHrxCaOnPmRate(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_PM_ON_DETAIL)|oraCalcLaibPayroll(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_PM_ON_HEADER)
MERGE|OrgInformation|2001/01/01|CA PSU|Payroll Statutory Unit|CA|HCM_PSU_CA|ORA_HRX_CA_PSU_WC_ON_DETAIL|ORA_HRX_CA_PSU_WC_ON_DETAIL|1||1|ONWC0001|ON WC Account1|Y|ONCU0001|Classification Unit1|1|Y||||||||
MERGE|OrgInformation|2001/01/01|CA PSU|Payroll Statutory Unit|CA|HCM_PSU_CA|ORA_HRX_CA_PSU_PM_ON_DETAIL|ORA_HRX_CA_PSU_PM_ON_DETAIL|1||||||||||1|ONPM0001|ON PM Account1|Y|0|999999999999.99|4|
MERGE|OrgInformation|2001/01/01|CA PSU|Payroll Statutory Unit|CA|HCM_PSU_CA|ORA_HRX_CA_PSU_PM_ON_HEADER|ORA_HRX_CA_PSU_PM_ON_HEADER|1|||||||||||||||||Y