tbl1_FinalExamRooms¶
- Description
This table holds the rooms that can be used for final exams. Solutions’ “Find Exam Rooms” function from the course scheduling screen will use the information in this table to assing exam rooms to sections.
- Footnote
List of available rooms is provided to the Undergraduate Office from Registrar once each semester. For more information, ask the office staff
Columns¶
ID int(11) NOT NULL
- Options
display="true", null="true", search="false", type=""
exam_year int(11) DEFAULT NULL
- Description
semester year
- Options
display="true", null="true", search="false", type=""
exam_session varchar(15) DEFAULT NULL
- Description
fall or spring
- Options
display="true", null="true", search="false", type=""
exam_group varchar(20) DEFAULT NULL
- Description
F, D or B.
- Footnote
Ask Office staff for more information on how the exam groups work
- Options
display="true", null="true", search="false", type=""
set_to_lecture_room bit(1) DEFAULT NULL
- Description
If true, this exam group type will go by the rule that the exam room will be in the same room as the section’s lecture
- Options
display="true", null="true", search="false", type=""
exam_date_and_start_time datetime DEFAULT NULL
- Description
Start date and time of exam for this group, if this group is the type to have large combined lectures
- Options
display="true", null="true", search="false", type=""
lecture_start_time_from varchar(20) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
lecture_start_time_to varchar(20) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room1 varchar(25) DEFAULT NULL
- Description
available room number
- Options
display="true", null="true", search="false", type=""
exam_date datetime DEFAULT NULL
- Description
date of exam
- Options
display="true", null="true", search="false", type=""
room1_capacity smallint(6) DEFAULT NULL
- Description
available room’s capacity
- Options
display="true", null="true", search="false", type=""
exam_start_time varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room2 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
exam_end_time varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room2_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room3 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room3_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room4 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room4_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room5 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room5_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room6 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room6_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room7 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room7_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room8 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room8_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room9 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room9_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room10 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room10_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room11 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room11_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room12 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room12_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room13 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room13_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room14 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room14_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room15 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room15_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room16 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room16_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room17 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room17_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room18 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room18_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room19 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room19_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room20 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room20_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room21 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room21_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room22 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room22_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room23 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room23_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room24 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room24_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room25 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room25_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room26 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room26_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room27 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room27_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room28 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room28_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room29 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room29_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room30 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room30_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room31 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room31_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room32 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room32_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room33 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room33_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room34 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room34_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room35 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room35_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room36 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room36_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room37 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room37_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room38 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room38_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room39 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room39_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room40 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room40_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room41 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room41_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room42 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room42_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room43 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room43_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room44 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room44_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room45 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room45_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room46 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room46_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room47 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room47_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room48 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room48_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room49 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room49_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room50 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room50_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room51 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room51_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room52 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room52_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room53 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room53_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room54 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room54_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room55 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room55_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room56 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room56_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room57 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room57_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room58 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room58_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room59 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room59_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room60 varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
room60_capacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
fill_to_percent smallint(6) DEFAULT NULL
- Description
parameter to tweak when experimenting with the algorithm used to assign exams to rooms
- Footnote
For more info talk to Nishali Mehta
- Options
display="true", null="true", search="false", type=""
fill_algorithm smallint(6) DEFAULT NULL
- Description
use which algorithm to fill rooms
- Footnote
For more info talk to Nishali Mehta
- Options
display="true", null="true", search="false", type=""
last_change timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
- Options
display="true", null="true", search="false", type=""