Changes

Jump to: navigation, search

SqlReports

1 byte added, 10:18, 17 May 2021
sqlReports Examples
**That all AP course names start with "AP...."
**That the semester 2 termid ends in "02"
* [[Media:CategoryPoints-sqlReports.zip|Category Points]] - Lists all the PTP categories and how many points in each one. User can optionally specify a date rangrange.
* [[Media:SqlReportClassRankAudit.zip|Class Rank Audit]] - Lists all schools in district and their Class Rank recalculation frequency setting and the latest date for which Class Rank was recalculated.
* [[Media:SqlReport CourseRoster.txt.zip|Course Roster]] - Provides a roster of students, course number and term, based on user supplied Course Number. It should work "as is".

Navigation menu