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 |
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 |