Projected Totals Corrections Only

The Projected Totals Corrections Only entity provides the total hours, wages or days that are related to all Historicalhorrection transactions that were performed in the selected time period for all historical correction transactions that were performed in the selected time period. 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 you execute a Dataview, it will return totals data related to projected historical correction transactions for each employee and pay code with the data summarized for the selected time period.

Employee Dataview Business Structure Dataview
X  

The granularity is based on the selected summarization parameter value.

Label Key

Projected Total Apply Date

TK_PROJECTED_APPLY_DATE_ONLY_CORRECTIONS

Projected Total Days (Corrections Only)

TK_PROJECTED_TOTAL_DAYS_ONLY_CORRECTIONS

Projected Total Hours (Corrections Only)

TK_PROJECTED_TOTAL_HOURS_ONLY_CORRECTIONS

Projected Total Job Transfer Indicator

TK_PROJECTED_JOB_TRANSFER_ONLY_CORRECTIONS

Projected Total Labor Category Transfer Indicator

TK_PROJECTED_LABOR_TRANSFER_ONLY_CORRECTIONS

Projected Total Wages (Corrections Only)

TK_PROJECTED_TOTAL_WAGES_ONLY_CORRECTIONS

When using the Projected Totals Corrections Only entity, it is important to include data columns that relate to the selected summarization parameter value. For example, if you are adding the Projected Total Hours (Corrections Only) 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

Employee Details

Labor Category Name (Path)

Labor Category

Paycode Name

Paycode

Job Name - Full Path (Worked)

Worked Job

Employee Organization Day Organizational Job Paycode Labor Category
X   X X X X
One-to-One One-to-Many
  X