The Clock Time Exception by Location 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 location. Managers and administrators can use this report to validate the clock entry exceptions in each location, and to see the effect that the exceptions might have on scheduling.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Location | Yes | Ascending | |
| Name Number | Yes | A to Z | |
| Scheduled Date | Oldest to Newest | ||
| Department | |||
| Manager | |||
| Scheduled Time | |||
| Time Entry | |||
| Time Exception |
Custom Fields
Scheduled Date
The Scheduled Date custom field shows the employee scheduled date. It uses the following expression:
PunchExceptionsCustom.ScheduledTime
Scheduled Time
The Scheduled Time custom field shows the employee 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 employee 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: