To run a data export to view pay changes sent to SelectPay for an employee, follow these steps.
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.*, pc.* From PayrollAudit.[Paytype Change] pc Left Join PayrollAudit.[Employee Change Request] ecr On ecr.[Employee Change Request Number] = pc.[Employee Change Request Number] Left Join PayrollAudit.[Employee Payroll Request] pr On ecr.[Employee Payroll Request Number] = pr.[Employee Payroll Request Number] Where pr.[Payroll Number] = 'REPLACE WITH PAYROLL NUMBER' Order By pr.[Submitted Date]
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.