The Clock Time Exception by Exception report is a variation of the Clock Time Exception template. This variation uses the Time Exception topic to show a list of clock entry exceptions that have occurred, sorted by the type of exception. Managers and administrators can use this report to validate clock entry exceptions and view how many exceptions of each type have occurred.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Time Exception | Yes | A to Z | |
| Name Number | Yes | A to Z | |
| Location | Ascending | ||
| Scheduled Date | Oldest to Newest | ||
| Department | |||
| Manager | |||
| Scheduled Time | |||
| Time Entry |
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
This template includes the following filters: