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

Options	Description
Term
Division	The major division filter of reported sections
Campus	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)

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. 2)	Oct 30, 2024 18:22	Jordan Lamb
v. 1	Oct 30, 2024 17:19	Michael Citi