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

Example of Loading Provincial Medical and Worker Compensation for Quebec

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

A separate OrgInformation record is supplied for each flexfield context:

Provincial Medical:

  • Quebec Provincial Medical Account Details (ORA_HRX_CA_PSU_PM_QC_DETAIL)

Workers Compensation:

  • Quebec Account Details (ORA_HRX_CA_PSU_WC_QC_DETAIL)
Note: The Provincial Medical Account Number and Provincial Medical Account Name are not captured for the Quebec Provincial Medical Account Details flexfield context.
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|SequenceNumber|EFF_CATEGORY_CODE|FLEX:PER_ORGANIZATION_INFORMATION_EFF|OrgInformationContext|oraHrxCaQcUnique(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_WC_QC_DETAIL)|oraHrxCaQcAcctNumber(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_WC_QC_DETAIL)|oraHrxCaQcAcctName(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_WC_QC_DETAIL)|oraHrxCaQcDefault(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_WC_QC_DETAIL)|oraHrxCaQcClUnit(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_WC_QC_DETAIL)|oraHrxCaQcClUnitDesc(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_WC_QC_DETAIL)|oraHrxCaQcRate(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_WC_QC_DETAIL)|oraHrxCaQcDefaultRate(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_WC_QC_DETAIL)|oraHrxCaQcPmStartAnnPay(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_PM_QC_DETAIL)|oraHrxCaQcPmEndAnnPay(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_PM_QC_DETAIL)|oraHrxCaQcPmRate(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_PM_QC_DETAIL)
MERGE|OrgInformation|2001/01/01|CA PSU|Payroll Statutory Unit|CA|1|HCM_PSU_CA|ORA_HRX_CA_PSU_WC_QC_DETAIL|ORA_HRX_CA_PSU_WC_QC_DETAIL|1|QCWC0001|QC WC Account1|Y|QCCU0001|Classification Unit1|1|Y|||
MERGE|OrgInformation|2001/01/01|CA PSU|Payroll Statutory Unit|CA|1|HCM_PSU_CA|ORA_HRX_CA_PSU_PM_QC_DETAIL|ORA_HRX_CA_PSU_PM_QC_DETAIL|||||||||0|999999999999.99|4