Actual Totals Exclude Corrections
The Actual Totals Exclude Corrections entity provides the total hours, wages, or days related to the selected time period for all transactions performed in the selected time period excluding historical corrections. When creating a Dataview, you can define how the totals data is summarized by selecting the desired parameter value from the following:
- Employee, Date
- Employee, Time Period
- Employee, Pay Code, Date
- Employee, Pay Code, Time Period
- Employee, Job, Date
- Employee, Job, Time Period
- Employee, Job, Pay Code, Date
- Employee, Job, Pay Code, Time Period
- Employee, Labor Category, Date
- Employee, Labor Category, Time Period
- Employee, Labor Category, Pay Code, Date
- Employee, Labor Category, Pay Code, Time Period
- Employee, Job, Labor Category, Date
- Employee, Job, Labor Category, Time Period
- Employee, Job, Labor Category, Pay Code, Date
- Employee, Job, Labor Category, Pay Code, Time Period
For example, if you select the ‘Employee, Pay Code, Time Period’ parameter value, when the Dataview is executed, it will display totals data related to actual transactions (excluding historical corrections) for each employee and pay code with the data summarized for the selected time period.
Supported Dataview types
| Employee Dataview | Business Structure Dataview |
|---|---|
| X |
Data granularity
The granularity is based on the selected summarization parameter value.
Columns
| Label | Description | Key |
|---|---|---|
| Actual Total Apply Date | Date that is associated with the hours/days/wages. Note that the assignment in the hours/days/wages column must include "Date" for this field to populate. | TK_ACTUAL_APPLY_DATE_EXCLUDE_CORRECTIONS |
| Actual Total Job Transfer Indicator | Boolean (true/false) field that indicates if a job transfer is associated with the hours/days/wages. Note that the assignment in the hours/days/wages column must include "Job" for this field to populate. | TK_ACTUAL_JOB_TRANSFER_EXCLUDE_CORRECTIONS |
| Actual Total Labor Category Transfer Indicator | Boolean (true/false) field that indicates if a labor category transfer is associated with the hours/days/wages. Note that the assignment in the hours/days/wages column must include "Labor Category" for this field to populate. The field also includes Cost Center transfers. | TK_ACTUAL_LABOR_TRANSFER_EXCLUDE_CORRECTIONS |
| Actual Total Pay Period Number | Number of the pay period in the calendar year for which the totals are provided. | TK_ACTUAL_PAYPERIOD_NUMBER_EXCLUDE_CORRECTIONS |
| Actual Pay Period Week | Number of the week in the pay period for which the totals are provided (for example, 1 or 2 is a biweekly pay period; 1,2,3, or 4 in a monthly pay period). | TK_ACTUAL_PAYPERIOD_WEEK_EXCLUDE_CORRECTIONS |
| Actual Total Signed Off Indicator | Boolean (true/false) field that indicates if the associated date or timeframe is signed off. | TK_ACTUAL_SIGNED_OFF_EXCLUDE_CORRECTIONS |
| Actual Total Days (Exclude Corrections) | Returns the day totals summed per the assignment selected in the column, excluding days that were generated by historical corrections. | TK_ACTUAL_TOTAL_DAYS_EXCLUDE_CORRECTIONS |
| Actual Total Hours (Exclude Corrections) | Returns the hour totals summed per the assignment selected in the column, excluding hours that were generated by historical corrections. | TK_ACTUAL_TOTAL_HOURS_EXCLUDE_CORRECTIONS |
| Actual Total Wages (Exclude Corrections) | Returns the wage totals summed per the assignment selected in the column, excluding wages that were generated by historical corrections. | TK_ACTUAL_TOTAL_WAGES_EXCLUDE_CORRECTIONS |
| Job Approving Manager ID(s) | List of the IDs of the first five managers who can approve the job worked. Note that this column populates only if the employee has the "Job Approval by Location Manager" Approval Method assigned. (Multiple Approvers) | TK_JOB_APPROVAL_MANAGER_IDS_EXCLUDE_CORRECTIONS |
| Job Approving Manager Name(s) | List of the names of the first five managers who can approve the job worked. Note that this column populates only if the employee has the "Job Approval by Location Manager" Approval Method assigned. (Multiple Approvers) | TK_JOB_APPROVAL_MANAGER_NAMES_EXCLUDE_CORRECTIONS |
| Job Total Approval Status | Indicates if the total has been approved or not. (Multiple Approvers) | TK_JOB_TOTAL_APPROVAL_STATUS_EXCLUDE_CORRECTIONS |
| Job Total Approved by Manager | Name of the manager who approved the total. (Multiple Approvers) | TK_JOB_TOTAL_APPROVED_BY_MANAGER_EXCLUDE_CORRECTIONS |
Additional information
When you use the Actual Totals Exclude Corrections entity, it is important that you include data columns that relate to the selected summarization parameter value. For example, if you are adding the Actual Total Hours (Exclude Corrections) data column to a Dataview and have chosen to summarize by 'Employee, Job, Labor Category, Pay Code, Date', it is critical that you include the following data columns to help the user understand the data that is returned:
| Column name | Entity |
|---|---|
|
Employee Full Name |
|
|
Labor Category Name (Path) |
|
|
Paycode Name |
|
|
Job Name - Full Path (Worked) |
Core entity
| Employee | Organization | Day | Organizational Job | Paycode | Labor Category |
|---|---|---|---|---|---|
| X | X | X | X | X |
Relationship
| One-to-One | One-to-Many |
|---|---|
| X |