.. index:: tbl1_SPNMRequests ================= tbl1_SPNMRequests ================= .. default-role:: doc :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: 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=""``