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 |
Related entities
- Actual Paycode Totals Corrections Only
- Actual Paycode Totals Exclude Corrections
- Actual Paycode Totals Include Corrections
- Approval Summary
- Employee Details
- Exception Counter
- Pay Period
- Projected Paycode Totals Corrections Only
- Projected Paycode Totals Exclude Corrections
- Projected Paycode Totals Include Corrections
- Sign Off
- Totalization Status
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 and the Projected Paycode Totals Corrections entities 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 |