How to end date an assignment supervisor using HDL

Summary:

How to end date an assignment supervisor

Content (please ensure you mask any confidential information):

For context, we have 2 types of supervisor - a line manager and a team lead. An employee can only have 1 line manager and have one or more team leads.

How can we end date a team lead for an employee using HDL?

We've already tried the following HDL scenarios:

Scenario #1: Insert new WT and ASG rows, and end date the assignment supervisor row 1 day before the new assignment effective start date.

Result: HDL error.

Scenario #2: Insert new WT and ASG rows and use ESD for the assignment supervisor row. Supply #NULL to the New Manager attributes.