In SelectHR, once a timesheet is rejected by the authorising manager, it should reappear in the employee’s timesheet listing for them to amend or delete.
If a rejected timesheet is not visible to the employee, follow the steps below to identify the cause.
Overview
When a manager rejects a timesheet:
It should return to the employee's timesheet list for editing or deletion.
If the employee cannot see it, several factors may be causing the issue.
The following sections outline the checks you can perform to troubleshoot.
Confirm the timesheet still exists
To verify that the timesheet hasn’t been deleted, follow these steps.
Log in to the SelectHR Administrator Tool.
Go to Import/Export Data.
Click Create an export definition.
Select Select the data to export.
Change the database to SelectHR and log in.
Paste the following SQL:
SELECT
p.[PERSON NUMBER],
p.[FIRST NAME],
p.SURNAME,
t.[TIMESHEET NUMBER],
t.[WEEK BEGINNING],
t.SUBMITTED,
t.AUTHORISED,
t.WORKFLOW
FROM PERSON.DETAILS p
INNER JOIN TIME.TIMESHEETS t
ON p.[PERSON NUMBER] = t.[PERSON NUMBER]
WHERE p.[FIRST NAME] = 'CHANGEME'
AND p.SURNAME = 'CHANGEME'
ORDER BY t.[WEEK BEGINNING] DESC;Click Options → Paste SQL from clipboard.
Update the first name and surname to match the affected employee.
Click Data to view results.
If the timesheet appears, it still exists in the system.
If it doesn’t, it may have been deleted by the employee and will need to be recreated.
Audit the timesheet (optional)
To check who may have deleted or modified the timesheet, follow these steps.
Follow steps 1–5 above, but select the SelectPersist database instead.
Paste the following SQL:
SELECT
a.[OBJECT SCHEMA],
a.[OBJECT NAME],
a.[KEY NUMBER],
a.[AUDIT DATE],
a.ACTION,
af.[FIELD NAME],
af.[IS TEXT],
af.[WAS TEXT],
af.[IS DATE],
af.[WAS DATE],
af.[IS NUMBER],
af.[WAS NUMBER],
af.[IS DECIMAL],
af.[WAS DECIMAL],
af.[IS BOOLEAN],
af.[WAS BOOLEAN],
u.[USER NAME]
FROM AUDIT a
INNER JOIN [AUDIT FIELDS] af
ON a.[AUDIT NUMBER] = af.[AUDIT NUMBER]
LEFT JOIN SECURITY.USERS u
ON a.[USER NUMBER] = u.[USER NUMBER]
WHERE a.[OBJECT SCHEMA] = 'TIME'
AND a.[OBJECT NAME] = 'TIMESHEETS'
AND a.[KEY NUMBER] = 'REPLACEWITHTIMESHEETNUMBER'
AND af.[FIELD NAME] = 'TIMESHEET NUMBER'
ORDER BY a.[AUDIT DATE];Replace
'REPLACEWITHTIMESHEETNUMBER'with the actual timesheet number.Click Data to view the audit trail.
Check the employee’s reporting line
If the timesheet exists but hasn’t been returned to the employee, it may be due to how reporting lines are configured.
To confirm the setup:
In the Admin Tool, click Configuration Options.
Double-click HR.
Locate the Reporting Line Option setting and identify which of the following is used:
Post to Post Only
Each employee must have a post in their career history.
Each post must have a managing post.
The managing post must have an occupant (the manager).
Person to Person Only
The Reporting Override tab in the employee’s career history must specify a manager.
This person will receive all requests, including rejected timesheets.
Mixture of Both
System first checks for a person-to-person override.
If none is found, it falls back to the post-to-post setup.
Make sure the employee has a valid manager assigned based on the configured method.