Actual Paycode Totals - Include Corrections
The Actual 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 Actual 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 Actual Days (Include Corrections) | Returns the day totals for the assigned paycode summed for the timeframe. Note that this column populates only a total for day-type paycodes, including day totals that were generated from a historical correction | TK_GENIE_ACTUAL_TOTAL_DAYS | Number | Yes |
| Paycode Total Actual Hours (Include Corrections) | Returns the hour totals associated with the assigned paycode summed for the timeframe. Note that this column populates only a total for hour-type paycodes, including hour totals that were generated by a historical correction. | TK_GENIE_ACTUAL_TOTAL_HOURS | Number | Yes |
| Actual Hours | TK_GENIE_ACTUAL_TOTAL_HOURS_TIMECARD | Number | No | |
| Paycode Total Actual Wages (Include 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, including those that were generated by a historical correction. | TK_GENIE_ACTUAL_TOTAL_WAGES | Number | Yes |
Related Entities
Additional Info
- When using the data columns in the Actual 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 Actual 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 Actual Paycode Totals Include Corrections entity in conjunction with the data columns in the Projected 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 |
|---|---|