The Employee Hours Worked (Organization Hierarchy) Trend Analytics workbook investigates the number of overtime and regular hours worked. The workbook displays the number of hours worked for each overtime band you use in your enterprise, such as double time or time-and-a-half.
How many regular hours are my people working, and how is this changing over time? How many overtime hours are my people working, and how is this changing over time? Am I paying too much in unplanned or poorly scheduled overtime?
You must enter a value for the following parameters:
Start Date
End Date
Organization Hierarchy
Top Organization
Rollup Organizations - Yes/No
Payroll Name - you can select multiple payrolls
Use the following parameters to further restrict the values in the workbook:
Location (Geography)
Job Name
Grade Name
Position Name
This workbook has the following worksheet:
By Payroll Period
The worksheet displays one row for each payroll period.
The worksheet contains the following columns:
Period Start Date: The start date of the payroll period.
Period End Date: The end date of the payroll period.
Headcount: Regular hours worked during the payroll period calculated as a headcount.
Fulltime Equivalent: Regular hours worked during the payroll period calculated as Full Time Equivalent.
Overtime Band columns: The number of overtime hours worked for the overtime band within each payroll period, with one column for each band you have included in Oracle FastFormula.