The following steps will help you identify any changes to an employee's pay history records.
Log in to the SelectHR Admin Tool.
In the Maintenance section, click Import/Export Data.
Click Create an export definition, then click Select the data to export.
Use the Database drop-down and select SelectHR.
Log in with the SQL credentials.
On the SQL tab, copy and paste the following SQL:
Select Person.Snapshot.[Person Number], Person.Snapshot.[First Name], Person.Snapshot.Surname, Employee.[Pay History].[Pay Number], Employee.[Pay History].[Pay From Date], Employee.[Pay History].[Pay Amount], Employee.[Pay History].[FT Pay Amount], Employee.[Pay History].[Pay Frequency], Employee.[Pay History].[Pay Element Type] From Person.Snapshot Inner Join Employee.[Pay History] On Person.Snapshot.[Appointment Number] = Employee.[Pay History].[Appointment Number]In the bottom half of the window, type the Surname of the employee who had the Pay History record changed into the Criteria column of the Person.Snapshot.Surname field.
Click the Data, and make a note of the Pay Number of the changed Pay History record.
To exit the Export, click Cancel.
Click Select the data to export.
Use the Database drop-down and select SelectPersist.
Log in with the SQL credentials.
On the SQL tab, copy and paste the following SQL:
Select AUDIT.[Object Schema], AUDIT.[Object Name], AUDIT.[Key Number], AUDIT.[Audit Date], AUDIT.Action, [Audit Fields].[Field Name], [Audit Fields].[Is Text], [Audit Fields].[Was Text], [Audit Fields].[Is Date], [Audit Fields].[Was Date], [Audit Fields].[Is Number], [Audit Fields].[Was Number], [Audit Fields].[Is Decimal], [Audit Fields].[Was Decimal], [Audit Fields].[Is Boolean], [Audit Fields].[Was Boolean], Security.Users.[User Name] From AUDIT Inner Join [Audit Fields] On AUDIT.[Audit Number] = [Audit Fields].[Audit Number] Left Join Security.Users On AUDIT.[User Number] = Security.Users.[User Number] Where AUDIT.[Object Schema] = 'employee' And AUDIT.[Object Name] = 'pay history' And AUDIT.[Key Number] In (12345)Click the Query tab, and enter the Pay Number noted in Step 7 into the criteria section of the field named AUDIT.[Key Number]. You can replace the (12345) value with the key number you made a note of.
Click the Data tab. The Data tab will now display a list of all changes made to the specific Pay History record. The data is usually sorted by Audit Date (the date in which the change was made), with the oldest change appearing at the top of the list.
It is possible to see all changes made, who made them and when using this data, which can be exported if necessary.