.. index:: Tblx_DataToSynchronize ====================== Tblx_DataToSynchronize ====================== .. default-role:: doc :Description: This is a temp table used in the reformatting of data pulled in from CSS export/import. The fields in this table parallel the fields that come out of CSS in it's data export. It is somewhat obsolete (see footnote) :Footnote: The usage of this table has been almost fully replaced by the Control Center's automatic Sync in conjunction with the getcss.py program. However, since we still have the capability of doing the original sync method available in Solutions Database interface if needed, it may be too soon to fully obsolete this table. Columns ======= **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** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Period** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Time (start, am/pm, End)** ``varchar(255) 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=""``