.. index:: tbl1_FinalExamRooms =================== tbl1_FinalExamRooms =================== .. default-role:: doc :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=""``