1. HCM Data Loading Business Objects
  2. Example of Adding a Contract

Example of Adding a Contract

You can supply the Contract component of the Worker object for existing workers.

This topic shows how to load a contract for an existing worker using HCM Data Loader.

Loading a Contract

You can use HCM Data Loader to give an existing worker a contract extension. 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 extension period. 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.
  • You can't delete a contract record using HCM Data Loader.
  • You can create or edit a contract only with an assignment.

The following example shows how to load the Employment Terms, Assignment, and Contract components for a contract.

METADATA|WorkTerms|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|ActionCode|AssignmentStatusTypeCode|AssignmentType|WorkerType|LegalEmployerName|BusinessUnitShortCode|AssignmentNumber|PeriodOfServiceId(SourceSystemId)|PersonId(SourceSystemId)|PersonNumber|SourceSystemOwner|SourceSystemId|ProjectedEndDate
MERGE|WorkTerms|2001/11/01|4712/12/31|1|Y|HIRE|ACTIVE_PROCESS|ET|E|GHR_Vision_LE_11|Vision City Operations|ET202001001_CON11|WR_202001001_CON11|PERSON_202001001_CON11|202001001_CON11|HRC_SQLLOADER|WT_202001001_CON11|

METADATA|Assignment|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|ActionCode|AssignmentStatusTypeCode|AssignmentType|WorkerType|LegalEmployerName|PrimaryAssignmentFlag|PrimaryFlag|BusinessUnitShortCode|PersonId(SourceSystemId)|WorkTermsAssignmentId(SourceSystemId)|SourceSystemOwner|SourceSystemId|ProjectedEndDate
MERGE|Assignment|2001/11/01|4712/12/31|1|Y|HIRE|ACTIVE_PROCESS|E|E|GHR_Vision_LE_11|Y|Y|Vision City Operations|PERSON_202001001_CON11|WT_202001001_CON11|HRC_SQLLOADER|ASG_202001001_CON11|

METADATA|Contract|EffectiveStartDate|EffectiveEndDate|Duration|DurationUnits|ExtensionPeriod|ExtensionPeriodUnits|AssignmentNumber|ContractType|PersonNumber|SourceSystemOwner|SourceSystemId
MERGE|Contract|2001/11/01|4712/12/31|10|M|||ET202001001_CON11||202001001_CON11|HRC_SQLLOADER|CONT_ET202001001_CON11