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