.. index::
   tbl1_Requests

=============
tbl1_Requests
=============

.. default-role:: doc

:Description:

   high-level table to hold student requests

:Relation:

   one-to-one relation with the appropriate request table based on value of the RequestType field.
   for example: one to one relation to tbl1_SPNMRequests where tbl1_Requests.RequestID = tbl1_SPNMRequests.RequestID
   many-to-one relation with `tbl1_Students` where tbl1_Requests.StudentID = tbl1_Students.StudentID
   one-to-one relation with `tbl1_Courses` where tbl1_Requests.requested_course_id = tbl1_Courses.CourseID
   one-to-one relation with `tbl1_Evaluators` where tbl1_Requests.EvaluatorID = tbl1_Evaluators.EvaluatorID

:Footnote:

   It is recommended that in future we consider eliminating all request-specific tables (like tbl1_SPNMRequests) and absorbing all
   information in those tables into this table



Columns
=======


**RequestID** ``int(11) NOT NULL``

   :Options:

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


**StudentID** ``int(11) DEFAULT NULL``

   :Options:

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


**requested_course_id** ``int(11) DEFAULT NULL``

   :Options:

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


**RequestType** ``smallint(6) DEFAULT NULL``

   :Description:

          0=Transfer Credit Preapprovals, 1=Transfer Credit Postapproval, 2=SP Honors, 3=Prereq, 4=SP Non Matric,5=SP multiple failes

   :Options:

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


**request_decision_code** ``int(11) DEFAULT NULL``

   :Description:

      Code corresponding with request decision

   :Options:

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


**course_semester** ``varchar(15) DEFAULT NULL``

   :Description:

      Fall, Spring, Summer

   :Options:

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


**course_year** ``varchar(10) DEFAULT NULL``

   :Description:

      Semester Year

   :Options:

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


**request_date** ``datetime DEFAULT NULL``

   :Description:

      Request Date

   :Options:

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


**EvaluatorID** ``int(11) DEFAULT NULL``

   :Description:

      ID of assigned evaluator

   :Relation:

      one-to-one to EvaluatorID in tbl1_Evaluators table

   :Options:

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


**created_timestamp** ``datetime DEFAULT NULL``

   :Description:

      When was request first created

   :Options:

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


**web_submission_timestamp** ``datetime DEFAULT NULL``

   :Description:

      When was request first submitted on website

   :Options:

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


**uniq_id** ``varchar(255) DEFAULT NULL``

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