.. index::
   tbl1_SPMFRequests

=================
tbl1_SPMFRequests
=================

.. default-role:: doc

:Description:

   Student Requests for Permission to take a course after failing multiple times

:Relation:

     one-to-one with tbl1_Requests table where tbl1_Requests.RequestID = tbl1_SPMFRequests.RequestID

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

   :Options:

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


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

   :Description:

      Course number in format like this: 348 Cryptography

   :Options:

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


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

   :Description:

      Section student can take (1 of 5)

   :Options:

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


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

   :Description:

      Section student can take (2 of 5)

   :Options:

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


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

   :Description:

      Section student can take (3 of 5)

   :Options:

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


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

   :Description:

      Section student can take (4 of 5)

   :Options:

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


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

   :Description:

       Section student can take (5 of 5)

   :Options:

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


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

   :Description:

       Decision Date

   :Options:

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


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

   :Description:

      Special Permission number assigned to granted requests

   :Options:

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


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

   :Description:

       Evaluator Notes

   :Options:

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


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

   :Options:

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


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

   :Description:

      Revisit Date

   :Options:

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


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

   :Description:

      Revisit Priority

   :Options:

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


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

   :Description:

      TRUE if request was flagged as a duplicate

   :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

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