Home
Data Dictionary entities
B
Budget Volume Detail
The Budget Volume Detail entity provides budget volume data. You always use this entity along with the Budget Volumeentity and either the Budget Volume Detail Schedule Zoneor the Budget Volume Detail Standard Shiftentity. Using them together will provide data in a schedule period for budget volume values by date, by location (above Job) in the Business Structure, and by schedule zone or shift sets.

Data Dictionary entities
- A
- B
  - Budget Volume
    The Budget Volume entity provides two columns, budget volume date and version, which provide the date and version for the budget volume data that has been entered in or imported to Workload Planner.
  - Budget Volume Detail
    The Budget Volume Detail entity provides budget volume data. You always use this entity along with the Budget Volumeentity and either the Budget Volume Detail Schedule Zoneor the Budget Volume Detail Standard Shiftentity. Using them together will provide data in a schedule period for budget volume values by date, by location (above Job) in the Business Structure, and by schedule zone or shift sets.
  - Budget Volume Detail – Schedule Zone
    The Budget Volume Detail – Schedule Zone entity provides the zone details for budget volume data that is present in Workload Planner. These can be analyzed by location (above Job) in the Business Structure.
  - Budget Volume Detail – Standard Shift
    The Budget Volume Detail – Standard Shift entity provides the standard shift details for the budget volume data that is created in Workload Planner. These can be analyzed by location (above Job) in the Business Structure. (Volume is not created at the Job level.)
  - Budget Volume – Schedule Zone
    The Budget Volume – Schedule Zone entity provides the schedule zone details for the budget volume data that is present in Workload Planner.
  - Budget Volume – Schedule Zone Set
    The Budget Volume – Schedule Zone Set entity provides the schedule zone set that is assigned to a location in the Business Structure.
  - Budget Volume – Standard Shift
    The Budget Volume – Standard Shift entity provides the standard shifts for budget volume data that is present in Workload Planner. Because the Budget Volume – Standard Shift entity does not have a relationship with the Budget Volume Detail entity that stores the budget volume value, it is recommended that you use the Budget Volume Detail – Standard Shift entity instead.
  - Budget Volume – Standard Shift Set
    The Budget Volume – Standard Shift Set entity provides the standard shift set that is assigned to a location in the Business Structure.
- C
- E
- Employee HCM
- F
- G
- H
- Healthcare Analytics Data Entities
- J
- K
- L
- M
- N
- O
- P
- R
- S
- T
- V
- W

Budget Volume Detail

The Budget Volume Detail entity provides budget volume data. You always use this entity along with the Budget Volumeentity and either the Budget Volume Detail Schedule Zoneor the Budget Volume Detail Standard Shiftentity. Using them together will provide data in a schedule period for budget volume values by date, by location (above Job) in the Business Structure, and by schedule zone or shift sets.

Supported Dataview types

Employee Dataview	Business Structure Dataview
	X

Data granularity

Provides one row per location (above Job) in the Business Structure per date per schedule zone or shift set.

Columns

Label	Key
Budget Volume Parent ID	SCH_BUDGET_VOLUME_DETAIL_PARENT_ID
Budget Volume Plan Type	SCH_BUDGET_VOLUME_DETAIL_PLAN_TYPE
Budget Volume Value	SCH_BUDGET_VOLUME_DETAIL_VALUE
Budget Weighted Volume	SCH_BUDGET_VOLUME_DETAIL_WEIGHTED_VOLUME_AMOUNT

Related entities

Actual Volume
Actual Volume Detail (Column relationship rules must be disabled.)
Budget Volume Detail(parent entity)
Budget Volume Detail – Schedule Zone(child entity)
Budget Volume Detail – Standard Shift(child entity)
Budget Volume – Standard Shift Set(Column relationship rules must be disabled.)
Budget Volume – Schedule Zone Set(Column relationship rules must be disabled.)
Location
Plan Volume
Plan Volume Detail(Column relationship rules must be disabled.)

Additional information

Budget Volume Detail data cannot be analyzed only by department or only by department and date because the current data model does not support aggregation of data at those levels. The budget volume detail data can be analyzed only by department, span (zone or shift name), and date. This is the granularity at which the data is provided.
The volume data cannot be correlated with coverage scheduled count data, workload planned count data, or workload actual count data because:
- The volume data is not present at the Job level.
- The workload count or coverage scheduled count data cannot be aggregated for location types above Job in the Business Structure.
If you plan to create a Dataview or report data object using plan volume detail, actual volume detail, and budget volume detail together, you must disable the column relationship rules.

Core entity

Employee	Organization	Day	Organizational Job	Paycode	Labor Category
	X

Relationship

One-to-One	One-to-Many
	X