tbl1_SPNumbers¶
- 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=""