PER_POSITION_EXTRA_INFO_ALL_UE Pulling the EIT records for all rows in HCM Extract — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

PER_POSITION_EXTRA_INFO_ALL_UE Pulling the EIT records for all rows in HCM Extract

edited Jun 25, 2024 2:41PM 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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!