tbl1_SPNMRequests¶
- Description
Student Special Permission for Non-Matriculated Student Requests
- Relation
one-to-one with tbl1_Requests table where tbl1_Requests.RequestID = tbl1_SPNMRequests.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=""
student_type smallint(6) DEFAULT NULL
- Description
0=high school; 1=part-time; 2=graduate student;
- 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 tinytext DEFAULT NULL
- Description
Section student would be able to take (1 of 5)
- Options
display="true", null="true", search="false", type=""
section2 varchar(3) DEFAULT NULL
- Description
Section student would be able to take (2 of 5)
- Options
display="true", null="true", search="false", type=""
section3 tinytext DEFAULT NULL
- Description
Section student would be able to take (3 of 5)
- Options
display="true", null="true", search="false", type=""
section4 varchar(3) DEFAULT NULL
- Description
Section student would be able to take (4 of 5)
- Options
display="true", null="true", search="false", type=""
section5 varchar(3) DEFAULT NULL
- Description
Section student would be able to take (5 of 5)
- Options
display="true", null="true", search="false", type=""
reason mediumtext DEFAULT NULL
- Description
Reason student entered on form
- 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_notes mediumtext DEFAULT NULL
- Description
obsolete?
- Options
display="true", null="true", search="false", type=""
sp_number tinytext DEFAULT NULL
- Description
Special Permission number assigned for 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
- 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=""
revisit_date datetime DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
revisit_priority int(11) DEFAULT NULL
- Description
Date to revisit request
- Options
display="true", null="true", search="false", type=""
transcript_url tinytext DEFAULT NULL
- Description
URL of transcript. Not used?
- Options
display="true", null="true", search="false", type=""
duplicate_request bit(1) DEFAULT b'0'
- Options
display="true", null="true", search="false", type=""
transcript_file tinytext DEFAULT NULL
- Description
Transcript file
- Options
display="true", null="true", search="false", type=""
additional_info mediumtext DEFAULT NULL
- 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=""
monday1 tinytext DEFAULT NULL
- Description
One of many date/time cells student fills in to show their current schedule
- Footnote
same for all following dayN fields
- Options
display="true", null="true", search="false", type=""
monday2 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
monday3 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
monday4 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
monday5 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
monday6 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
monday7 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
monday8 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
monday9 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
tuesday1 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
tuesday2 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
tuesday3 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
tuesday4 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
tuesday5 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
tuesday6 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
tuesday7 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
tuesday8 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
tuesday9 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
wednesday1 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
wednesday2 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
wednesday3 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
wednesday4 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
wednesday5 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
wednesday6 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
wednesday7 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
wednesday8 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
wednesday9 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
thursday1 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
thursday2 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
thursday3 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
thursday4 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
thursday5 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
thursday6 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
thursday7 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
thursday8 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
thursday9 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
friday1 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
friday2 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
friday3 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
friday4 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
friday5 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
friday6 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
friday7 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
friday8 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
friday9 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
index tinytext DEFAULT NULL
- Description
index number of section student was admitted into
- Options
display="true", null="true", search="false", type=""
section_admitted varchar(12) DEFAULT NULL
- Description
section number student was admitted into
- 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=""