.. index::
   Tbl1_Schedule_Data_Unformatted

==============================
Tbl1_Schedule_Data_Unformatted
==============================

.. default-role:: doc

:Description:

   This table is used to hold data as it is imported from CSS. Obsolete?

:Footnote:

   This table was used for holding data that is exported from CSS in Excel format and then imported into Solution.
   Since we have switched to new procedures where new semesters are imported via Control Center, this table is typically not used.
   However, since at time of writing this the Solutions Database still has the option to import semesters directly, this table might still be needed in those cases.



Columns
=======


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

   :Options:

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


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

   :Options:

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


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

   :Options:

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


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

   :Options:

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


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

   :Options:

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


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

   :Options:

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


**Sup#** ``varchar(255) DEFAULT NULL``

   :Options:

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


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

   :Options:

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


**Course Title** ``tinytext DEFAULT NULL``

   :Options:

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


**Full Title** ``tinytext DEFAULT NULL``

   :Options:

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


**Subtitle** ``tinytext DEFAULT NULL``

   :Options:

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


**Credits** ``tinytext DEFAULT NULL``

   :Options:

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


**Instructor** ``tinytext DEFAULT NULL``

   :Options:

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


**Stop Point** ``tinytext DEFAULT NULL``

   :Options:

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


**Prior Enr#** ``tinytext DEFAULT NULL``

   :Options:

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


**Last Offered** ``tinytext DEFAULT NULL``

   :Options:

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


**Course Type** ``tinytext DEFAULT NULL``

   :Options:

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


**CMS Used** ``tinytext DEFAULT NULL``

   :Options:

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


**Active** ``tinytext DEFAULT NULL``

   :Options:

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


**Reviewed** ``tinytext DEFAULT NULL``

   :Options:

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


**Approved** ``tinytext DEFAULT NULL``

   :Options:

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


**BA** ``tinytext DEFAULT NULL``

   :Options:

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


**Day** ``tinytext DEFAULT NULL``

   :Options:

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


**Period** ``tinytext DEFAULT NULL``

   :Options:

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


**Time (start, am/pm, End)** ``tinytext DEFAULT NULL``

   :Options:

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


**Building** ``tinytext DEFAULT NULL``

   :Options:

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


**Room** ``tinytext DEFAULT NULL``

   :Options:

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


**Campus** ``tinytext DEFAULT NULL``

   :Options:

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


**Mode** ``tinytext DEFAULT NULL``

   :Options:

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


**LectureRowID** ``int(11) DEFAULT NULL``

   :Options:

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


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

   :Options:

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


**last_updated** ``datetime DEFAULT NULL``

   :Options:

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


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

   :Options:

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


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

   :Options:

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


**change_message** ``mediumtext DEFAULT NULL``

   :Options:

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


**change_log** ``mediumtext DEFAULT NULL``

   :Options:

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


**summer_section_dates** ``tinytext DEFAULT NULL``

   :Options:

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


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

   :Options:

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


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

   :Options:

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


**final_group** ``tinytext DEFAULT NULL``

   :Options:

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


**final_date** ``datetime DEFAULT NULL``

   :Options:

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


**final_start_time** ``tinytext DEFAULT NULL``

   :Options:

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


**final_end_time** ``tinytext DEFAULT NULL``

   :Options:

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


**final_proctor1** ``tinytext DEFAULT NULL``

   :Options:

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


**final_proctor1_email** ``tinytext DEFAULT NULL``

   :Options:

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


**final_proctor2** ``tinytext DEFAULT NULL``

   :Options:

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


**final_proctor2_email** ``tinytext DEFAULT NULL``

   :Options:

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


**final_building_room** ``tinytext DEFAULT NULL``

   :Options:

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


**final_proctor1_PersonID** ``int(11) DEFAULT NULL``

   :Options:

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


**final_proctor2_PersonID** ``int(11) DEFAULT NULL``

   :Options:

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


**final_campus** ``tinytext DEFAULT NULL``

   :Options:

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


**proctor_notified** ``datetime DEFAULT NULL``

   :Options:

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


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

   :Options:

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


**BuildingRoom** ``tinytext DEFAULT NULL``

   :Options:

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


**PersonID** ``int(11) DEFAULT NULL``

   :Options:

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


**fac_current** ``tinytext DEFAULT NULL``

   :Options:

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


**course_type** ``tinytext 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=""``