.. index::
   exam_schedule

=============
exam_schedule
=============

.. default-role:: doc

: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=""``