Workload – Budgeted Count

The Workload – Budgeted Count entity provides the data for the budgeted 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

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

Label	Description	Key
Budgeted Count		SCH_WORKLOAD_BUDGETED_COUNT
Budgeted Count Date		SCH_WORKLOAD_BUDGETED_COUNT_DATE
Budgeted Count Job		SCH_WORKLOAD_BUDGETED_COUNT_JOB
Budgeted Count Job Group Name*	The job group name for which the budgeted count has been returned.	SCH_WORKLOAD_BUDGETED_COUNT_JOB_GROUP_NAME
Budgeted Count Span Name	The span name for which the budgeted count has been returned.	SCH_WORKLOAD_BUDGETED_COUNT_SPAN_NAME
Budgeted Count Span Type	The span type for which the budgeted count has been returned.	SCH_WORKLOAD_BUDGETED_COUNT_SPAN_TYPE

Related entities

Additional information

Workload budget count data cannot be analyzed with volume entities because volume data is not present at the Job level and workload budget count data is not present at levels of an org that are higher than Job.

Core entity

Employee	Organization	Day	Organizational Job	Paycode	Labor Category
	X

Relationship

One-to-One	One-to-Many
X