Error: A person number with this value already exists. Enter a unique value.
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