HDL to change assignment status of previous assignment after global transfer
Summary:
Once HDL is loaded for the new Global Transfer record, the previous assignment is automatically terminated with a Termination Date and Action as 'Global Transfer'. However, the Assignment Status for the previous Assignment becomes 'Inactive - Payroll Eligible'. We want to change it to 'Inactive - No Payroll'.
How to achieve that?
Content (please ensure you mask any confidential information):
Sample HDL used for this is as follows:
METADATA|WorkTerms|AssignmentNumber|PersonNumber|LegalEmployerName|DateStart|WorkerType|ActionCode|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|AssignmentStatusTypeCode|BusinessUnitShortCode
MERGE|WorkTerms|ET10|10|LE|2022/07/22|E|GLB_TRANSFER|2024/01/01|4712/12/31|Y|1|INACTIVE_NO_PROCESS|BU
METADATA|Assignment|AssignmentNumber|PersonNumber|LegalEmployerName|DateStart|WorkerType|ActionCode|WorkTermsNumber|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|AssignmentStatusTypeCode|BusinessUnitShortCode