Projected Totals - Corrections Only

The Projected Totals Corrections Only entity provides the total hours, wages or days that are related to all Historical Correction 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.

Data Granularity

The granularity is based on the selected summarization parameter value.

Supported Dataview/RDO Type

Employee Business Structure Employee - Time Series Business Structure - Time Series Work Unit Work Unit - Time Series

Columns

Projected Total Apply Date TK_PROJECTED_APPLY_DATE_ONLY_CORRECTIONS Date No
Projected Total Days (Corrections Only) TK_PROJECTED_TOTAL_DAYS_ONLY_CORRECTIONS Number Yes
Projected Total Hours (Corrections Only) TK_PROJECTED_TOTAL_HOURS_ONLY_CORRECTIONS Number Yes
Projected Total Job Transfer Indicator TK_PROJECTED_JOB_TRANSFER_ONLY_CORRECTIONS Boolean No
Projected Total Labor Category Transfer Indicator TK_PROJECTED_LABOR_TRANSFER_ONLY_CORRECTIONS Boolean No
Projected Total Wages (Corrections Only) TK_PROJECTED_TOTAL_WAGES_ONLY_CORRECTIONS Number Yes

Additional Info

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

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many