tbl1_SPHonorsRequests¶
- Description
Student Special Permission Honors Requests
- 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=""
section1 varchar(255) DEFAULT NULL
- Description
list of sections student can take (1 of 5)
- Options
display="true", null="true", search="false", type=""
section2 varchar(3) DEFAULT NULL
- Description
list of sections student can take (2 of 5)
- Options
display="true", null="true", search="false", type=""
section3 varchar(255) DEFAULT NULL
- Description
list of sections student can take (3 of 5)
- Options
display="true", null="true", search="false", type=""
section4 varchar(3) DEFAULT NULL
- Description
list of sections student can take (4 of 5)
- Options
display="true", null="true", search="false", type=""
section5 varchar(3) DEFAULT NULL
- Description
list of sections student can take (5 of 5)
- Options
display="true", null="true", search="false", type=""
reference varchar(255) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
reason mediumtext DEFAULT NULL
- Description
What student entered in “Reference” field
- 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_number varchar(255) DEFAULT NULL
- Description
Special Permission Number that is assigned for granted requests
- Options
display="true", null="true", search="false", type=""
evaluator_notes mediumtext DEFAULT NULL
- Description
Evaluator’s 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=""
transcript_url varchar(255) DEFAULT NULL
- Description
URL for student transcript
- Footnote
For Rutgers Students this is build with RUID using: https://sis.rutgers.edu/tags/printTranscript.htm?ruid=xxxxxxxx
- Options
display="true", null="true", search="false", type=""
transcript_file varchar(255) DEFAULT NULL
- Description
transcript file uploaded by student
- 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=""
additional_info mediumtext DEFAULT NULL
- Description
Additional information submitted by student
- 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
- 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=""
NeedsPrereq bit(1) DEFAULT NULL
- Description
TRUE if granted requests will also require student get prerequisite overrides
- 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 for admission
- 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=""