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

Fast Formula: Assignment DFF History

Summary:

Hi experts, we are working on a fast formula where we need to get the historical Assignment DFFs of a person (independent of assignment). We found three user entities which we find challenging to use:

  1. PER_ASG_SEQ_HISTORY_DETAILS_UE - this is tied to assignment_id so we're unable to pull the entire history of a person.
  2. PER_PERSON_HISTORY_ASSIGNMENTS_UE - this is tied to person_id. However, it does not contain assignment DFF DBIs.
  3. PER_EXT_ASSIGNMENT_BASIC_HISTORY_UE - this pulls everything, even if not for the same person. I think it uses effective_date as context.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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