1,309
edits
Changes
→sqlReports Examples
* [[Media:SqlReport TdapInfoOnSelectedStudents.txt.zip|Health Immunizations-TDAP Records All Active Students by Grade-Level]] - TDAP records for all active students by grade level selected.
* [[Media:SqlReport HealthImmunizationsTDAPMissing.txt.zip|Health Immunizations-TDAP Missing]] - Returns a list of students for the current school whose Health screen does not have a TDAP date recorded.
* [[Media:SqlReport scheduleGapsandDoubles.txt.zip|Schedule Gaps and Double Bookings]] - Reports students who are double booked for a period or who have a non-scheduled period. You must choose a date when class is in session. (i.e. - picking a Saturday won't work). Designed for a 1 day 8 period schedule.
* [[Media:SqlReport noSSOAccounts.txt.zip|No SSO Accounts]] - Lists and makes current selection students who do not have an SSO account. This means parents have not signed up. The report is limited to students who have "AllowWebAccess" checked for a parent.
* [[Media:SqlReport parentemailfinder.txt.zip|Parent Email Finder for SSO]] - Enter all or part of a guardian email address to find where that email address exists in Parent SSO accounts. It could be the main account address or additional notifications the guardian has setup. The report searches both areas.
[[Category: Contents]]
