HDL to change assignment status of previous assignment after global transfer
Once the HDL is loaded for a new Global Transfer record, the previous assignment should automatically terminate with a Termination Date, and its Assignment Status should change to 'Inactive - Payroll Eligible'. However, with the data file provided below, both the new and old assignments are showing as active, each with a different worker number.
Here is a sample HDL used for this process:
METADATA|WorkRelationship|SourceSystemId|SourceSystemOwner|LegalEmployerName|PersonNumber|DateStart|WorkerType|ActionCode|ActualTerminationDate|PrimaryFlag|GlobalTransferFlag|TerminateWorkRelationshipFlag
MERGE|WorkRelationship|WR_300377-1|WORKDAY|LE-001|377|2024/06/03|E|GLB_TRANSFER||||
METADATA|WorkTerms|AssignmentNumber|AssignmentName|SourceSystemId|SourceSystemOwner|PeriodOfServiceId(SourceSystemId)|PersonNumber|EffectiveStartDate|EffectiveLatestChange|EffectiveSequence|EffectiveEndDate|ActionCode|PrimaryWorkTermsFlag