The Clock Time Exception by Manager report is a variation of the Clock Time Exception template. This variation uses the Time Exception topic to show a summary of clock entry exceptions that have occurred for employees under each manager. Managers and administrators can use this report to validate the clock entry exceptions for each manager’s employees.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Manager | Yes | Ascending | |
| Name Number | Yes | A to Z | |
| Location | Ascending | ||
| Scheduled Date | Oldest to Newest | ||
| Department | |||
| Scheduled Time |
|
||
| Time Entry | |||
| Time Exception |
Custom Fields
Scheduled Date
The Scheduled Date custom field shows the scheduled date. It uses the following expression:
PunchExceptionsCustom.ScheduledTime
Scheduled Time
The Scheduled Time custom field shows the scheduled time. It uses the following expression:
CASE
WHEN PunchExceptionsCustom.ScheduledTime IS NULL THEN ''
ELSE replace(substring(convert(varchar,PunchExceptionsCustom.ScheduledTime, 100), 13, 5), ' ', '') + ' ' + right(convert(varchar,PunchExceptionsCustom.ScheduledTime, 100), 2)
END
Time Entry
The Time Entry custom field shows the clock entry time. It uses the following expression:
CASE
WHEN PunchExceptionsCustom.PunchTime IS NULL THEN ''
ELSE replace(substring(convert(varchar,PunchExceptionsCustom.PunchTime, 100), 13, 5), ' ', '') + ' ' + right(convert(varchar,PunchExceptionsCustom.PunchTime, 100), 2)
END
Filters