Correcting Supervisors

Summary

Correcting Supervisors

Content

Hello All,

I am trying to correct the Supervisors using HDL. For some employees there are 2 BU Heads, i need to remove both and create a new one.

I was successful doing it for 1 employee that is removing one old one and creating new one.

But how to remove the other one, i know we can delete it but if we delete it then we will not be having historical data rite?

I used below HDL sample.

METADATA|AssignmentSupervisor|EffectiveStartDate|EffectiveEndDate|PrimaryFlag|AssignmentNumber|ManagerPersonNumber|ManagerAssignmentNumber|ManagerType|NewManagerType|NewManagerPersonNumber|NewManagerAssignmentNumber|ActionCode|ReasonCode
MERGE|AssignmentSupervisor|2018/08/24|4712/12/31|Y|E500656|660019|E660019|Business Unit Head|Business Unit Head|825197|E825197|ASI_CONVERSION|