Converting contract Worker to Employee

Converting contract Worker to Employee

Step1: Cancel the current work relationship
Step 2: Create new Work relationship for employment type as Employee

Below is the HDL to do the above steps in one file

METADATA|Worker|PersonNumber|EffectiveStartDate|EffectiveEndDate|ActionCode|StartDate|DateOfBirth|CountryOfBirth
MERGE|Worker|3801|2017/04/01|4712/12/31||2017/04/01|1985/03/05|US

METADATA|WorkRelationship|PersonNumber|LegalEmployerName|OnMilitaryServiceFlag|PrimaryFlag|DateStart|WorkerType|ActionCode|TerminateWorkRelationshipFlag|ActualTerminationDate
MERGE|WorkRelationship|3801|US1 Legal Entity|N|Y|2017/04/01|C|INVOLUNTARY_TERMINATION|Y|2020/04/21
MERGE|WorkRelationship|3801|US1 Legal Entity|N|Y|2020/04/22|E|||

METADATA|WorkTerms|ActionCode|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|AssignmentStatusTypeCode|AssignmentType|BusinessUnitShortCode|PositionOverrideFlag|PrimaryWorkTermsFlag|LegalEmployerName|PersonNumber|DateStart|WorkerType|AssignmentNumber
MERGE|WorkTerms|REHIRE|2020/04/22|4712/12/31|1|Y|ACTIVE_PROCESS|ET|New Zealand Business Unit|Y|Y|US1 Legal Entity|3801|2020/04/22|E|ET3801

METADATA|Assignment|ActionCode|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|AssignmentStatusTypeCode|AssignmentType|BusinessUnitShortCode|PositionOverrideFlag|PrimaryAssignmentFlag|PrimaryFlag|PersonNumber|ManagerFlag|AssignmentCategory|ReasonCode|DateStart|WorkerType|LegalEmployerName|AssignmentNumber|WorkTermsNumber
MERGE|Assignment|REHIRE|2020/04/22|4712/12/31|1|Y|ACTIVE_PROCESS|E|New Zealand Business Unit|Y|Y|Y|3801|N|FR||2020/04/22|E|US1 Legal Entity|E3801|ET3801