~[if.prefschool.showteacherassignments=1]
~[displaypref:tassignmentsnote-S~(curschoolid)]
| Course Number |
Course Name |
Count |
Section Type |
Terms |
Department |
~[tlist_sql;
SELECT
sta.coursenumber,
crs.course_name,
sta.sectionsassigned,
sta.sectiontype,
sta.scheduletermcode,
scc.sched_department
FROM
scheduleteacherassignments sta INNER JOIN
courses crs ON sta.coursenumber = crs.course_number INNER JOIN
schedulebuilds sb ON sta.buildid = sb.buildid INNER JOIN
schedulecoursecatalogs scc ON
scc.course_number = sta.coursenumber AND
scc.coursecatalogid = sb.coursecatalogid
WHERE
sta.buildid = ~(currentbuildid) AND
sta.teacherkey = ~([05]id)
ORDER BY
sta.coursenumber,sta.scheduletermcode
;alternatecolor]
| ~(sta.coursenumber;t) |
~(crs.course_name;t) |
~(sta.sectionsassigned;l) |
~(sta.sectiontype;t) |
~(sta.scheduletermcode;t) |
~(scc.sched_department;t) |
[/tlist_sql]
[else]
~[displaypref:tassignmentsdisablednote-S~(curschoolid)]
[/if.prefschool.showteacherassignments=1]