how to load broken records through HDL

Summary:

That is the sequence of steps how we processed.

Also, we had scenarios where an employee was rehired multiple times. Not sure if you have any, but we then repeat step 2 and 3 and in step 3 in the Worker file increment the Assignment Number and Work Terms Number by 1.

Example:

Step 1. Load Original Hire row, Assignment Number E123456

Step 2. Terminated E123456

Step 3. Rehire E123456-2

If Rehired again, Term E123456-2 and on Rehire file E123456-3.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):