Workload - Planned Count

The Workload - Planned Count entity provides the data for planned employee count that is created in Workload Planner for a location. Its data columns can only be used with a Business Structure Dataview where the Location Type of the Dataview must be configured to “Job,” inasmuch as the data is provided only at the Job level and cannot be summarized at higher levels of the Business Structure.

Data Granularity

Provides one row per job per date per span (schedule zone or shift set).

Supported Dataview/RDO Type

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

Columns
Planned Count SCH_WORKLOAD_PLANNED_COUNT Number No
Planned Count Date SCH_WORKLOAD_PLANNED_COUNT_DATE Date No
Planned Count Job SCH_WORKLOAD_PLANNED_COUNT_JOB String No
Planned Count Job Group Name * The job group name for which the planned count has been computed SCH_WORKLOAD_PLANNED_COUNT_JOB_GROUP_NAME String No
Planned Count Span Name The span name for which the planned count has been computed SCH_WORKLOAD_PLANNED_COUNT_SPAN_NAME String No
Planned Count Span Type The span type for which the planned count has been computed SCH_WORKLOAD_PLANNED_COUNT_SPAN_TYPE String No

Related Entities

Additional Info

  • The Coverage — Scheduled Count entity allows users to analyze scheduled count with workload planned count and workload scheduled count by schedule zone, job, and date
  • Workload planned count data cannot be analyzed in partnership with the volume-focussed entities because volume data is not present at Job level in the Business Structure and the workload planned count data is not present above the Job level
  • The columns marked with an asterisk return data to reports only when selected using a parameter in BIRT Designer. When selected for a Dataview, it does not return data

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many