Scheduled Totals

The Scheduled Totals entity provides the total scheduled hours, wages, or days related to the selected time period. When creating a Dataview, you can define how the totals data is summarized by selecting the desired parameter value from the following:

  • Employee, Date
  • Employee, Time Period
  • Employee, Pay Code, Date
  • Employee, Pay Code, Time Period
  • Employee, Job, Date
  • Employee, Job, Time Period
  • Employee, Job, Pay Code, Date
  • Employee, Job, Pay Code, Time Period
  • Employee, Labor Category, Date
  • Employee, Labor Category, Time Period
  • Employee, Labor Category, Pay Code, Date
  • Employee, Labor Category, Pay Code, Time Period
  • Employee, Job, Labor Category, Date
  • Employee, Job, Labor Category, Time Period
  • Employee, Job, Labor Category, Pay Code, Date
  • Employee, Job, Labor Category, Pay Code, Time Period

For example, if you select the ‘Employee, Pay Code, Time Period’ parameter value, when the Dataview is executed, it will display totals data related to scheduled transactions for each employee and pay code with the data summarized for the selected time period.

Supported Dataview types

Employee Dataview Business Structure Dataview
X

Data granularity

The granularity is based on the selected summarization parameter value.

Columns

Label

Key

Scheduled Total Apply Date

TK_SCHEDULED_APPLY_DATE

Scheduled Total Days

TK_SCHEDULED_TOTAL_DAYS

Scheduled Total Hours

TK_SCHEDULED_TOTAL_HOURS

Scheduled Total Job Transfer Indicator

TK_SCHEDULED_JOB_TRANSFER

Scheduled Total Labor Transfer Indicator

TK_SCHEDULED_LABOR_TRANSFER

Scheduled Total Wages

TK_SCHEDULED_TOTAL_WAGES

Additional information

When you use the Scheduled Totals entity, it is important that you include data columns that relate to the selected summarization parameter value. For example, if you are adding the Schedule Total Hours data column to a Dataview and have chosen to summarize by 'Employee, Job, Labor Category, Pay Code, Date', it is critical that you include the following data columns to help the user understand the data that is returned:

Column name Entity
Employee Full Name Employee Details
Labor Category Name (Path) Labor Category
Paycode Name Paycode
Job Name - Full Path (Worked) Worked Job

Core entity

Employee Organization Day Organizational Job Paycode Labor Category
X X

Relationship

One-to-One

One-to-Many

x