Plan Volume Detail

The Plan Volume Detail entity provides planned volume data. You should always use this entity along with the Plan Volumeentity and either the Plan Volume Detail Schedule Zoneor the Plan Volume Detail Standard Shiftentity. Using them together will provide data in a schedule period for planned volume values by date, by location (above Job) in the Business Structure, and by either 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

Plan Volume Parent ID

SCH_PLAN_VOLUME_DETAIL_PARENT_ID

Plan Volume Plan Type

SCH_PLAN_VOLUME_DETAIL_PLAN_TYPE

Plan Volume Value

SCH_PLAN_VOLUME_DETAIL_VALUE

Plan Weighted Volume

SCH_PLAN_VOLUME_DETAIL_WEIGHTED_VOLUME_AMOUNT

Related entities

Additional information

  • Plan Volume Detail data cannot be analyzed only by department or only by department and date because the current data model does not support aggregation at those levels. The planned 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 planned data cannot be correlated with coverage scheduled count data, workload planned count data, or workload budgeted count data because:
    • The planned data is not present at the Job level at which the workload and coverage scheduled data is present.
    • The workload count or coverage scheduled count data cannot currently be rolled up to nodes 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 first disable the column relationship rules.

Core entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor Category
X

Relationship

One-to-One

One-to-Many
X