cfdata_11¶
- Description
Table to hold inbound Transfer Credit Preapproval Request Data from getforms2.py before processed by Solutions Control Center and moved to tbl1_Requests and tbl1_TransferRequests tables
Columns¶
id int(11) NOT NULL DEFAULT 0
- 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=""
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=""
middle_initial 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=""
todays_date varchar(32) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
email_address varchar(256) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
class varchar(256) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
current_degree_requirements varchar(256) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
school varchar(256) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
semester 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=""
course_name varchar(256) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
course_number varchar(256) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
credits int(11) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
start_date varchar(256) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
end_date varchar(256) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
online_course varchar(256) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
preapproval_type varchar(256) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
syllabus_URL varchar(256) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
syllabus_URL2 varchar(256) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
button59 varchar(255) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
file1 varchar(256) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
file2 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=""
student_comments text DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
submit_button varchar(256) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
recipients 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=""