OTBI Report - need to fetch the Worker Historic information

Question

we have a requirement to fetch Worker Historic information like

* Current Job Title
* Previous Job Title
* Previous Department
* New Department
* Previous Manager
* New Manager
* Previous Location
* New Location

which subject area stores this information in the OTBI?

RVohra · Answer

@Kiran Kumar Alle ,

In addition to above suggestions, it is worth looking at following subject area - Workforce Management - Worker Assignment Event Real Time.

It is used to report on the worker assignment changes (past, present, and future) including hires, transfers, assignment changes, promotions, manager changes, and termination. Assignment events are identified by HR Actions and HR Action Reason dimensions which group assignment events by Action Type, Action, and Action Reason. For example, you can use Action Type Promotion to retrieve all promotions and use Terminate Work Relationship to retrieve all worker terminations.

This subject area includes important assignment metrics to monitor assignment events. For example you can monitor Number of hires, Headcount of promotions, Number of transfers, Termination Full Time Employees (FTE), and Rehire counts.

You can use the Time dimension or Assignment Event Effective Start/End Date to report assignment history. Time dimension allows you to roll up assignment events by week, month, quarter, or year. With Effective Start and End date, you can see a workers complete assignment history with associated job, department, grade, location, business unit and legal employer information.

This subject area includes future dated assignment changes, such as hires and terminations. By default only a workers assignment history as of todays date is retrieved. You can use a SQL prefix SET VARIABLE PARAM_EFFECTIVE_DATE= future date to reset the default as-of date and include future-dated assignments. The assignment detail information in Worker dimension reflects the workers current assignment information.

This subject area can answer the following business questions:

* What are the Hire, rehire, transfer, termination counts by Business Unit, Department, Location, Manager etc?
* What are the various reasons for worker terminations under both voluntary and involuntary categories?
* What is an employee's assignment history in the chronological order?
* What is the count of terminations by various termination reasons?
* What is the count of transfers into a Business Unit or Department?
* What is the headcount of terminations by categories such as voluntary and involuntary?
* What is the total number of promotions between two dates for a worker?

Hope it helps!

Thanks

Rajesh

Bhaskar Konar · Answer

Hi @Kiran Kumar Alle,

Welcome to the Oracle Analytics & AI Community!

For this requirement, you'll need to use the Logical SQL approach, as the required historical values (current and previous attributes) are not always available directly through a single OTBI subject area.

In addition to Mandeep's reply, you may also find the following discussion helpful along with some examples etc.:

Previous and current values flip in the OTBI Report — Cloud Customer Connect

Hope this help.

Thank you.

MandeepGupta · Answer

Hi Kiran,

Welcome to Oracle Analytics and AI community.

Start with below post:

Worker - Current and Previous Jobs — Cloud Customer Connect

Thanks.