Workforce Management - Worker Assignment Real Time

Description

This is the primary subject area to report workers current assignment information. A worker can have multiple active or inactive assignments. This subject area provides details of all the worker assignments, including their start and end dates, assignment type, status type, status, and working hours. Important metrics such as the total assignment count, headcount, and FTEs can be reported by Business Units, Department, Location, and Manager. This subject area includes past and future dated assignment information. By default only a workers current assignment information as of todays date is retrieved. You can use a SQL prefix SET VARIABLE PARAM_EFFECTIVE_DATE ='@{P_DATE}{2018-12-31}'; (give the correct date format) to reset the default as-of date to report on assignment information in the past or future. This subject area does not report a history of assignment changes. You can use Workforce Management Work Assignment Event Real Time subject area to report a history of assignment changes.

Business Questions

This subject area can answer the following business questions:

• What is the FTE, headcount, assignment count by Location, Country etc?

• What is the headcount of hourly or salaried employees?

• What is the current headcount by job, department, grade, location, business unit, legal employer or bargaining unit?

• What is the current employee headcount by employee category or assignment status?

• What is the headcount by payroll?

• What is the current assignment information for a worker?

Job Roles

The following job roles secure access to this subject area:

• Human Resource Analyst

• Line Manager

Duty Roles

The following duty roles secure access to this subject area:

• Workforce Transaction Analysis Duty

Primary Navigation

My Client Groups > Quick Actions > Manage Employment OR My Client Groups > Apps > Person Management > Actions > Personal and Employment > Manage Employment

Time Reporting

This subject area does not capture history data. The latest assignment details of the worker is available for reporting.

Time dimension is linked to "Worker Assignment Details"."Effective Start Date".

Transactional Grain

This subject area returns data at the grain of Worker Assignments level (PER_ALL_ASSIGNMENTS_M) with the following filter conditions applied: (SYSDATE BETWEEN AssignmentPEO.EFFECTIVE_START_DATE AND AssignmentPEO.EFFECTIVE_END_DATE) AND ((AssignmentPEO.ASSIGNMENT_TYPE = 'E') OR (AssignmentPEO.ASSIGNMENT_TYPE = 'C') OR (AssignmentPEO.ASSIGNMENT_TYPE = 'N') OR (AssignmentPEO.ASSIGNMENT_TYPE = 'P'))AND (AssignmentPEO.EFFECTIVE_LATEST_CHANGE = 'Y' ). 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. Users can only see the assignments which are as of date.

Special Considerations

None.