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