tbl1_PrereqRequests¶
- Description
Student Prerquisite Override requests
- Relation
one-to-one with tbl1_Requests table where tbl1_Requests.RequestID = tbl1_PrereqRequests.RequestID one-to-one with tbl1_Requests table where tbl1_Requests.RequestID = tbl1_PrereqRequests.RelatedSPRequestID (optional)
- 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
- 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=""
ru_course2 varchar(255) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
ru_course_number2 varchar(3) DEFAULT NULL
- Description
obsolete?
- Options
display="true", null="true", search="false", type=""
additional_info mediumtext DEFAULT NULL
- Description
student’s entry in the “additional info” request field
- 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=""
decision_date datetime DEFAULT NULL
- Description
Decision Date
- Options
display="true", null="true", search="false", type=""
evaluator_notes mediumtext DEFAULT NULL
- Description
Evaluator Notes
- Options
display="true", null="true", search="false", type=""
file_name varchar(255) DEFAULT NULL
- Description
Associated file student uploaded
- 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=""
index1 varchar(255) DEFAULT NULL
- Description
first index number of course student can take
- Options
display="true", null="true", search="false", type=""
index2 varchar(255) DEFAULT NULL
- Description
second index number of course student can take
- Options
display="true", null="true", search="false", type=""
index3 varchar(255) DEFAULT NULL
- Description
third index number of course student can take
- Options
display="true", null="true", search="false", type=""
honors_section varchar(15) DEFAULT NULL
- Description
If indicating an honors section, used for the section number
- Options
display="true", null="true", search="false", type=""
RelatedSPRequestID int(11) DEFAULT NULL
- Description
RequestID of a related Special Permission Honors request
- Relation
relates to RequestID in tbl1_Requests
- Footnote
in honors candidates program, there is a feature to automatically create and approve prerequisite override requests when admitting a student into honors courses. This field links these prereq requests to the honors special permission requests.
- Options
display="true", null="true", search="false", type=""
revisit_date datetime DEFAULT NULL
- Description
When status is REVISIT, this is date for evaluator to get back to it
- Options
display="true", null="true", search="false", type=""
revisit_priority int(11) DEFAULT NULL
- Description
a number so can prioritize the requets marked to revisit
- 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=""
duplicate_request bit(1) DEFAULT b'0'
- Description
TRUE if request is flagged as a duplicate
- Options
display="true", null="true", search="false", type=""