Honors_Candidates_Data_Template

Description

Obsolete. Can drop from MySQL once we are on Solutions frozen version #2 or higher

Columns

ID int(11) NOT NULL

Options

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

Selected bit(1) DEFAULT NULL

Options

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

ruid varchar(255) DEFAULT NULL

Options

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

last_name varchar(255) DEFAULT NULL

Options

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

first_name varchar(255) DEFAULT NULL

Options

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

netid varchar(255) DEFAULT NULL

Options

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

rutgers_school varchar(255) DEFAULT NULL

Options

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

intended_major varchar(255) DEFAULT NULL

Options

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

AB_exam_score int(11) DEFAULT NULL

Options

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

BC_exam_score int(11) DEFAULT NULL

Options

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

AB_exam_subscore int(11) DEFAULT NULL

Options

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

MSAT_Score smallint(6) DEFAULT NULL

Options

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

current_course varchar(255) DEFAULT NULL

Options

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

responsible_dean varchar(255) DEFAULT NULL

Options

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

College varchar(100) DEFAULT NULL

Options

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

preferred_first_name varchar(255) DEFAULT NULL

Options

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

email1 varchar(255) DEFAULT NULL

Options

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

email2 varchar(255) DEFAULT NULL

Options

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

math_placement varchar(255) DEFAULT NULL

Options

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

152H_invite_date datetime DEFAULT NULL

Options

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

291_invite_date datetime DEFAULT NULL

Options

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

251H_invite_date datetime DEFAULT NULL

Options

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

191_invite_date datetime DEFAULT NULL

Options

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

192_invite_date datetime DEFAULT NULL

Options

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

152H_accept_date datetime DEFAULT NULL

Options

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

291_accept_date datetime DEFAULT NULL

Options

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

251H_accept_date datetime DEFAULT NULL

Options

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

191_accept_date datetime DEFAULT NULL

Options

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

192_accept_date datetime DEFAULT NULL

Options

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

152H_decline_date datetime DEFAULT NULL

Options

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

291_decline_date datetime DEFAULT NULL

Options

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

251H_decline_date datetime DEFAULT NULL

Options

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

191_decline_date datetime DEFAULT NULL

Options

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

192_decline_date datetime DEFAULT NULL

Options

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

sp_number int(11) DEFAULT NULL

Options

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

had_question bit(1) DEFAULT NULL

Options

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

section_number varchar(25) DEFAULT NULL

Options

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

prereq_override_generated datetime DEFAULT NULL

Options

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

sph_request_generated datetime DEFAULT NULL

Options

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

question varchar(255) DEFAULT NULL

Options

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

not_invited bit(1) DEFAULT b'0'

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