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:
- PER_ASG_SEQ_HISTORY_DETAILS_UE - this is tied to assignment_id so we're unable to pull the entire history of a person.
- PER_PERSON_HISTORY_ASSIGNMENTS_UE - this is tied to person_id. However, it does not contain assignment DFF DBIs.
- PER_EXT_ASSIGNMENT_BASIC_HISTORY_UE - this pulls everything, even if not for the same person. I think it uses effective_date as context.
Tagged:
0