Fix duplicate records using PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE

Summary:

Including both the latest and reinstatement (‘DS_AFFECTATION’) records using an OR condition works in BIP but produces duplicates in the HCM extract using PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE.

Content (please ensure you mask any confidential information):

Hi Team

In the HCM extract, we are trying to include both the current active assignment and the reinstatement (‘DS_AFFECTATION’) record by using an OR condition in the data group filter. While the same SQL logic in BIP returns only the expected two records, the extract produces four records (two duplicates). Each condition separately retrieves only one record in the HCM extract, confirming that the duplication occurs only when both are combined. We also removed all Fast Formula rules to isolate the cause, but the duplicates still appear, indicating that the issue lies in the extract or UE behavior. I read in