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.

Supported Dataview types

Employee Dataview

Business Structure Dataview

X

Data granularity

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

Columns

Label

Description

Key

Planned Count

SCH_WORKLOAD_PLANNED_COUNT

Planned Count Date

SCH_WORKLOAD_PLANNED_COUNT_DATE

Planned Count Job

SCH_WORKLOAD_PLANNED_COUNT_JOB

Planned Count Job Group Name

The job group name for which the planned count has been computed.

Note: This column returns data to reports only when selected using a parameter in BIRT Designer. When selected for a Dataview, it does not return data.

SCH_WORKLOAD_PLANNED_COUNT_JOB_GROUP_NAME

Planned Count Span Name

The span name for which the planned count has been computed.

SCH_WORKLOAD_PLANNED_COUNT_SPAN_NAME

Planned Count Span Type

The span type for which the planned count has been computed.

SCH_WORKLOAD_PLANNED_COUNT_SPAN_TYPE

Additional information

The Coverage — Scheduled Countentity 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.

Core entity

Employee

Organization

Day

Organizational Job

Paycode

Labor Category

X

Relationship

One-to-One

One-to-Many

X