Approval Summary
The Approval Summary entity provides the data columns that are necessary to understand the status of an employee’s timecard approval, indicating for a period of time whether the timecard has been approved by the manager or employee.
An employee’s timecard approval status can be in one of three states: full, partial, or none.
- If the timecard was approved for each day of a given period, the timecard approval status will be full.
- If the timecard was approved but not for each day of a given period, the timecard approval status will be partial.
- If the timecard was not approved for a given period, the timecard approval status will be none.

Employee Dataview | Business Structure Dataview |
---|---|
X |

Provides one row per employee for the defined time period.

Label | Description | Key |
---|---|---|
All Time Approved | (Multiple Approvers) Indicates if all time for the user has been approved (Yes or No). | TK_APPROVAL_SUMMARY_ALL_TIME_APPROVED |
Approving Managers |
The approving managers for the task or job. |
TK_APPROVAL_SUMMARY_APPROVING_MANAGERS |
Approving Managers Count |
The number of approving managers for the task or job. |
TK_APPROVAL_SUMMARY_APPROVING_MANAGERS_COUNT |
Assigned Manager |
TK_APPROVAL_SUMMARY_ASSIGNED_MANAGER |
|
Employee Approval Status |
TK_APPROVAL_STATUS_EMP |
|
Manager Approval Status |
TK_APPROVAL_STATUS_MAN |
|
On Premise | TK_APPROVAL_SUMMARY_ON_PREMISES | |
Pay Period Locked Indicator |
TK_APPROVAL_SUMMARY_PAY_PERIOD_LOCKED |
|
Payroll Lock Through Date |
TK_APPROVAL_SUMMARY_PAY_PERIOD_LOCKED_THROUGH |
|
Totals Up To Date Indicator |
TK_APPROVAL_SUMMARY_TOTALS_UPDATED |

- Actual Paycode Totals Corrections Only
- Actual Paycode Totals Exclude Corrections
- Actual Paycode Totals Include Corrections
- Average Worked Hours
- Employee Details
- Pay Period
- Projected Paycode Totals Corrections Only
- Projected Paycode Totals Exclude Corrections
- Projected Paycode Totals Include Corrections
- Scheduled Paycode Totals
- Sign Off
- Totalization Status

Employee | Organization | Day | Organizational Job | Paycode | Labor Category |
---|---|---|---|---|---|
X |

One-to-One | One-to-Many |
---|---|
X |