Attendance Summary

The Attendance Summary entity provides the columns necessary to retrieve data related to the latest Attendance action associated with each employee and the Attendance balances for each employee. The Attendance Summary data columns are primarily used for creating Dataviews and reports that provide the various Attendance balances associated with each employee. The balance data columns are parameterized to allow the specific balance to be provided and to support the creation of a Dataview that can present multiple balance types as columns.

Data Granularity

Provides one row per employee.

Supported Dataview/RDO Type

Employee Business Structure Employee - Time Series Business Structure - Time Series Work Unit Work Unit - Time Series

Columns
Action Completion Date GP_ACTION_COMPLETION_DATE Date No
Action Initiated Date GP_ACTION_INITIATED_DATE Date No
Action Name GP_ACTION_NAME String No
Action Status GP_ACTION_STATUS String No
Action Triggered Date GP_ACTION_TRIGGERED_DATE Date No
Calculated Balance GP_CALCULATED_BALANCE Number No
Discipline Level End Date GP_DL_END_DATE Date No
Discipline Level Name GP_DL_NAME String No
Discipline Level Start Date GP_DL_START_DATE Date No
Perfect Attendance Awards Count GP_PA_AWARDS_COUNT Number No
Perfect Attendance Violations Count GP_PA_VIOLATIONS_COUNT Number No
Point Balance GP_POINT_BALANCE Number No
Processed Through Date GP_PROCESSED_THROUGH_DATE Date No
Time Balance GP_TIME_BALANCE Number No

Related Entities

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many