~[wc:commonscripts]
~[wc:admin_header_css]
~[text:psx.html.admin_reports.runreports.start_page]
>
System Reports
> Course Recommendations ~[wc:admin_navigation_css]
Course Recommendations
Search Options
Students
School Year
Department
All
Students in Current Selection ({{studsinset}})
~[tlist_sql; SELECT DISTINCT terms.yearid, CASE WHEN TO_CHAR(terms.abbreviation) = '~(gpv.year;sqlText)' THEN 'selected' ELSE '' END slct, terms.abbreviation FROM terms WHERE (terms.yearid = ~(curyearid) OR terms.yearid = (~(curyearid) + 1)) AND terms.schoolid = 0 AND terms.isyearrec = 1 ORDER BY terms.yearid ;]
~(abbr)
[/tlist_sql]
All
~[tlist_sql; SELECT DISTINCT courses.sched_department FROM courseprereqrecommend JOIN courses ON courses.id = courseprereqrecommend.courseid JOIN students ON students.id = courseprereqrecommend.studentid WHERE students.schoolid = ~(curschoolid) ORDER BY courses.sched_department ASC ;]
~(sched_department)
[/tlist_sql]
Search
Filter Table
No recommendations for the chosen fields
Year
Student Name
Student Number
Course Number
Course Name
Department
Recommended By
Comments
Edit
{{stu.year}}
{{stu.student_name}}
{{stu.student_number}}
{{stu.course_number}}
{{stu.course_name}}
{{stu.department}}
{{stu.recommended_by}}
{{stu.comments}}
Make Current Selection
Export
~[wc:mbaSchedulingResources/ez_verify] ~[wc:admin_footer_css]