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