tbl1_honors_candidates¶
- 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 MATHDATAhonors_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=""