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.

Data Granularity

Provides one row per employee for the defined time period.

Supported Dataview/RDO Type

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

Columns
All Time Approved (Multiple Approvers) Indicates if all time for the user has been approved (Yes or No). TK_APPROVAL_SUMMARY_ALL_TIME_APPROVED Boolean No
Approving Managers TK_APPROVAL_SUMMARY_APPROVING_MANAGERS String No
Approving Managers Count TK_APPROVAL_SUMMARY_APPROVING_MANAGERS_COUNT Number No
Assigned Manager TK_APPROVAL_SUMMARY_ASSIGNED_MANAGER String No
Employee Approval Status TK_APPROVAL_STATUS_EMP Boolean No
Manager Approval Status TK_APPROVAL_STATUS_MAN Boolean No
On Premise TK_APPROVAL_SUMMARY_ON_PREMISES Boolean No
Pay Period Locked Indicator TK_APPROVAL_SUMMARY_PAY_PERIOD_LOCKED Boolean No
Payroll Lock Through Date TK_APPROVAL_SUMMARY_PAY_PERIOD_LOCKED_THROUGH Date No
Totals Up To Date Indicator TK_APPROVAL_SUMMARY_TOTALS_UPDATED Boolean No

Related Entities

Additional Info

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.

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many