Assignment Primary Flag HDL - Not updating — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!