OBIA/ODI - Workforce Event "PRV" WIDs

Harrison Jacob

Hello all,

We would like to extend the W_WRKFC_EVT_MONTH_F table with a join to a new alias of W_INT_ORG_D for the previous Legal Entity value (i.e. when a worker has a job change event which results in them being in a new legal entity, we would like to know both the previous and new values).

In order to follow best practices, we are trying to understand how similar fields are created, such as HR_ORG_PRV_WID, and replicate that logic for the legal entity. Unfortunately, we are struggling with understanding how those WID values are populated in ODI. We have tracked back to the persisted stage table W_PSFT_WEVT_JOB_PS where HR_ORG_PRV_ID is populated, however we can not seem to find the logic for how it gets there in the first place.

Any help is greatly appreciated!