The Clock Time Exception by Department report is a variation of the Clock Time Exception report. This variation uses the Time Exception topic to show a summary of clock entry exceptions that have occurred in each department. Managers and administrators can use this report to validate clock entry exceptions in each department and see the effect that the exceptions might have on scheduling.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Department | Yes | Ascending | |
| Name Number | Yes | A to Z | |
| Location | Ascending | ||
| Scheduled Date | Oldest to Newest | ||
| Manager | |||
| 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
The template includes the following filters: