The Scheduled Totals entity provides the total scheduled hours, wages, or days related to 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 the Dataview is executed, it will display totals data related to scheduled 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
Scheduled Total Apply Date
Date when the scheduled total was applied
TK_SCHEDULED_APPLY_DATE
Date
No
Scheduled Total Days
Total scheduled days
TK_SCHEDULED_TOTAL_DAYS
Number
Yes
Scheduled Total Hours
Total scheduled hours
TK_SCHEDULED_TOTAL_HOURS
Number
Yes
Scheduled Total Wages
Total scheduled wages
TK_SCHEDULED_TOTAL_WAGES
Number
Yes
Scheduled Total Job Transfer Indicator
Indicates whether the scheduled total includes a job transfer
TK_SCHEDULED_JOB_TRANSFER
Boolean
No
Scheduled Total Labor Transfer Indicator
Indicates whether the scheduled total includes a labor category transfer
When using the Scheduled Totals entity, it is important to include data columns that relate to the selected summarization parameter value. For example, if you are adding the Schedule Total Hours 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: