Skip to main content

Audit: Identify changes made to an employee's Bank Details using an audit export

Data export audit to see who has changed an employee's bank details and when.

H
Written by Harry Ledger
Updated over 3 months ago

Follow the steps below to run an audit on changes made to an employee's bank details.

  1. Log in to the SelectHR Administrator Tool.

  2. Click Import/Export Data.

  3. Click Create an export definition.

  4. Click Select the data to export.

  5. Change the database to SELECTHR.

  6. Log in.

  7. Copy the below SQL:

    SELECT Person.Snapshot.[First Name],       Person.Snapshot.[Known As],       Person.Snapshot.Surname,       Person.Snapshot.[Payroll Number],       Person.Snapshot.[Person Number]FROM Person.SnapshotWHERE Person.Snapshot.[First Name] = 'CHANGEME'      OR Person.Snapshot.Surname = 'CHANGEME'      OR Person.Snapshot.[Payroll Number] = 'CHANGEME'

  8. In the top left of the data export window, click Options, Paste SQL from clipboard.

  9. In the bottom half of the Query window, change any of the CHANGEME values to reflect the First Name, Surname, or Payroll Number of the employee whose details were changed.

  10. Click Data.

  11. Make a note of the Person Number.

  12. Click Cancel.

  13. Click Select the data to export.

  14. Change the database to SELECTPERSIST.

  15. Copy the below SQL:

  16. 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'      AND [Audit Fields].[Field Name] LIKE '%bank%'

  17. In the top left of the data export window, click Options, Paste SQL from clipboard.

  18. Click on the Query tab, replace the CHANGEME value with the Person Number noted in step 11 into the criteria section of the field named AUDIT.[Key Number].

  19. Click the Data tab. The Data tab will now display a list of all changes made to any field with the word Bank in it on the employee's 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.

Related Articles
Audit: Identify changes made to an Absence History record using an Audit Export in the Admin Tool
Audit: Identify changes made to a career history record
Audit: Identify changes made to a Person Details record using the Audit Export function of the Admin Tool
Audit: Identify changes made to an address history record using the audit export function
Identify changes made to an appointment history record using an audit export
Did this answer your question?