Using Absence (Dates)

The Absence (Dates) screen returns data from the attendance table and it does this for each individual date.

You can use this with the I want to query employees, All Information and Over a date range.

You should not mix this screen with other screens as it may cause duplicate results to appear and it may be hard to determine what is causing the issue.

Option	Detail
Category	Displays the category, e.g. Sick, Appointment etc. As set in Admin.
Type	Displays the corresponding Type/Reason as set against the attendance category.
Date	Displays the date of the absence. This also shows non working days that fall within the absence spell.
Duration	Displays the duration in text. As this is a text field it cannot be used for any calculations in Excel.
Duration Days	Displays the data as a number and can be used in Excel for any calculations.
AM? PM?	Displays if the date is set to be AM and/or PM as set in the working day.
Sick Pay Rate	Displays a number of the absence sick pay rate. Can be used for calculations in Excel.
Duration Hours	Displays the number of hours for the day of absence taken from the employees working calendar. This can be used in Excel for any calculations.
Episode Start	Displays the same date as the Date field as it's the beginning of the absence spell.
Cost of Absence	This displays the cost of absence at the time of the absence taken from the job and salary record at the time. For more details, see Using Absence (Calculated) reports.
Episode End	If the absence spell is over multiple days, this displays the last date.
Episode Duration	This displays the duration of the absence spell in text, e.g. 2.00 Day(s) Cannot be used for calculations in Excel.
Episode Days	Displays the duration of the absence spell as a number. Can be used in Excel for calculations.
Episode Hours	Displays the total number of hours for the absence spell as set in Episode Days.
Sick Category	Displays either Yes or No and is based on the absence category property Sick.
Duration Entitled to Average Holiday Pay	Displays if the absence is entitled to average holiday pay.
Bereavement Pay rate	Displays the rate as a number that can be used in calculations in Excel.