The total days and total occurrences values displayed on the absence history person list are pulled from a view, Person.AppointmentSicknessLast12Months.
This means that the figures displayed include only live sickness data for the employee within the previous 12-month window from today's date.
If you believe the total sickness days value displayed is incorrect, we recommend reviewing the employee's sickness history to verify.
The SQL query below can be used to check the employees' applicable sickness data for the last 12 months:
In the Admin Tool, click Import/Export Data.
Click Create an export definition.
Click Select the data to export.
Change the database to SelectHR.
Log in.
Copy the below SQL:
SELECT PSS.[Person Number],PSS.[First Name],PSS.Surname,PSS.[Effective Status],AH.[Absence Start Date],AH.[Absence End Date],AH.[Absence Type],AH.[Total Days],AH.[Total Hours]FROM Person.Snapshot PSSINNER JOIN Absence.History AH ON PSS.[Person Number] = AH.[Person Number]WHERE PSS.[First Name] = 'CHANGEME'AND PSS.Surname = 'CHANGEME'AND PSS.[Effective Status] = 'Current'AND AH.[Absence Start Date] >= DateAdd(mm, - 12, GetDate())AND AH.[Absence Type] = 'Sickness'AND AH.Workflow = 1
🤓 Tip: Change the First Name and Surname criteria to match the first name and surname of the impacted employee.
If you have reviewed the resulting data and still believe the total sickness days value to be incorrect, please raise a new case specifying at least one example employee record this can be observed on.