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".

Data Granularity

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

Supported Dataview/RDO Type

Employee	Business Structure	Employee - Time Series	Business Structure - Time Series	Work Unit	Work Unit - Time Series

Columns


Paycode Total Projected Days (Include Corrections)	TK_GENIE_PROJECTED_TOTAL_DAYS	Number	Yes
Paycode Total Projected Hours (Include Corrections)	TK_GENIE_PROJECTED_TOTAL_HOURS	Number	Yes
Paycode Total Projected Wages (Include Corrections)	TK_GENIE_PROJECTED_TOTAL_WAGES	Number	Yes

Additional Info

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

Core Entity

Employee	Organization	Day	Organizational Job	Paycode	Labor Category	Activity	Work Unit	Work Group	Procedure Code

Relationship

One-to-One	One-to-Many