PER_EXT_PAY_EMPLOYEES-UE is fetching duplicate records
We are getting duplicate records. We are using below UE as root data group and added below sql query in the HCM Extract advanced filter condition, still getting duplicate rows. It is changes only extract. HCM Extract will fetch data both Active and Inactive records based on Changes.
We used many child UE's like PER_EXT_EMAIL_ADDRESSES_UE, PER_EXT_PHONES_UE ..etc
Data Group: PER_EXT_PAY_EMPLOYEES_UE
Scenario: Employee is having two active work relationships like Contingent Worker and Non Worker.
Expected: 2 records (1 Contingent Worker and 1 Non Worker)
If we see in the backend tables and we are seeing same date_start (Per_periods_of_service) , assignment_sequence (PER_ALL_ASSIGNMENTS_M) and Effective_sequence (PER_ALL_ASSIGNMENTS_M) values.