The filter applied to the approved list within the manager timesheet process does not return results for timesheets that have been successfully submitted to SelectPay.
If you require managers to be able to view historical timesheets that have already been submitted to SelectPay, you would require a custom solution.
If you are interested in a custom solution, please reach out to your account manager or raise a new case online and reference the title of this article.
To create an export to see all timesheets for an employee, follow these steps.
Log in to the SelectHR Administrator 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.* From Person.Snapshot Inner Join Time.Timesheets On Person.Snapshot.[Person Number] = Time.Timesheets.[Person Number] Where Person.Snapshot.[First Name] = 'REPLACEWITHFIRSTNAME' And Person.Snapshot.Surname = 'REPLACEWITHSURNAME' Order By Time.Timesheets.[Week Beginning]