.. index::
   tbl1_SPHonorsRequests

=====================
tbl1_SPHonorsRequests
=====================

.. default-role:: doc

:Description:

   Student Special Permission Honors Requests

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


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

   :Description:

      list of sections student can take (1 of 5)

   :Options:

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


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

   :Description:

      list of sections student can take (2 of 5)

   :Options:

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


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

   :Description:

      list of sections student can take (3 of 5)

   :Options:

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


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

   :Description:

      list of sections student can take (4 of 5)

   :Options:

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


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

   :Description:

      list of sections student can take (5 of 5)

   :Options:

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


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

   :Options:

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


**reason** ``mediumtext DEFAULT NULL``

   :Description:

      What student entered in "Reference" field

   :Options:

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


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

   :Description:

      Evaluator's Decision Date

   :Options:

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


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

   :Description:

      Special Permission Number that is assigned for granted requests

   :Options:

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


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

   :Description:

      Evaluator's notes

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


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

   :Description:

      URL for student transcript

   :Footnote:

      For Rutgers Students this is build with RUID using: https://sis.rutgers.edu/tags/printTranscript.htm?ruid=xxxxxxxx

   :Options:

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


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

   :Description:

      transcript file uploaded by student

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


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

   :Description:

      Additional information submitted by student

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

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


**NeedsPrereq** ``bit(1) DEFAULT NULL``

   :Description:

      TRUE if granted requests will also require student get prerequisite overrides

   :Options:

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


**section_admitted** ``varchar(12) DEFAULT NULL``

   :Description:

       section # student was admitted into

   :Options:

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


**index_admitted** ``varchar(12) DEFAULT NULL``

   :Description:

      index number of course student was admitted into

   :Options:

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


**section_requested** ``varchar(12) DEFAULT NULL``

   :Description:

      section requested for admission

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