PERSONAL_PAYMENTS UE giving duplicate rows with PER_EXT_SEC_PERSON_NOW_FUTURE_UE

Summary:

I am creating an HCM extract in which my root UE is PER_EXT_SEC_PERSON_NOW_FUTURE_UE and the child data group is PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE and its child data group is PERSONAL_PAYMENTS.

Content (please ensure you mask any confidential information):

We want to pick the the past, future current any changes on the personal payments. There is no filter on PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE for effective date since that may restrict the output. If an employee has two assignments it is giving two bank details/payment row details with the same details (duplicate), how can this be suppressed ?