To create a data export to identify changes made to address records, follow the steps below.
Log in to the Admin Tool.
In the Maintenance section, click Import/Export Data.
Click Create an export definition, then 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, Person.Address.[Address Number], Person.Address.[Address Line 1], Person.Address.[Address Line 2], Person.Address.[Address Line 3], Person.Address.[Address Line 4], Person.Address.[Address Line 5], Person.Address.[Post Code] From Person.Snapshot Inner Join Person.Address On Person.Snapshot.[Person Number] = Person.Address.[Person Number] Where Person.Snapshot.Surname = 'ENTER SURNAME HERE'
In the bottom half of the window, type the Surname of the employee who had the Address record changed into the Criteria column of the Person.Snapshot.Surname field.
Click the Data tab, and make a note of the Address Number of the changed Address 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], 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] = 'address' AND AUDIT.[Key Number] = 'ENTER ADDRESS NUMBER HERE'
Click the Query tab, and enter the Address Number noted in Step 7 into the criteria section of the field named AUDIT.[Key Number].
Click the Data tab. The Data tab will now display a list of all changes made to the specific Address 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.