This guide details the steps to take to run an audit of all sickness changes submitted to SelectPay via the integration.
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 pr.[Payroll Number], pr.[Audit Number], pr.[Submitted Date], pr.[Response Date], pr.[Tax Year], pr.Period, ar.* From PayrollAudit.[Employee Absence Request] ar Inner Join PayrollAudit.[Employee Payroll Request] pr On ar.[Employee Payroll Request Number] = pr.[Employee Payroll Request Number] Where pr.[Payroll Number] = 'REPLACE WITH PAYROLL NUMBER' Order By ar.AbsenceStart
In the top left of the data export window, click Options, Paste SQL from clipboard.
Change the Payroll Number in the criteria to the Payroll Number of the employee being queried.
Click Data.