This article serves to provide the basic checks you can perform as a HR user to check the approval dates and times of timesheets.
The first thing you should check is that the timesheet has been submitted on the SelectHR database. You can do this by running a data export.
Find the timesheet number
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, Time.Timesheets.[Timesheet Number], Time.Timesheets.[Week Beginning], Time.Timesheets.Submitted, Time.Timesheets.Authorised, Time.Timesheets.Workflow From Time.Timesheets Inner Join Person.Snapshot On Time.Timesheets.[Person Number] = Person.Snapshot.[Person Number] Where Person.Snapshot.[First Name] = 'TYPE FIRST NAME HERE' And Person.Snapshot.Surname = 'TYPE SURNAME HERE'
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 Relevant Timesheet Number you would like to Audit.
To exit the export click cancel.
Audit the timesheet
The next step is to audit the timesheets using the timesheet number and check the submission and approval date/time. Please follow the steps below to achieve this.
In the Admin Tool, click Import/Export Data.
Click Create an export definition.
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], [Audit Fields].[Is Date], [Audit Fields].[Was Date], [Audit Fields].[Is Number], [Audit Fields].[Was Number], [Audit Fields].[Is Decimal], [Audit Fields].[Was Decimal], [Audit Fields].[Is Boolean], [Audit Fields].[Was Boolean], 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] = 'time' And AUDIT.[Object Name] = 'timesheets'
In the top left of the data export window, click Options, Paste SQL from clipboard.
Change the AUDIT.[KEY NUMBER] criteria to match the Timesheet number you previously noted
Click Data. This will now display a list of changes made to this specific timesheet number entered.
To view the approver of the timesheet, look for the record stating Authorised with a checkbox ticked against it and the associated username.