Tables Modified: [ElectiveInTemplate] Procedure: usedTemplateName Description: Checks whether a certain name is already in use by another template Inputs: name Query Result: 1 if it is in use, 0 otherwise. Result Format: N/A Tables Accessed: [Template] Fields Accessed: [Template]: name Tables Modified: N/A Procedure: getScheduleCourseInfo Gets a list of all the courses in an advisee’s schedule. Description: Inputs: adviseeID Result: A result set of all the courses in an advisee’s schedule with all the information necessary for display on the application. courseID, dpt, num, name, credits, term Result Format: Tables Accessed: [CourseInSchedule] [Course] Fields Accessed: [CourseInSchedule]: adviseeID, courseID, term [Course]: courseID, dpt, num, name, credits N/A Tables Modified: Procedure: getScheduleElectiveInfo Description: Gets a list of all the electives in an advisee’s schedule Inputs: adviseeID Query Result: A result set of all the electives in an advisee’s schedule with all the information necessary for display on the application (except for the drop-down choices). Result Format: electiveID, term, [Elective].name, selectedCourseID, term, dpt, num, [Course].name, credits Tables Accessed: [Elective] [ElectiveInSchedule] [Course] Fields Accessed: [Elective]: electiveID, name [ElectiveInSchedule]: adviseeID, electiveID, selectedCourseID, term
Tables Modified: [ElectiveInTemplate] Procedure: usedTemplateName Description: Checks whether a certain name is already in use by another template Inputs: name Query Result: 1 if it is in use, 0 otherwise. Result Format: N/A Tables Accessed: [Template] Fields Accessed: [Template]: name Tables Modified: N/A Procedure: getScheduleCourseInfo Description: Gets a list of all the courses in an advisee’s schedule. Inputs: adviseeID Result: A result set of all the courses in an advisee’s schedule with all the information necessary for display on the application. Result Format: courseID, dpt, num, name, credits, term Tables Accessed: [CourseInSchedule] [Course] Fields Accessed: [CourseInSchedule]: adviseeID, courseID, term [Course]: courseID, dpt, num, name, credits Tables Modified: N/A Procedure: getScheduleElectiveInfo Description: Gets a list of all the electives in an advisee’s schedule Inputs: adviseeID Query Result: A result set of all the electives in an advisee’s schedule with all the information necessary for display on the application (except for the drop-down choices). Result Format: electiveID, term, [Elective].name, selectedCourseID, term, dpt, num, [Course].name, credits Tables Accessed: [Elective] [ElectiveInSchedule] [Course] Fields Accessed: [Elective]: electiveID, name [ElectiveInSchedule]: adviseeID, electiveID, selectedCourseID, term
DesignDocument_rev0.97.docx