Actual Paycode Totals - Exclude Corrections
The Actual 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 Actual 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 Actual Days (Exclude Corrections) | Returns the day totals for the assigned paycode summed for the timeframe. Note that this column populates a total only for day-type paycodes, excluding day totals that were generated from a historical correction. | TK_GENIE_ACTUAL_TOTAL_DAYS_EXCLUDE_CORRECTIONS | Number | Yes |
| Paycode Total Actual Hours (Exclude Corrections) | Returns the hour totals for the assigned paycode summed for the timeframe. Note that this column populates a total for only hour-type paycodes excluding hour totals that were generated from a historical correction. | TK_GENIE_ACTUAL_TOTAL_HOURS_EXCLUDE_CORRECTIONS | Number | Yes |
| Paycode Total Actual Wages (Exclude Corrections) | Returns the wage totals associated with the assigned paycode summed for the timeframe. Note that this column populates only a total for hour or wage paycodes that have a monetary amount associated with them, excluding those that were generated by a historical correction. | TK_GENIE_ACTUAL_TOTAL_WAGES_EXCLUDE_CORRECTIONS | Number | Yes |
Related Entities
Additional Info
- When using the data columns in the Actual 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 Actual 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 Actual 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 Actual Paycode Totals Exclude Corrections entity in conjunction with the data columns in the Projected 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.
Core Entity
| Employee | Organization | Day | Organizational Job | Paycode | Labor Category | Activity | Work Unit | Work Group | Procedure Code |
|---|---|---|---|---|---|---|---|---|---|
Relationship
| One-to-One | One-to-Many |
|---|---|