tbl1_Requests¶
- Description
high-level table to hold student requests
- Relation
one-to-one relation with the appropriate request table based on value of the RequestType field. for example: one to one relation to tbl1_SPNMRequests where tbl1_Requests.RequestID = tbl1_SPNMRequests.RequestID many-to-one relation with tbl1_Students where tbl1_Requests.StudentID = tbl1_Students.StudentID one-to-one relation with tbl1_Courses where tbl1_Requests.requested_course_id = tbl1_Courses.CourseID one-to-one relation with tbl1_Evaluators where tbl1_Requests.EvaluatorID = tbl1_Evaluators.EvaluatorID
- Footnote
It is recommended that in future we consider eliminating all request-specific tables (like tbl1_SPNMRequests) and absorbing all information in those tables into this table
Columns¶
RequestID int(11) NOT NULL
- Options
display="true", null="true", search="false", type=""
StudentID int(11) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
requested_course_id int(11) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
RequestType smallint(6) DEFAULT NULL
- Description
0=Transfer Credit Preapprovals, 1=Transfer Credit Postapproval, 2=SP Honors, 3=Prereq, 4=SP Non Matric,5=SP multiple failes
- Options
display="true", null="true", search="false", type=""
request_decision_code int(11) DEFAULT NULL
- Description
Code corresponding with request decision
- Options
display="true", null="true", search="false", type=""
course_semester varchar(15) DEFAULT NULL
- Description
Fall, Spring, Summer
- Options
display="true", null="true", search="false", type=""
course_year varchar(10) DEFAULT NULL
- Description
Semester Year
- Options
display="true", null="true", search="false", type=""
request_date datetime DEFAULT NULL
- Description
Request Date
- Options
display="true", null="true", search="false", type=""
EvaluatorID int(11) DEFAULT NULL
- Description
ID of assigned evaluator
- Relation
one-to-one to EvaluatorID in tbl1_Evaluators table
- Options
display="true", null="true", search="false", type=""
created_timestamp datetime DEFAULT NULL
- Description
When was request first created
- Options
display="true", null="true", search="false", type=""
web_submission_timestamp datetime DEFAULT NULL
- Description
When was request first submitted on website
- Options
display="true", null="true", search="false", type=""
uniq_id varchar(255) DEFAULT NULL
- 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=""