Exceptions

The Exceptions entity provides, at a transactional level, the necessary data columns to report on the exceptions triggered by employees, based on the exception rules that have been configured in the system (for example, Late In-Punch).

The Exceptions entity returns one row per employee per exception. Therefore, if an employee has triggered three exceptions on a given day, three rows are returned.

Supported Dataview types

Employee Dataview

Business Structure Dataview

X

Data granularity

Provides one row per employee per exception for the defined time period.

Columns

Label

Description

Key

Actual Punch Date Time

 The date of the actual punch time in the timecard associated with the flagged exception.

TK_EXCEPTIONS_ACTUALDATETIME

Exception Apply Date

 The three letter day of the week and the date when the exception occurred.

TK_EXCEPTIONS_APPLYDATE

Exception Category

TK_EXCEPTIONS_TYPE_CATEGORY

Exception Comments

 The comment attached to the pay code edit or punch that resulted in the exception.

TK_EXCEPTIONS_COMMENTSNOTES_NAME

Exception Hours

 In the event of an absence, the length of the missed scheduled shift.

TK_EXCEPTIONS_VIOLATION_IN_HOURS

Exception Type

 The Type of the exception.

TK_EXCEPTIONS_TYPE_DISPLAYNAME

Exception Type (System Name)

 Refers to the specific identifier or label used within the system for exception types.

TK_EXCEPTIONS_TYPE

Exception Type Description

 Description field associated with an Exception type.

TK_EXCEPTIONS_TYPE_DESCRIPTION

Hours Over Exception

 The number of minutes past the defined threshold for triggering an exception.

TK_EXCEPTIONS_OVERLIMIT_IN_HOURS

In Punch Exception Indicator

 Indicates if the punch with an exception was a Punch In. This is a Boolean property.

TK_EXCEPTIONS_ISSTARTEXCEPTION

Missing Time Status

The status of exception in terms of Missing Time Justification (Employee Justified, Manager Justified, Auto-resolved).

TK_EXCEPTIONS_JUSTIFICATION_STATUS

Out Punch Exceptions Indicator

 Indicates if the punch with an exception was a Punch Out. This is a Boolean property.

TK_EXCEPTIONS_ISENDEXCEPTION

Reviewed Exception Indicator

 Indicates the review status of the exception. This is a Boolean Property.

TK_EXCEPTIONS_ISREVIEWED

Scheduled Punch Date Time

TK_EXCEPTIONS_SCHEDULEDDATETIME

Work Rule Name

TK_EXCEPTIONS_WORKRULE_NAME

Additional information

  • Because the data is processed at the transactional level, it is important for users to include the Exception Type and Exception Apply Date columns when creating a Dataview or report so that they can understand the data that is being returned.
  • The Actual Punch Date Time column provides the actual date and time at which the employee punched in or punched out in relation to an exception. Users can add this column to view the actual punch time (In or Out) related to exceptions that are associated with an actual punch.
    • Example: A Late Out exception is associated with the actual out time for the employee.
  • The Scheduled Punch Date Time column provides the date and time at which the employee was scheduled to punch in or punch out in relation to an exception. Users can add this column when creating a Dataview or report to view the scheduled punch time (In or Out) related to exceptions that are associated with a scheduled punch.
    • Example: A Missed Out Punch exception is associated with the scheduled out time for the employee.
    • Example: A Late In, Late Out, Early In, or Early Out exception has an associated scheduled punch time.

Core entity

Employee

Organization

Day

Organizational Job

Paycode

Labor Category

X

X

Relationship

One-to-One

One-to-Many

X