Projected Totals Exclude Corrections

The Projected 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.

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_EXCLUDE_CORRECTIONS

Projected Total Job Transfer Indicator

TK_PROJECTED_JOB_TRANSFER_EXCLUDE_CORRECTIONS

Projected Total Labor Category Transfer Indicator

TK_PROJECTED_LABOR_TRANSFER_EXCLUDE_CORRECTIONS

Projected Total Days (Exclude Corrections)

TK_PROJECTED_TOTAL_DAYS_EXCLUDE_CORRECTIONS

Projected Total Hours (Exclude Corrections)

TK_PROJECTED_TOTAL_HOURS_EXCLUDE_CORRECTIONS

Projected Total Wages (Exclude Corrections)

TK_PROJECTED_TOTAL_WAGES_EXCLUDE_CORRECTIONS

When using the Projected Totals Exclude Corrections 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 (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

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