.. index::
   tbl1_SPNumbers

==============
tbl1_SPNumbers
==============

.. default-role:: doc

:Description:

   Special Permission Numbers

:Source:

   Provided to office by Registrar each semester via inter-office mail (paper) and also in IMS.
   Office staff imports numbers into Solutions



Columns
=======


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

   :Options:

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


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

   :Description:

      Usable special permission number

   :Options:

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


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

   :Description:

      Session the number can be used for Fall, Spring or Summer

   :Options:

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


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

   :Description:

       Semester year the number can be used for

   :Options:

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


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

   :Description:

      When used for a request, this is id of the request it was issued for

   :Relation:

      relates to RequestID in tbl1_Requests table (and request-specific table)

   :Options:

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


**IssuedDate** ``datetime DEFAULT NULL``

   :Description:

      Date number was issued to a student

   :Options:

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


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

   :Description:

      3-digit course number that the sp number applies to (along with semester, year & section)

   :Options:

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


**SectionNumber** ``varchar(6) DEFAULT NULL``

   :Description:

      Section number that the sp number applies to (along with semester, year & course)

   :Options:

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


**Notes** ``mediumtext DEFAULT NULL``

   :Description:

      Notes that can be entered when number is manually assigned

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