tbl1_Students¶
- Description
Students who have made requests through our web forms and request portal
- Footnote
By design, Solutions does not try to have a database of all students since that would be a huge scope and then we would also have to potentially be concererd with FERPA rules; however, we do keep this accumulated list of students who have submitted requests on our request form, and their basic non-sensitive information. Expanding this table and student database to be broader and consist of additional student who our department might want to be aware of for additional reasons (for example, math majors or minors, honors students, etc) is something that often comes up as a possible future directon for Solutions
Columns¶
StudentID int(11) NOT NULL
- Description
Solutions id for the student
- Options
display="true", null="true", search="false", type=""
ruid varchar(255) DEFAULT NULL
- Description
student’s RUID
- Options
display="true", null="true", search="false", type=""
NetID varchar(10) DEFAULT NULL
- Description
Student’s netid
- Footnote
This might be obsolete in Solutions as we have moved over to using RUID exclusively for students
- Options
display="true", null="true", search="false", type=""
LastName varchar(255) DEFAULT NULL
- Description
Student last name
- Options
display="true", null="true", search="false", type=""
FirstName varchar(255) DEFAULT NULL
- Description
Student first name
- Options
display="true", null="true", search="false", type=""
MiddleInitial varchar(255) DEFAULT NULL
- Description
Middle Initial
- Options
display="true", null="true", search="false", type=""
FullName varchar(255) DEFAULT NULL
- Description
Full name last, first
- Options
display="true", null="true", search="false", type=""
Email varchar(255) DEFAULT NULL
- Description
student email
- Options
display="true", null="true", search="false", type=""
address varchar(255) DEFAULT NULL
- Description
student address
- Options
display="true", null="true", search="false", type=""
Phone varchar(255) DEFAULT NULL
- Description
student phone
- Options
display="true", null="true", search="false", type=""
Notes mediumtext DEFAULT NULL
- Description
notes
- Options
display="true", null="true", search="false", type=""
DateAdded datetime DEFAULT NULL
- Description
date student was added
- Options
display="true", null="true", search="false", type=""
LastNameKey varchar(25) DEFAULT NULL
last name Soundex generated key for student, to enable phonetic searches
- Options
display="true", null="true", search="false", type=""
FirstNameKey varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
birthdate datetime DEFAULT NULL
- Description
first name Soundex generated key for student, to enable phonetic searches
- Options
display="true", null="true", search="false", type=""
student_class varchar(255) DEFAULT NULL
- Description
student’s intended graduation year as self-reported on web forms
- Options
display="true", null="true", search="false", type=""
student_school varchar(255) DEFAULT NULL
- Description
School within Rutgers: SAS, Engineeering, etc
- Options
display="true", null="true", search="false", type=""
student_major varchar(255) DEFAULT NULL
- Description
Student’s self-reported major
- Options
display="true", null="true", search="false", type=""
last_updated datetime DEFAULT NULL
- Description
set by Solutions when last saved
- Options
display="true", null="true", search="false", type=""
gender varchar(25) DEFAULT NULL
- Description
M, F or blank (optional)
- Options
display="true", null="true", search="false", type=""
CommunityCollegeGrad bit(1) DEFAULT NULL
- Description
TRUE if a communit college graduate. Obsolete?
- Footnote
not sure why we have this or if ever used, although it is an available checkbox and filter on student screen in Request Portal
- Options
display="true", null="true", search="false", type=""
Nonstandard bit(1) DEFAULT NULL
- Description
TRUE if a non-standard student
- Footnote
not sure why we have this or if ever used, although it is an available checkbox and filter on student screen in Request Portal
- 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=""