HCM Extract - Current/Future Assignment Record

Summary:

HCM extract that pulls current assignment for employees and future assignment for pending workers.

Content (please ensure you mask any confidential information):

I'm creating an HCM extract to get current assignment for employees and future assignments for pending workers. I'm using PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE as the child. I've recreated this several times using either PER_EXT_ASSIGNMENT_BASIC_HISTORY_UE or PER_EXT_SEC_PERSON_UE as the root data group. The root returns one assignment (current one) but I'm struggling to get the PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE to return one row