.. index::
   tbl1_Semester_Statuses

======================
tbl1_Semester_Statuses
======================

.. default-role:: doc

:Description:

     This table lists all of the semesters known to Solutions so far, and corresponding statuses.



Columns
=======


**ID** ``int(11) NOT NULL AUTO_INCREMENT``

   :Options:

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


**the_semester** ``varchar(25) DEFAULT NULL``

   :Description:

      Fall, Spring or Summer

   :Options:

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


**the_year** ``smallint(6) DEFAULT NULL``

   :Description:

      Semester Year

   :Options:

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


**the_status** ``smallint(6) DEFAULT NULL``

   :Options:

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


**created_date** ``datetime DEFAULT NULL``

   :Description:

      Status code representing semester's status in Solutions (see footnote)

   :Footnote:

      Possible status code values:
      -100=pending (flagged in Solutions database as semester to be brought in from CSS for first time);
      0=in progress (meaning Solutions users are working on this semester -- does not necessarily mean classes have started yet)
      1=committed (after semester is over)
      2=not started (semester in table for other reasons that is not yet active in Solutions -- see other fields for examples)
      4=dates applied (used for payroll functions, likely obsolete)

   :Options:

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


**dont_publish_instructors** ``bit(1) DEFAULT NULL``

   :Description:

      TRUE if we want to publish schedule on website but we want to prevent any instructors from being displayed

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


**subject_codes** ``varchar(255) DEFAULT NULL``

   :Description:

      This is a list of unit and subject codes that we will process for the semester.  Python programs use this list to see what data
      to work with for given semesters.  Typically this will be set to "01:640 16:640 16:642 16:643" for Fall and Spring and "01:640" for summer

   :Options:

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


**scan_for_honors_candidate_responses** ``bit(1) DEFAULT b'0'``

   :Description:

      This will be TRUE if the semester is in a phase where we want to scan for Honors Candidate invitation RSVPs.
      This is set in the Solutions Honors Candidates.

   :Footnote:

      Note that it might be possible to have a semester with this status before the
      typical Solutions programs would care about this semester.  This is the case where the semester's status code value might be 2 (not started) but
      this value would be TRUE

   :Options:

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