Clock Time Exception

The Clock Time Exception report uses the Time Exception topic to show a summary of clock entry exceptions that occurred in a specified period.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Employee Number	Yes	A to Z
Employee Name		Ascending
Scheduled Date		Oldest to Newest
Department
Time Exception
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

The template includes the following filters: