1. HCM Data Loading Business Objects
  2. Example of Adding an Assignment with a Shared Employment Contract

Example of Adding an Assignment with a Shared Employment Contract

You supply the Contract component of the Worker object when adding additional worker assignments under the existing work relationship. This topic shows how to share an existing employment contract when adding assignments using HCM Data Loader.

Adding an Assignment with a Shared Employment Contract

You can use HCM Data Loader to share an employment contract across worker assignments. Keep these rules in mind:

  • You must load the relevant Employment Terms, Assignment, and Contract components in the same Worker.dat file.

  • The values of the EffectiveStartDate and EffectiveEndDate attributes must be the same on all three components.

  • The EffectiveStartDate value is the start date of the shared employment contract. This value must be the projected end date of the last contract period, plus one day, meaning no gaps are permitted between contract periods.

  • The EffectiveEndDate value must be the end of time if this contract record is the latest record. It must not be the contract end date.

The following example shows how to load the Employment Terms, Assignment, and Contract components for a shared employment contract. You can use this HCM Data Loader file format for associating an existing contract with the newly created worker assignment:

METADATA|Worker|PersonNumber|DateOfBirth|StartDate|EffectiveStartDate|EffectiveEndDate|ActionCode|SourceSystemId|SourceSystemOwner
MERGE|Worker|202001001_DB08|1953/11/01|2020/01/01|2020/01/01|4712/12/31|ADD_ASSIGN|PERSON_202001001_DB08|VISION
METADATA|WorkRelationship|PersonNumber|DateStart|LegalEmployerName|WorkerType|PrimaryFlag|SourceSystemOwner
MERGE|WorkRelationship|202001001_DB08|2020/01/01|VISION_GHR_2TSCSA|E|Y|WR_202001001_DB08|VISION
METADATA|WorkTerms|EffectiveStartDate|EffectiveSequence|EffectiveLatestChange|ActionCode|AssignmentStatusTypeCode|AssignmentType|WorkerType|LegalEmployerName|BusinessUnitShortCode|AssignmentNumber|PeriodOfServiceId(SourceSystemId)|PersonNumber|SourceSystemOwner|SourceSystemId|PrimaryWorkTermsFlag
MERGE|WorkTerms|2021/01/01|1|Y|ADD_ASSIGN|ACTIVE_PROCESS|ET|E|VISION_GHR_2TSCSA|Vision City Operations|WT_202001002_DB08|WR_202001001_DB08|202001001_DB08|VISION|WT_202001002_DB08|N
METADATA|Assignment|EffectiveStartDate|EffectiveSequence|EffectiveLatestChange|ActionCode|AssignmentStatusTypeCode|AssignmentType|WorkerType|LegalEmployerName|PrimaryAssignmentFlag|PrimaryFlag|BusinessUnitShortCode|WorkTermsAssignmentId(SourceSystemId)|SourceSystemOwner|SourceSystemId|ContractNumber
MERGE|Assignment|2021/01/01|1|Y|ADD_ASSIGN|ACTIVE_PROCESS|E|E|VISION_GHR_2TSCSA|N|N|Vision City Operations|WT_202001002_DB08|VISION|ASG_202001002_DB08|ContractNUM
Note:
  • The contract number that's provided in the HCM Data Loader file must be valid for the work relationship for which the new assignment is being created.
  • If you want to add a contract to an existing assignment that doesn't have a contract, ensure that you pass the assignment record and the corresponding contract record in the same DAT file.