.. index::
   tbl1_PrereqRequests

===================
tbl1_PrereqRequests
===================

.. default-role:: doc

:Description:

   Student Prerquisite Override requests

:Relation:

   one-to-one with tbl1_Requests table where tbl1_Requests.RequestID = tbl1_PrereqRequests.RequestID
   one-to-one with tbl1_Requests table where tbl1_Requests.RequestID = tbl1_PrereqRequests.RelatedSPRequestID  (optional)

:Footnote:

   It is recommended that in future we consider collapsing this table and all request-specific tables into the single tbl1_Requests table



Columns
=======


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

   :Options:

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


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

   :Relation:

      relates one-to-one with RequestID in `tbl1_Requests` table

   :Options:

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


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

   :Description:

      Course number in format like this: 348 Cryptography

   :Options:

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


**ru_course_number** ``varchar(3) DEFAULT NULL``

   :Description:

      3-digit course number

   :Options:

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


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

   :Options:

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


**ru_course_number2** ``varchar(3) DEFAULT NULL``

   :Description:

      obsolete?

   :Options:

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


**additional_info** ``mediumtext DEFAULT NULL``

   :Description:

      student's entry in the "additional info" request field

   :Options:

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


**decision_code** ``int(11) DEFAULT 0``

   :Description:

      number corresponding to advisor decision made for request.
      see mod_declarations constant declarations for corresponding values

   :Options:

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


**decision_date** ``datetime DEFAULT NULL``

   :Description:

      Decision Date

   :Options:

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


**evaluator_notes** ``mediumtext DEFAULT NULL``

   :Description:

      Evaluator Notes

   :Options:

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


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

   :Description:

      Associated file student uploaded

   :Footnote:

      This will be stored something like this: <upload_path>20181105143914_senior_transcript.pdf
      Where upload_path translates into the location Joomla! is saving the submitted files.  This is represted in Solutions
      code as a global constant in mod_declarations

   :Options:

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


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

   :Description:

      first index number of course student can take

   :Options:

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


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

   :Description:

      second index number of course student can take

   :Options:

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


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

   :Description:

      third index number of course student can take

   :Options:

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


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

   :Description:

      If indicating an honors section, used for the section number

   :Options:

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


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

   :Description:

      RequestID of a related Special Permission Honors request

   :Relation:

      relates to RequestID in `tbl1_Requests`

   :Footnote:

      in honors candidates program, there is a feature to automatically create and approve prerequisite override
      requests when admitting a student into honors courses.  This field links these prereq requests to the honors special permission requests.

   :Options:

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


**revisit_date** ``datetime DEFAULT NULL``

   :Description:

      When status is REVISIT, this is date for evaluator to get back to it

   :Options:

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


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

   :Description:

      a number so can prioritize the requets marked to revisit

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


**duplicate_request** ``bit(1) DEFAULT b'0'``

   :Description:

      TRUE if request is flagged as a duplicate

   :Options:

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