Using Absence (Calculated) reports
The Absence (Calculated) screen in query builder reports on data for any attendance category marked with the Sick property.
The report returns one line of data for each employee and you must use the option Over the last x weeks. X is the number of weeks back the report looks at.
This report only goes back 52 weeks and we recommend the fields from this screen are not mixed with other screens because it returns data with one line per employee.
| Option | Details |
| Absence Spells | Displays how many spells of absence an employee has had in the time frame the query is based on. An absence spell is defined by the start and end dates of an absence. |
| Bradford Factor | Displays the Bradford factor score for the employee. The calculation for this is Spells Spells Duration. |
| Duration Hours | Displays a comparison between employees who takes absence in days versus those who take it in hours and minutes. The period of time that is used to calculate the duration is either a number of rolling weeks or a specific time period that the user can choose by using the new parameter. |
| Duration Days | Displays similar information to Duration Hours but works this out in days rather than hours. |
| Available Working Days | Displays how many days the employee was available for work in the period specified. This includes all types of day that are classified as working days (for example, holiday, training, study are included, non-working days and bank holidays are not). |
| Available Working Minutes | This does the same as the Available Working Days but displays the data in minutes. |
| Lost Time Rate | Displays the percentage of time that the person has been off sick in the period specified. So, if the period was five working days, and the employee took two days sick, their lost time rate would be 40, because they were sick 40% of the period. The calculation that builds this number is 100 * (Duration Days / Available working days) |
| Cost of Absence |
This calculates how much the employee’s sick absence has cost the company. It reduces each employee’s pay to an hourly rate which we need to do because the employee could by paid hourly, weekly, or yearly. This value is then multiplied up by the duration of the absence. This means, everybody is compared on equal terms.
Specifically:
|