Actual Volume

The Actual Volume entity provides two columns, actual volume date and version, which provide the date and version of the actual volume data that has been entered in or imported to Workload Planner. Always use the Actual Volume entity in conjunction with the Actual Volume Detail entity and either the Actual Volume Detail — Schedule Zone or Actual Volume Detail — Standard Shift entity. Using data columns from these entities together will provide actual volume data by date, location (above Job) in the Business Structure, and schedule zone or shift set. Data is supplied for all dates in each schedule period. Version provides the latest version number for which volume is created in the workload planner.

Data Granularity

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

Supported Dataview/RDO Type

Employee Business Structure Employee - Time Series Business Structure - Time Series Work Unit Work Unit - Time Series

Columns

Actual Volume Date SCH_ACTUAL_VOLUME_DATE Date No
Actual Volume Version SCH_ACTUAL_VOLUME_VERSION_COUNT Number No

Additional Info

  • If a location has assigned schedule zones, values will be provided in the schedule zone entity data columns. If a location has assigned standard shifts, values will be provided in the standard shift entity data columns. If a location has both standard shifts and schedule zones assigned, values will be provided only in the standard shift entity data columns.
  • The volume data cannot be correlated with coverage scheduled count data, workload planned count data, or workload budgeted count data.
  • If you plan to create a Dataview or report data object using plan volume, actual volume, budget volume, plan volume detail, actual volume detail, and budget volume detail, you must disable the column relationship rules.

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many