TAB: Schedule Exceptions

Not Yet Complete

TAB: Room Capacity - Section Capacity

Data Source	Oracle
Job/Process Source (Refresh Interval)	Live Data
Functional User(s)	Vanessa Escobar
Report Owner	Vanessa Escobar
Data Domain(s)	Academic Services
Contains PII	No

What It’s Used For

Academic Services uses this to determine if a sections capacity is greater than the capacity of the room.

Options

Options	Description

Options	Description
Term	Choose the term to check comparisons for.

Results

Field Name	Data Source/Logic	Description (sample)

Field Name	Data Source/Logic	Description (sample)
TERM CODE	`SSBSECT.SSBSECT_TERM_CODE`	The term selected for comparison
CRN	`SSBSECT.SSBSECT_CRN`	the CRN for the course
SUBJECT CODE	`SSBSECT.SSBSECT_SUBJ_CODE`	The subject code for the course
COURSE NUMBER	`SSBSECT.SSBSECT_CRSE_NUMB`	The Course Number
ROOM CAPACITY	`MIN(SLBRDEF.SLBRDEF_CAPACITY)`	The minimum capacity for the rooms this course is scheduled to use
SECTION CAPACITY	`MAX(SSBSECT.SSBSECT_MAX_ENRL)`	the maximum enrollment number for this section

Report Domain

This report is built off the SSBSECT and SLBRDEF tables and checks the room the section is in and subtracts the section amount from the capacity to determine which sections have a higher section maximum than the rooms can handle.