Skip to main content

Audit: Identify changes made to a Holiday Addition record

Run an audit to see who created, edited or deleted a holiday addition.

H
Written by Harry Ledger

There may be times when you need to find out who has created, edited, or deleted a holiday addition on an employee’s record, along with when those changes were made.

To run an audit against a holiday additions record, follow these steps.

  1. In the Admin Tool, click Import/Export Data.

  2. Click Create an export definition.

  3. Click Select the data to export.

  4. Change the database to SELECTHR.

  5. Log in.

  6. Copy the below SQL:

    Select Absence.HolidayAdditionsHistoryData.*, Person.Snapshot.[Person Number], Person.Snapshot.[Effective Status], Person.Snapshot.[First Name], Person.Snapshot.Surname From Person.Snapshot Inner Join Absence.HolidayAdditionsHistoryData On Person.Snapshot.[Person Number] = Absence.HolidayAdditionsHistoryData.PersonNumber Where Person.Snapshot.[First Name] = 'CHANGE ME' And Person.Snapshot.Surname = 'CHANGE ME'

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

  8. In the bottom half of the query window, change any of the CHANGEME values to reflect the First Name and Surname of the employee.

  9. Click Data.

  10. Make a note of the Addition Number.

  11. Click Cancel.

  12. Click Select the data to export.

  13. Change the database to SELECTPERSIST.

  14. 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], [Audit Fields].[Is Date], [Audit Fields].[Was Date], [Audit Fields].[Is Number], [Audit Fields].[Was Number], [Audit Fields].[Was Decimal], [Audit Fields].[Is Decimal], [Audit Fields].[Was Boolean], [Audit Fields].[Is Boolean] 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] = 'absence' And AUDIT.[Object Name] = 'HolidayAdditionsHistoryData' And AUDIT.[Key Number] = 'CHANGE ME'

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

  16. Click on the query tab, replace the CHANGEME value with the Addition Number noted in step 10 in the criteria section of the field named AUDIT.[Key Number].

It is possible to see all changes made to a holiday addition, including who created it and when.

Related Articles
Audit: Identify who approved a timesheet
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 employee's Bank Details using an audit export
Identify changes made to an appointment history record using an audit export
Did this answer your question?