.. index:: cfdata_10 ========= cfdata_10 ========= .. default-role:: doc :Description: Table to hold inbound Special Permission Honors Request Data from getforms2.py before processed by Solutions Control Center and moved to `tbl1_Requests` and `tbl1_SPHonorsRequests` tables Columns ======= **id** ``int(11) NOT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **uniq_id** ``varchar(256) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **user_id** ``int(11) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **created** ``datetime DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **modified** ``varchar(256) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **session** ``varchar(256) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **year** ``int(11) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **last_name** ``varchar(256) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **first_name** ``varchar(256) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ruid** ``int(11) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **netid** ``varchar(256) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **todays_date** ``varchar(32) DEFAULT NULL`` :Description: Written by getforms2.py, but not used. :Footnote: Must be a string because the date exported from ChronoForms is formatted incorrectly. :Options: ``display="true", null="true", search="false", type=""`` **class** ``int(11) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **school** ``varchar(256) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **major** ``varchar(256) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **email** ``varchar(256) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **prereq_override_needed** ``varchar(256) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ru_course** ``varchar(256) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **section1** ``varchar(256) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **section2** ``varchar(256) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **section3** ``varchar(256) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **section4** ``varchar(256) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **section5** ``varchar(256) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **transcript_url** ``varchar(256) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **reference** ``varchar(256) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **reason** ``text DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **additional_info** ``text DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **button14** ``varchar(256) 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=""``