Data Source	Banner (Oracle)
Job/Process Source (Refresh Interval)	Production (Live)
Report Domain	Room Availability and Scheduling
Functional User(s)
Constituent(s)
Report Owner	Vanessa Escobar
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
Division	The major division filter of reported sections
Campus	District Campus
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.

Version	Date	Comment
Current Version (v. 1)	Oct 30, 2024 17:19	Michael Citi
v. 1	Oct 30, 2024 17:19	Michael Citi