HCM Extracts - Getting Duplicates in Future Assignments

Summary

Getting Duplicates in Future Assignments

Content

I need to fetch the Changes Only Person and Assignment data of all stated transactions(Past, current and future assignments). I'm using 'PER_EXT_SEC_HISTORY_ASSIGNMENTS_UE' to achieve the requirement. But getting duplicates in Future hire  and future assignments.

I'm using below filter criteria as per my requirement.

 1.Assignment Type  - 'E'

2.Legislation code = 'US' , 'CA'

3.Hourly_salaried_code = 'H'

 

But when I ran the UE Route query in BIP, I'm not getting duplicates. 

Please advise me to resolve the duplicates.

 

Thanks,

Keerthana.

Version

20 D

Code Snippet

 ( asg.assignment_type='E'
 AND asg.effective_latest_change = 'Y'
 AND asg.legislation_code IN ('CA', 'US')
 AND asg.hourly_salaried_code = 'H'
)