exam_schedule

Description

This table holds the final exam schedules as pulled from the SAS final exam schedule website, https://finalexams.rutgers.edu/ It is populated at regular intervals when the python getfinals.py program is run. This program takes data from the Rutgers SAS final exam schedule website and fills this table with exam dates for upcoming semester as they are posted. Solutions Control Center will then periodically check for new schedules and when found incorporate the dates into the semester schedules in the tbl1_Schedule_Data and tbl1_FinalExamDates tables

Columns

id int(11) NOT NULL AUTO_INCREMENT

Options

display="true", null="true", search="false", type=""

year int(11) DEFAULT 0

Options

display="true", null="true", search="false", type=""

term varchar(1) DEFAULT NULL

Description

will be Fall, Spring or Summer

Options

display="true", null="true", search="false", type=""

unit varchar(45) DEFAULT NULL

Description

course unit, typically 01 or 16

Options

display="true", null="true", search="false", type=""

subject varchar(45) DEFAULT NULL

Description

3-digit course subject code

Options

display="true", null="true", search="false", type=""

index_number varchar(45) DEFAULT NULL

Options

display="true", null="true", search="false", type=""

section varchar(45) DEFAULT NULL

Options

display="true", null="true", search="false", type=""

exam_code varchar(45) DEFAULT NULL

Description

exam group that schedule applies to. Exams are categorized as either B, C or F

Options

display="true", null="true", search="false", type=""

exam_day_and_time varchar(45) DEFAULT NULL

Description

will be in format as it appears on RU schedule website, for example “May 09, 2019: 4:00 PM - 7:00 PM”

Options

display="true", null="true", search="false", type=""