Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Worker Assignment Event history - job title / position title as of assignment effective date
Summary:
When we are running OTBI analyses with the Worker Assignment Event subject area, we need to be able to see what the associated position name/ job code names are as of the employee's assignment effective dated row.
Content (please ensure you mask any confidential information):
Currently on these historical effective dated rows, the position / job attributes are returning the top of stack values. This leads to confusion and distrust in our data.
Consider the simple example: ID 12345 has been assigned the same job code SRDA from 1/1/2021 - 7/1/2024. On 1/1/2021 the job code name is Data Analyst. Effective 5/1/2022 the SRDA job code name is updated to 'Data Manager'. The employees OTBI assignment history looks as follows:
Tagged:
0