HDL Template to convert Non Worker work relationship to Contingent Worker

Summary:

Hi All,

Can someone please provide the SQL query and HDL template for the below requirement.

1. We need to update the "System person type" from "Non worker" to "Contingent worker" for almost 70 records.

  For the above we need to bulk remove the work relationships as "Non workers" & then bulk upload new work relationship as a "Contingent worker".

  So that all the information/data/historical changes/updates so far can be maintained.

2. Along with the above change we can simultaneously update the "User person type" and "Worker categories" of:

   • 70 records – for whom we are updating "System person type" from "Non worker" to "Contingent worker".