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.
Supported Dataview types
| Employee Dataview | Business Structure Dataview |
|---|---|
| X |
Data granularity
Provides one row per employee.
Columns
| Label | Key |
|---|---|
|
Action Completion Date |
GP_ACTION_COMPLETION_DATE |
|
Action Initiated Date |
GP_ACTION_INITIATED_DATE |
|
Action Name |
GP_ACTION_NAME |
|
Action Status |
GP_ACTION_STATUS |
|
Action Triggered Date |
GP_ACTION_TRIGGERED_DATE |
|
Calculated Balance |
GP_CALCULATED_BALANCE |
|
Discipline Level End Date |
GP_DL_END_DATE |
|
Discipline Level Name |
GP_DL_NAME |
|
Discipline Level Start Date |
GP_DL_START_DATE |
|
Perfect Attendance Awards Count |
GP_PA_AWARDS_COUNT |
|
Perfect Attendance Violations Count |
GP_PA_VIOLATIONS_COUNT |
|
Point Balance |
GP_POINT_BALANCE |
|
Processed Through Date |
GP_PROCESSED_THROUGH_DATE |
| Time Balance |
GP_TIME_BALANCE |
Related entities
- Actual Paycode Totals Corrections Only
- Actual Paycode Totals Exclude Corrections
- Actual Paycode Totals Include Corrections
- Employee Details
- Projected Paycode Totals Corrections Only
- Projected Paycode Totals Exclude Corrections
- Projected Paycode Totals Include Corrections
- Scheduled Paycode Totals
- Sign Off
- Totalization Status
Core entity
| Employee | Organization | Day | Organizational Job | Paycode | Labor Category |
|---|---|---|---|---|---|
| X |
Relationship
| One-to-One | One-to-Many |
|---|---|
| X |