How to delete specific row from Assignment Supervisor

Summary:

Hi there

In my organization we are using the Remove Person Information functionality to remove employee records that are beyond the retention period for our countries. In the removal we are including a Work Relationship Cancellation on each record but in order to complete this without errors, we must first ensure that if the person was a manager, they no longer have direct reports.

We attempted to remove the specific Assignment Supervisor row by using Delete in HDL but this removes all of the records which share the same Assignment Supervisor ID and therefore it removes current manager from active employees etc.