You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Error: A person number with this value already exists. Enter a unique value.

in Human Capital Management 3 comments

Summary:

We have an Permanent Employee Terminated(397508), we are trying to modify the Employee to a Contingent Worker via HDL as below

METADATA|Worker|PersonId|EffectiveStartDate|EffectiveEndDate|PersonNumber|StartDate|DateOfBirth|ActionCode|SourceSystemOwner|SourceSystemId
MERGE|Worker|397508|2022/09/29||397508|2022/09/29|1982/06/05|HIRE|HRC_SQLLOADER|397508
METADATA|PersonName|PersonId(SourceSystemId)|EffectiveStartDate|EffectiveEndDate|PersonNumber|NameType|Title|FirstName|MiddleNames|LastName|LegislationCode|SourceSystemOwner|SourceSystemId
MERGE|PersonName|397508|2025/07/01||397508|GLOBAL|Mr.|David||Test|GB|HRC_SQLLOADER|397508
METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|ActionCode|DateStart|WorkerType|RehireRecommendationFlag
MERGE|WorkRelationship|HRC_SQLLOADER|397508|397508|ABC Corp|HIRE|2022/09/29|C|Y
METADATA|WorkTerms|AssignmentId|PersonId|ActionCode|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|PeriodOfServiceId|SourceSystemOwner|SourceSystemId
MERGE|WorkTerms|300001613608625|397508|HIRE|2025/07/01||1|Y||HRC_SQLLOADER|397508

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!