Calculations in Sickness and Sickness Cost Reports

The sickness cost by department, status, division, location, and key unit are all essentially the same report grouped in different ways.
​
They all use the same view to bring back the data, Absence.[Days with Organisation and Cost]. This view is made up of nine tables/views to bring back all the data required for each different grouping.
​
The sickness by reports uses one stored procedure, Absence.[Sickness between Dates], and one view, Employee.[Current and Leavers Positions With Organisation], to bring back the data and group the data in different ways depending on which report is being run.
​
The option to calculate working days, if set to true, will show which working days are sick days for each employee in the report.
​
Many of the calculations used in these reports are complicated as they have to account for any changes in hours, when the absence took place, why the employee was absent, the role they had, and holiday taken.
​
In addition, it is important to know that the cost is calculated using all pay elements on the employee’s record. In situations where more than one pay element is used at the same time, these sickness reports will incorporate all those pay elements, which may result in a higher-than-expected figure.
​
If you need the reports to behave differently, such as accounting for only specific pay elements, this would require creating a new custom Crystal Report.
​
This can be achieved either through consultancy or training in the creation of Crystal Reports, but please note this may incur a cost. If you are interested in creating a custom report or receiving training on Crystal Reports, please contact your account manager, who can facilitate this for you. If you are unsure who your account manager is, please raise a new case online and reference the title of this article.