This guide explains how you can create a data export audit to see who has made changes to a person details record.
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, Paste SQL from clipboard.
Change the First Name and Surname Criteria to match the First & 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, Paste SQL from clipboard.
Replace the CHANGEME criteria with the Person Number.
Click Data.
It is possible to see all changes made, who made them, and when using this data, which can be exported if necessary.