.. index::
   tbl1_Students

=============
tbl1_Students
=============

.. default-role:: doc

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