Scheduled Paycode Totals

The Scheduled Paycode Totals entity provides the total scheduled hours, wages, or days that related to the selected time period for a selected pay code. When creating a Dataview, you can select the pay code for which totals data will be provided. For example, to create a Dataview that shows the hours for each employee related to the “REGULAR” pay code that apply to the selected time period, configure the Paycode Total Scheduled Hours data column with an assignment value of “REGULAR”.

Supported Dataview types

Employee Dataview

Business Structure Dataview

X

Data granularity

Provides one row per employee. The data that is returned is summarized for the selected time period.

Columns

Label

Description

Key

Paycode Total Scheduled Days

TK_GENIE_SCHEDULED_TOTAL_DAYS

Paycode Total Scheduled Hours

The number scheduled hours based on pay codes.

TK_GENIE_SCHEDULED_TOTAL_HOURS

Paycode Total Scheduled Wages

TK_GENIE_SCHEDULED_TOTAL_WAGES

Scheduled Hours

The predefined work hours assigned to an employee and managed through scheduling tools. This allows organizations to categorize pay codes for tracking productive and non-productive time, ensuring accurate total scheduled hours calculations.

TK_GENIE_SCHEDULED_TOTAL_HOURS_TIMECARD

Additional information

  • When using the data columns in the Scheduled Paycode Totals Include Corrections, select the desired pay code from all available pay codes, including both Standard and Combined pay codes.
  • When creating a Dataview, you can add the same data column from this entity multiple times, assigning a different pay code to each data column added. For example, to create a Dataview that shows the actual hours related to the “REGULAR” pay code and the “OVERTIME” pay code, you can add the Paycode Total Scheduled Hours (Include Corrections)' data column twice, assigning the “REGULAR” pay code to one column and the “OVERTIME” pay code to the other.
  • You can use the data columns in the Scheduled Paycode Totals entity in conjunction with the data columns in the Actual Paycode Totals Corrections Onlyand the Projected Paycode Totals Correctionsentities to view a comparison of Actual to Projected to Scheduled. To do this, you must disable the Column Relationship Rules in the Dataview and assign the same pay code to the selected data columns in these entities.

Core entity

Employee

Organization

Day

Organizational Job

Paycode

Labor Category

X

Relationship

One-to-One

One-to-Many

X