cfdata_10¶
- 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=""