Data Source	Banner (Oracle)
Job/Process Source (Refresh Interval)	Production (Live)
Report Domain	Room Availability and Scheduling
Functional User(s)	Division Chairs, Deans
Constituent(s)
Report Owner	Vanessa Escobar (Scheduling Coordinator)
Data Domain(s)	Academic, Space (Facilities)
Contains PII	No

🛠 What It’s Used For

Reporting on Room Scheduling and Room Availability. Results are typically grouped by Room, then dates & times.

🔘 Options

Options	Description
Term

Semester of interest

Insert excerpt

Division

The major division filter of reported sections

Campus

District

Campus that the building is located
Building	Filter to a specific building.
Room	Filter to a specific room.
Name or ID	Filter results to a specific faculty name or Banner ID
Change Date	Filter results to report sections with an Activity Date (in Banner) on or after the selected date.
Enrollment	Include empty sections in the results if checked.

Field Name	Data Source/Logic	Description (sample)
Campus	`SSBSECT_CAMP_CODE`	Campus where the building/room is located
Building	`SSRMEET_BLDG_CODE`	Building code for the assigned building
Room	`SSRMEET_ROOM_CODE`	Room code for the assigned room inside the building.
Start Time	`SSRMEET_BEGIN_TIME`	Time of day when the section begins
End Time	`SSRMEET_END_TIME`	Time of day when the section ends
Mon, Tue, Wed, Thu, Fri, Sat, Sun	`SSRMEET_###_DAY` (Where `###` is the day)	Return the day(s) listed for the section, or “XX” if none are listed.
Start Date	`SSRMEET_START_DATE`	Date in the semester when the section begins
End Date	`SSRMEET_END_DATE`	Date in the semester when the section ends
Course	`SSBSECT_SUBJ_CODE` & `SSBSECT_CRSE_NUMB`	Combined course code and number
CRN	`SSBSECT_CRN`	CRN
Enroll	`SSBSECT_ENRL`	Actual reported enrollment
Max Enroll	`SSBSECT_MAX_ENRL`	Max allowed enrollment
Room Capacity	`SLBRDEF_MAXIMUM_CAPACITY`	Max allowed room capacity (physical bodies in a room)
Faculty	`SPRIDEN_LAST_NAME` & `SPRIDEN_FIRST_NAME`	Name of the assigned faculty.

...

Change History