1. HCM Data Loading Business Objects
  2. Example of Loading Pensions Automatic Enrolments for the UK

Example of Loading Pensions Automatic Enrolments for the UK

This example create a Pensions Automatic Enrolment card for employee assignment E451388, starting on the 1st May 2019.

Source keys are used to identify each record in calculation card hierarchy.

Use the CalculationCard.dat file to upload the Pensions Automatic Enrolment card with HCM Data Loader.

METADATA|CalculationCard|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|DirCardDefinitionName|EffectiveStartDate|AssignmentNumber
MERGE|CalculationCard|VISION|PAE_451388|UK LDG|Pensions Automatic Enrolment|2019/05/01|E451388

METADATA|CardComponent|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|DirCardId(SourceSystemId)|EffectiveStartDate|DirCardCompDefName
MERGE|CardComponent|VISION|PAE_451388_CC|UK LDG|PAE_451388|2019/05/01|Pensions Automatic Enrolment

METADATA|ComponentDetail|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|DirCardCompId(SourceSystemId)|EffectiveStartDate|DirCardCompDefName|DirInformationCategory|FLEX:Deduction Developer DF|_EMPLOYEE_CLASSIFICATION(Deduction Developer DF=HRX_GB_PAE)|_ELIGIBLE_JOBHOLDER_DATE(Deduction Developer DF=HRX_GB_PAE)|_RE_ENROLMENT_ASSESSMENT_ONLY(Deduction Developer DF=HRX_GB_PAE)|_REASON_FOR_EXCLUSION(Deduction Developer DF=HRX_GB_PAE)|_OVERRIDING_WORKER_POSTPONEMENT(Deduction Developer DF=HRX_GB_PAE)|_OVERRIDING_ELIGIBLEJH_POSTPMNT(Deduction Developer DF=HRX_GB_PAE)|_OVERRIDING_QUALIFYING_SCHEME_Display(Deduction Developer DF=HRX_GB_PAE)|_ACTIVE_POSTPONEMENT_TYPE(Deduction Developer DF=HRX_GB_PAE)|_ACTIVE_POSTPONEMENT_RULE(Deduction Developer DF=HRX_GB_PAE)|_ACTIVE_POSTPONEMENT_END_DATE(Deduction Developer DF=HRX_GB_PAE)|_ACTIVE_QUALIFYING_SCHEME_Display(Deduction Developer DF=HRX_GB_PAE)|_QUALIFYING_SCHEME_JOIN_METHOD(Deduction Developer DF=HRX_GB_PAE)|_QUALIFYING_SCHEME_JOIN_DATE(Deduction Developer DF=HRX_GB_PAE)|_QUALIFYING_SCHEME_LEAVE_REASON(Deduction Developer DF=HRX_GB_PAE)|_QUALIFYING_SCHEME_LEAVE_DATE( Deduction Developer DF=HRX_GB_PAE)|_OPT_OUT_PERIOD_END_DATE(Deduction Developer DF=HRX_GB_PAE)|_OPT_OUT_REFUND_DUE(Deduction Developer DF=HRX_GB_PAE)|_JOINING_SCHEME_PROCESSED_DATE(Deduction Developer DF=HRX_GB_PAE)|_LEAVING_SCHEME_PROCESSED_DATE(Deduction Developer DF=HRX_GB_PAE)|_CLASSIFICATION_CHANGED_PROC_DT(Deduction Developer DF=HRX_GB_PAE)|_ACTIVE_POSTPONEMENT_PROC_DATE(Deduction Developer DF=HRX_GB_PAE)|_PAYROLL_FOR_PAY_REF_PERIOD(Deduction Developer DF=HRX_GB_PAE)|_OVERRIDING_STAGING_DATE(Deduction Developer DF=HRX_GB_PAE)|_RE_ENROLMENT_DATE(Deduction Developer DF=HRX_GB_PAE)|_QUALIFYING_SCHEME_START_DATE(Deduction Developer DF=HRX_GB_PAE)|_LETTER_TYPE_GENERATED(Deduction Developer DF=HRX_GB_PAE)|_LETTER_STATUS(Deduction Developer DF=HRX_GB_PAE)|_LETTER_TYPE_DATE(Deduction Developer DF=HRX_GB_PAE)|_SUBSEQUENT_COMMS_REQ(Deduction Developer DF=HRX_GB_PAE)|_LETTER_HISTORY (Deduction Developer DF=HRX_GB_PAE)
MERGE|ComponentDetail|VISION|PAE_451388_FLEX|UK LDG|PAE_451388_CC|2019/05/01|Pensions Automatic Enrolment|HRX_GB_PAE|HRX_GB_PAE|ELIGIBLEJH|2019/05/01|Y||||My_Premium_Element||||My_Premium_Element|AUTOENROL|2019/05/01|||2019/06/30|Y|2019/05/01||2019/05/01|||||2019/05/01|ORA_HRX_GB_LETTER_E|ORA_HRX_GB_LET_NOTYETGEN|||

METADATA|ComponentAssociation|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|DirCardCompId(SourceSystemId)|EffectiveStartDate|TaxReportingUnitName
MERGE|ComponentAssociation|VISION|PAE_451388_AS|UK LDG|PAE_451388_CC|2019/05/01|UK Tax Reporting Unit

METADATA|ComponentAssociationDetail|SourceSystemOwner|SourceSystemId|DirRepCardId(SourceSystemId)|DirCardCompId(SourceSystemId)|EffectiveStartDate|AssociationAssignmentNumber
MERGE|ComponentAssociationDetail|VISION|PAE_451388_ASD|PAE_451388_AS|PAE_451388_CC|2019/05/01|E451388