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

Example of Loading Provincial Medical and Worker Compensation for British Columbia

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

A separate OrgInformation record is supplied for each flexfield context:

Provincial Medical:

  • British Columbia Provincial Medical Account Details (ORA_HRX_CA_PSU_PM_BC_DETAIL)

Workers Compensation:

  • British Columbia Account Details (ORA_HRX_CA_PSU_WC_BC_DETAIL)
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|oraHrxCaBcUnique(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_WC_BC_DETAIL)|oraHrxCaBcAcctNumber(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_WC_BC_DETAIL)|OraHrxCaBcAcctName(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_WC_BC_DETAIL)|OraHrxCaMbDefault(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_WC_BC_DETAIL)|oraHrxCaBcClUnit(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_WC_BC_DETAIL)|oraHrxCaBcClUnitDesc(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_WC_BC_DETAIL)|oraHrxCaBcRate(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_WC_BC_DETAIL)|oraHrxCaBcDefaultRate(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_WC_BC_DETAIL)|oraHrxCaBcPmUnique(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_PM_BC_DETAIL)|oraHrxCaBcPmAcctNumber(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_PM_BC_DETAIL)|oraHrxCaBcPmAcctName(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_PM_BC_DETAIL)|oraHrxCaBcPmDefaultAcct(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_PM_BC_DETAIL)|oraHrxCaBcPmStartAnnPay(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_PM_BC_DETAIL)|oraHrxCaBcPmEndAnnPay(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_PM_BC_DETAIL)|oraHrxCaBcPmRate(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_PM_BC_DETAIL)
MERGE|OrgInformation|2001/01/01|CA PSU|Payroll Statutory Unit|CA|1|HCM_PSU_CA|ORA_HRX_CA_PSU_WC_BC_DETAIL|ORA_HRX_CA_PSU_WC_BC_DETAIL|1|BCWC0001|BC WC Account1|Y|BCCU0001|Classification Unit1|1|Y|||||||
MERGE|OrgInformation|2001/01/01|CA PSU|Payroll Statutory Unit|CA|1|HCM_PSU_CA|ORA_HRX_CA_PSU_PM_BC_DETAIL|ORA_HRX_CA_PSU_PM_BC_DETAIL|||||||||1|BCPM00001|BC PM Account 1|Y|0|999999999999.99|4