Use the Admin Tool audit export to identify changes made to a person details record, including who made the change and when it occurred.
This can be used to review updates such as first name, surname, email address, date of birth, and bank details.
To run a data audit against a person record, 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 Person.Snapshot.[First Name],Person.Snapshot.Surname, Person.Snapshot.[Person Number]From Person.Snapshot
In the top left of the data export window, click Options, then click Paste SQL from clipboard.
Change the First Name and Surname criteria to match the First Name and Surname of the impacted employee.
Click Data.
Make a note of the Person Number.
Click Cancel.
Click Select the data to export.
Change the database to SELECTPERSIST.
Log in.
Copy the below 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], Security.Users.[User Name]From AUDIT Inner Join [Audit Fields] On AUDIT.[Audit Number] = [Audit Fields].[Audit Number] Inner Join Security.Users On AUDIT.[User Number] = Security.Users.[User Number]Where AUDIT.[Object Schema] = 'Person' And AUDIT.[Object Name] = 'Details' And AUDIT.[Key Number] = 'CHANGEME'
In the top left of the data export window, click Options, then click Paste SQL from clipboard.
Replace the CHANGEME criteria with the Person Number.
Click Data.