The Projected Paycode Totals Exclude Corrections entity provides the total hours, wages, or days that are related to the selected time period for a selected pay code, minus 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 that are related to the "REGULAR" pay code that apply to the selected time period (excluding historical corrections made in that period), configure the Paycode Total Projected Hours (Exclude 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 (Exclude Corrections)
TK_GENIE_PROJECTED_TOTAL_DAYS_EXCLUDE_CORRECTIONS
Number
Yes
Paycode Total Projected Hours (Exclude Corrections)
When using the data columns in the Projected Paycode Totals Exclude 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 Exclude 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 (Exclude 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 Exclude Corrections entity in conjunction with the data columns in the Actual Paycode Totals Exclude 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