Employee Absence Hours (Organization Hierarchy) Trend Analytics Workbook

The Employee Absence Hours (Organization Hierarchy) Trend Analytics workbook investigates the absence hours recorded for employees in your enterprise over time. You can run the report for employees in a specific organization, location, job category, job, or grade. You can also run the report for the time period of your choice.

In order for an absence to appear in this report, you first need to link the Absence type to an Absence element.

The workbook plots the absence hours for the date earned that you have entered in the Payroll element. If no date earned exists, the workbook uses the element's effective start date as the date earned.

Note: If you entered your absences using the Absence Details window, a date earned is not set up; therefore the report uses the effective start date of the element.

Regardless of the length of time an employee has been absent, the report always plots his or her absence hours on the date earned, or the effective start date of an element.

It is possible, because of the frequency and time period you select, that an absence may fall into two different time periods. The workbook always shows absence hours in the first time period, rather than distributed across two time periods.

Business Question

How does the absence record of people in my enterprise compare between organizations or jobs?

Parameters

You must enter a value for the following parameters:

Use the following parameters to further restrict the values in the workbook:

Worksheets

This workbook has the following worksheets:

The worksheets display one row for each time period. For example, the Year worksheet displays one row per year.

Headings and Calculations

All worksheets contain the following columns:

Related Topics