.. index:: tbl1_FinalExamDates =================== tbl1_FinalExamDates =================== .. default-role:: doc :Description: This table holds the final exam schedule per semester per exam group. :Footnote: This table has been obsoleted. it is no longer necessary for office staff to enter the schedule manually from the exam grid. Instead the python program getfinals.py runs and automatically populates the `exam_schedule` table as needed. Then Solutions control center checks on regular intervals for new information in the `exam_schedule` table and populates `tbl1_Schedule_Data` table as is appropriate Columns ======= **ID** ``int(11) NOT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **exam_year** ``int(11) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **exam_session** ``varchar(15) DEFAULT NULL`` :Description: Spring or Fall :Options: ``display="true", null="true", search="false", type=""`` **exam_group** ``varchar(20) DEFAULT NULL`` :Description: Exam group F, B or H :Footnote: As UGOffice Staff for more information about what each exam group designation means :Options: ``display="true", null="true", search="false", type=""`` **lecture_days** ``varchar(15) DEFAULT NULL`` :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=""`` **exam_date** ``datetime DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **exam_start_time** ``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=""`` **last_change** ``timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()`` :Options: ``display="true", null="true", search="false", type=""``