tbl1_FinalExamDates¶
- 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=""