Workforce Management - Worker Assignment Event Real Time
Description
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.
Business Questions
This subject area can answer the following business questions:
-
What is an employee's assignment history in the chronological order?
-
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 count of terminations by various termination reasons?
-
What is the total number of promotions between two dates for a worker?
Job Roles
The following job roles secure access to this subject area:
Duty Roles
The following duty roles secure access to this subject area:
Primary Navigation
My Client Groups > Quick Actions > Manage Employment OR My Client Groups > Apps > Person Management > Actions > Personal and Employment > Manage Employment
Time Reporting
The worker assignment events history data is available for reporting in this subject area.
Time dimension is linked to "Assignment Event Details"."Effective Start Date".
Transactional Grain
This subject area returns data at the grain of Assignment Events (PER_ALL_ASSIGNMENTS_M) ) with the following filter conditions applied: (ASSIGNMENT_TYPE = 'C' OR ASSIGNMENT_TYPE = 'E' OR ASSIGNMENT_TYPE = 'N' OR ASSIGNMENT_TYPE = 'P' ). Note that Fusion HCM data security may further restrict the data being returned in OTBI as OTBI uses the same data security as Fusion HCM.
Special Considerations
None.