When I am using PER_EXT_SEC_ASSIGNMENT_RANGE_UE to get assignment historical data it is fetching duplicate records.
If a per has 4 assignment changes when running the PER_EXT_SEC_ASSIGNMENT_RANGE_UE query in the backend I am getting 4 assignment type 'E' records and 4 assignment type 'ET' records which is the required output. But the same user entity is giving 16 records when used in extract.
Please suggest some solutions
Thank you