PER_POSITION_EXTRA_INFO_ALL_UE Pulling the EIT records for all rows in HCM Extract

Summary:

I am creating an HCM Extract with the historical Root UE for positions, identified as PER_EXT_SEC_HISTORY_POSITION_UE. For EIT information, I am using PER_POSITION_EXTRA_INFO_ALL_UE. I updated a position EIT as of June 15, 2024, but this update is appearing in all position-dated rows in the output.

What filter should I add to the extra info UE so that the position's effective start date falls between the EIT's effective start date and end date? I tried the query pos.effective_start_date between target.effective_start_date and target.effective_end_date, but it isn't valid.