.. index:: tbl1_honors_candidates ====================== tbl1_honors_candidates ====================== .. default-role:: doc :Description: This table is used by the Solutions Honors Candidates utility program to keep track of students who are candidates for math department honors courses. :Source: This table's data is filled by importing data provided by various sources throughout the university (School of Engineering, SAS Honors College, etc). See footnote. :Footnote: Our department goal was to get all of this data in same format in same timeframe so that we could import a single spreadsheet into this program. We have not been successful in coordinating these efforts, so we might require some additional data-formatting procedures before being able to import the data as provided to us by the other colleges. In its current form, the Honors Candidates program will assume imported data is in a format like the sample file in MATHDATA\honors_candidates_data_template.xls Columns ======= **ID** ``int(11) NOT NULL AUTO_INCREMENT`` :Options: ``display="true", null="true", search="false", type=""`` **the_semester** ``varchar(255) DEFAULT NULL`` :Description: Fall or Spring :Footnote: This program has typically only been used before Fall semester when honors candidates are widely recruited; however it can also be used prior to Spring if desired. :Options: ``display="true", null="true", search="false", type=""`` **the_year** ``smallint(6) DEFAULT NULL`` :Description: Semester Year :Options: ``display="true", null="true", search="false", type=""`` **Selected** ``tinyint(1) DEFAULT 0`` :Description: This corresponds to the checkbox to the left of each student data row. Will be TRUE if student's corresponding box is checked. :Options: ``display="true", null="true", search="false", type=""`` **ruid** ``varchar(255) DEFAULT NULL`` :Description: Student's RUID :Footnote: Possible future direction: student data in this table is uniquely used by the honors candidates program. Since we also have student data used in the Request Portal program (`tbl1_Students` table) it might make sense to combine this information in the tbl1_Students table. That will require a lot of changes to the Honors Candidates program, however :Options: ``display="true", null="true", search="false", type=""`` **last_name** ``varchar(255) DEFAULT NULL`` :Description: student's last name :Options: ``display="true", null="true", search="false", type=""`` **first_name** ``varchar(255) DEFAULT NULL`` :Description: student's first name :Options: ``display="true", null="true", search="false", type=""`` **netid** ``varchar(255) DEFAULT NULL`` :Description: student's netid. Obsolete since we use RUID? :Options: ``display="true", null="true", search="false", type=""`` **rutgers_school** ``varchar(255) DEFAULT NULL`` :Description: This corresponds with the source of the student, and is usually "SOE" or "SAS". There is currently no standardization in this field and it comes from imported data. :Footnote: In future we might want to come up with a way to standardize this :Options: ``display="true", null="true", search="false", type=""`` **intended_major** ``varchar(255) DEFAULT NULL`` :Description: comes from imported data; we may or may not have this information for a student :Options: ``display="true", null="true", search="false", type=""`` **AB_exam_score** ``int(11) DEFAULT NULL`` :Description: Calc AP test AB exam score, if available :Options: ``display="true", null="true", search="false", type=""`` **BC_exam_score** ``int(11) DEFAULT NULL`` :Description: Calc AP test BC exam score, if available :Options: ``display="true", null="true", search="false", type=""`` **AB_exam_subscore** ``int(11) DEFAULT NULL`` :Description: Calc AP test AB exam subscore, if available :Options: ``display="true", null="true", search="false", type=""`` **MSAT_Score** ``smallint(6) DEFAULT NULL`` :Description: MSAT score, if available :Options: ``display="true", null="true", search="false", type=""`` **current_course** ``varchar(255) DEFAULT NULL`` :Description: obsolete? :Footnote: was probably intended so advisor can enter what the student's current math course is, although I don't see this field at all in the interface, so guessing it was never used :Options: ``display="true", null="true", search="false", type=""`` **responsible_dean** ``varchar(255) DEFAULT NULL`` :Description: Responsible Dean from Student's college, if provided when importing data :Options: ``display="true", null="true", search="false", type=""`` **College** ``varchar(100) DEFAULT NULL`` :Description: Obsolete? :Options: ``display="true", null="true", search="false", type=""`` **preferred_first_name** ``varchar(255) DEFAULT NULL`` :Description: Obsolete? :Options: ``display="true", null="true", search="false", type=""`` **email1** ``varchar(255) DEFAULT NULL`` :Description: Student's email :Options: ``display="true", null="true", search="false", type=""`` **email2** ``varchar(255) DEFAULT NULL`` :Description: Student's alternate email :Options: ``display="true", null="true", search="false", type=""`` **math_placement** ``varchar(255) DEFAULT NULL`` :Description: Student's Rutgers Math Placement Code :Options: ``display="true", null="true", search="false", type=""`` **152H_invite_date** ``datetime DEFAULT NULL`` :Description: Invite date if student is invited into 152H :Options: ``display="true", null="true", search="false", type=""`` **291_invite_date** ``datetime DEFAULT NULL`` :Description: Invite date if student is invited into 291 :Options: ``display="true", null="true", search="false", type=""`` **251H_invite_date** ``datetime DEFAULT NULL`` :Description: Invite date if student is invited into 251H :Options: ``display="true", null="true", search="false", type=""`` **191_invite_date** ``datetime DEFAULT NULL`` :Description: Invite date if student is invited into 191 :Footnote: Check with math advisor as to whether this and these other honors courses are still being offered. It is possible that some of these course-specific table fields and functionality are obsolete. :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`` :Description: Acceptance date if student has accepted their invitation into 152H :Options: ``display="true", null="true", search="false", type=""`` **291_accept_date** ``datetime DEFAULT NULL`` :Description: Acceptance date if student has accepted their invitation into 291 :Options: ``display="true", null="true", search="false", type=""`` **251H_accept_date** ``datetime DEFAULT NULL`` :Description: Acceptance date if student has accepted their invitation into 251H :Options: ``display="true", null="true", search="false", type=""`` **191_accept_date** ``datetime DEFAULT NULL`` :Description: Acceptance date if student has accepted their invitation into 191 :Options: ``display="true", null="true", search="false", type=""`` **192_accept_date** ``datetime DEFAULT NULL`` :Description: Acceptance date if student has accepted their invitation into 192 :Options: ``display="true", null="true", search="false", type=""`` **152H_decline_date** ``datetime DEFAULT NULL`` :Description: Decline date if student has declined their invitation into 152H :Options: ``display="true", null="true", search="false", type=""`` **291_decline_date** ``datetime DEFAULT NULL`` :Description: Decline date if student has declined their invitation into 291 :Options: ``display="true", null="true", search="false", type=""`` **251H_decline_date** ``datetime DEFAULT NULL`` :Description: Decline date if student has declined their invitation into 291H :Options: ``display="true", null="true", search="false", type=""`` **191_decline_date** ``datetime DEFAULT NULL`` :Description: Decline date if student has declined their invitation into 191 :Options: ``display="true", null="true", search="false", type=""`` **192_decline_date** ``datetime DEFAULT NULL`` :Description: Decline date if student has declined their invitation into 192 :Options: ``display="true", null="true", search="false", type=""`` **sp_number** ``int(11) DEFAULT NULL`` :Description: In Honors Candidates program, this is special permission number assigned if the "Create Special Permission Honors Requests and Assign Special Permission #" button is used. :Options: ``display="true", null="true", search="false", type=""`` **had_question** ``bit(1) DEFAULT b'0'`` :Description: TRUE if student responded (via rsvp chronoform) and checked box that said they have a question :Options: ``display="true", null="true", search="false", type=""`` **section_number** ``varchar(25) DEFAULT NULL`` :Description: If student was given special permission, this is section number that was assigned :Options: ``display="true", null="true", search="false", type=""`` **prereq_override_generated** ``datetime DEFAULT NULL`` :Description: Date prerequisite override was generated (using "Create and Approve Prerequisite Override Requests" button in honors candidates utility program :Options: ``display="true", null="true", search="false", type=""`` **sph_request_generated** ``datetime DEFAULT NULL`` :Description: Date special permission number was given :Options: ``display="true", null="true", search="false", type=""`` **question** ``longtext DEFAULT NULL`` :Description: Question, if student submitted one :Options: ``display="true", null="true", search="false", type=""`` **answered_maybe** ``bit(1) DEFAULT b'0'`` :Description: TRUE if student RSVP'd "maybe" (via chronoform). Often this is the response when a question was submitted. :Options: ``display="true", null="true", search="false", type=""`` **not_invited** ``tinyint(1) DEFAULT 0`` :Description: This checkbox was added to help Advisor flag students they are not inviting, so they can sort list or filter them out :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=""``