Projected Paycode Totals Include Corrections
The Projected Paycode Totals Include Corrections entity provides the total hours, wages, or days that are related to the selected time period for a selected pay code, including any historical correction totals related to the selected time period. 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 (including historical corrections made in that period), configure the Paycode Total Projected Hours (Include Corrections) data column with an assignment value of “REGULAR”.

Employee Dataview | Business Structure Dataview |
---|---|
X |

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

Label | Description | Key |
---|---|---|
Paycode Total Projected Days (Include Corrections) |
TK_GENIE_PROJECTED_TOTAL_DAYS |
|
Paycode Total Projected Hours (Include Corrections) |
TK_GENIE_PROJECTED_TOTAL_HOURS |
|
Paycode Total Projected Wages (Include Corrections) |
TK_GENIE_PROJECTED_TOTAL_WAGES |
|
Projected Hours | Hours that are projected for employees, which takes into account any corrections made to paycode totals. The projected hours includes Non-Worked Pay Codes, regardless of the 'Productive Hours' type, excluding 'Scheduled Hours' type. | TK_GENIE_PROJECTED_TOTAL_HOURS_TIMECARD |

- When using the data columns in the Projected Paycode Totals Include Corrections entity, 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 the Projected Paycode Totals Include Corrections entity multiple times, assigning a different pay code to each. For example, to create a Dataview that shows the actual hours that are related to the “REGULAR” pay code and the “OVERTIME” pay code, you can add the Paycode Total Projected 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 Projected Paycode Totals Include Corrections entity in conjunction with the data columns in the Actual Paycode Totals Include Corrections and the Scheduled Paycode Totals 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.

Employee | Organization | Day | Organizational Job | Paycode | Labor Category |
---|---|---|---|---|---|
X |

One-to-One | One-to-Many |
---|---|
X |