Assignment Primary Flag HDL - Not updating
Summary: The HDL below is not updating the PRIMARY FLAG on the record currently set to "N". There are 2 similar per_all_assignment_m records, and the HLD import points to the record already set to "Y". No errors on the HDL import.
METADATA|WorkRelationship|PeriodOfServiceId|PersonId|DateStart|PrimaryFlag|LegalEmployerName|DateForPrimaryFlagChange
MERGE|WorkRelationship|300000957257238|300000867753129|2025/07/21|Y|Baptist Health Care, Inc.|2025/07/21
There are no unique identifiers in the current HDL data that will allow it to point to specific record.
How do I redirect the HDL to the correct per_all_assignments_m record?
Thanks in advance
Code Snippet (add any code snippets that support your topic, if applicable):