Using PER_EXT_ASSIGNMENT_BASIC_HISTORY_UE getting multiple rows of assignment history

Summary:

I am looking to create an extract that contains all assignment history as we look to load into a data warehouse. I am using the

PER_EXT_ASSIGNMENT_BASIC_HISTORY_UE

UE and when I set up the record, it is giving me multiple rows of the same assignment. I thought this would be as simple as pointing to the UE and identifying the records.

Content (please ensure you mask any confidential information):

When I look at the UE, I see it is a join as follows:

FROM PER_ALL_ASSIGNMENTS_M asg, pay_payroll_assignments ppa where asg.assignment_id = ppa.hr_assignment_id(+)