Utilization of Scheduled Timeblock Room Capacity

From CSUMB Data Glossary
Jump to navigation Jump to search

Utilization of Scheduled Timeblock Room Capacity is a percentage calculated as the enrolled total divided by the scheduled timeblock room capacity for particular buildings / facilities for timeblocks where academic courses are scheduled in those facilities.

The Utilization of Scheduled Timeblock Room Capacity will exceed 100% if a department over-enrolls a course beyond a facility's capacity.

Metadata
Where Term Appears
CSUMB Data Warehouse Dashboards:
Data Custodian
Academic and Centralized Scheduling
Data Source
Source System:CMS - SA
Source Table Name:N/A
Source Field Name:N/A
Census Process:No
Logical Transformation / Calculation
Calculated as "Fact - Class Meeting Pattern"."Enrolled Total" / sum(CASE "Facility"."Room Capacity" WHEN 0 THEN null ELSE "Facility"."Room Capacity" END)
OBIEE Folder and Column
Folder Heading:Calculated
Column Heading:N/A


Examples

For example, if the scheduled timeblock room capacity for a particular facility is 35 and the enrolled total for the course scheduled in that facility is 37, the Utilization of Scheduled Timeblock Room Capacity would be 106% (37/35*100), which exceeds the scheduled timeblock room capacity.

See Also