Data Dictionary entities
- A
- B
- C
- E
  - Employee Certification Assignment
    The Employee Certification Assignment entity provides data columns that allow the creation of Dataviews and Report Data Objects that provide information on all certifications that are assigned to employees. This entity is purely for reporting on the certifications assigned to each employee. It is not intended to be used with transactional data.
  - Employee
    The Employee entity provides a single data column that is reserved for use when users drill down to the employee level in a Business Structure Dataview. Use the Employee Full Name data column provided by the Employee Detailsentity to list attributes and descriptive information that is associated with an employee.
  - Employee Details
    The Employee Details entity provides data columns that are attributes or descriptive information that are associated with an employee.
  - Employee Preferences Request
    The Employee Preferences Request entity provides information on Employee's requested scheduling preferences.
  - Employee Preferences Request Status History
    TBD
  - Employee Schedule Pattern Rollout Outcome
    The Employee Schedule Pattern Rollout Outcome entity provides data columns that allow the creation of Dataviews that provide information on schedule-related background processing outcomes.
  - Employee Schedule Rule Override Assignment
  - Employee Scheduling Indicators
  - Employee Skill Assignment
  - Employee Tip Method
    The Employee Tip Method entity provides Gaming data related to the employees tip method.
  - Exception Counter
  - 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.
- Employee HCM
- F
- G
- H
- Healthcare Analytics Data Entities
- J
- K
- L
- M
- N
- O
- P
- R
- S
- T
- V
- W

Exception Counter

The Exception Counter entity data column provides the actual number of exceptions that an employee has triggered over a given time period. The data provided is a count of unresolved exceptions. The column is parameterized, allowing the user to pick the exception type that is associated to the exception count. A user can add multiple columns and select different parameters for each column to show the exception count for multiple exceptions in a single Dataview or report.

Supported Dataview types

Employee Dataview	Business Structure Dataview
X

Data granularity

Provides one row per employee for the defined time period.

Columns

Label	Description	Key
Exception Counter	A count of exceptions in the dataview during the selected time period.	TK_EXCEPTIONCOUNT

Related entities

Core entity

Employee	Organization	Day	Organizational Job	Paycode	Labor Category
X

Relationship

One-to-One	One-to-Many
x