Categories:  Activities - At-Risk - Attendance - Contacts - Enrollment - Fees - Grades - Gradebook - Health - Incident Management - Live Schedules - Logins - Logs - Misc-Staff - Misc-Student - PowerLunch - Scheduling - Single Sign-on - sqlFormLetters - Standards - System Admin - Test Scores


The reports below were created by Matt Freund and are only available to those with an active site subscription.  Clicking on the report name will take you to the page with the coding to import.  Dates below are in the format of MM/DD/YY.  Reports with upload dates prior to 9/1/16 were originally uploaded to sqlreports4.com.   Those with dates between 9/1/16 and 6/1/18 were originally uploaded to sisresources.com.   If there are two dates, the - O is the original upload date and the - U is when an updated version was uploaded.

If you get a Cross-Site Scripting Error when trying to import a report, please read this article - Basic Troubleshooting - Cross-Site Scripting Errors.


These reports should only be used on PS 12 or higher.  They are based on the new tables and fields for student contacts introduced with PS 12.  Reports will import with a SC at the start of the report name and title.  The SC stands for Student Contacts and can be removed if you don't want it as part of the report name or title.

Admin Portal Reports

Report Name / Description Uploaded
  Contacts Primary Email and Phone
This report will return the active contacts for students and the primary email address and phone number for each contact.
  8/26/19
  Contacts Search By Phone Type
This report shows data for either the current school or the current selection. It will return the active contacts for students based on the phone type search criteria.
  5/5/18
  Contacts with SMS Checked
This report shows data for either the current school or the current selection. It will return the active contacts for students that have SMS (text messaging) checked.
  8/26/19
  Counts of Contact Details
Allows admins to view counts regarding information on the Contacts student screen for students at the current school.
  8/26/19
  Detailed Contact Information
This report shows detailed information about the active contacts for the student chosen, including almost everything on the contacts student screen, plus data access information.
  8/30/19
  Mailing Recipients - Cur Sel
Allows admins to view mailing information for student contacts marked to receive mailings.
  5/5/18 - O
7/2/19 - U
  Primary and Emergency - Cur School
Allows admins to view phone numbers for the primary contact and emergency contacts at the current school.
  5/5/18 - O
8/26/19 - U
  Primary and Emergency - Cur Sel
Allows admins to view phone numbers for the primary contact and emergency contacts in the current selection of students.
  5/5/18 - O
8/26/19 - U
  Primary Contacts Email and Phone
The report shows the primary contact for students and the primary email address and phone number for the contact.  It only returns one row per student.
  8/26/19
  Top Three Phone Numbers per Contact
The report will return the active contacts for students and the top three phone numbers per contact.
  8/26/19

Teacher Portal Reports 

Report Name / Description Uploaded
  Mailing Recipients - All Sections (PST)
Allows teachers to view mailing information for student contacts marked to receive mailings in sections where the teacher is the lead teacher.
  5/5/18 - O
7/2/19 - U
  Mailing Recipients - Any Section (PST)
Allows teachers to view mailing information for student contacts marked to receive mailings in the section chosen by the teacher.
  5/5/18 - O
7/2/19 - U
  Primary and Emergency - All Sections (PST)
Allows teachers to view primary and emergency contact information for students in sections where the teacher is the lead teacher.
  5/5/18 - O
8/26/19 - U
  Primary and Emergency - Any Section (PST)
Allows teachers to view primary and emergency contact information for students in a section chosen by the teacher.
  5/5/18 - O
8/26/19 - U
  Primary Contacts Contact - All Sections (PST)
The will return the primary active contact for students in all the sections taught by the teachers.  The primary email and primary phone for the contact is shown.
  8/26/19
  Primary Contacts Contact - Any Section (PST)
The will return the primary active contact for students in the section chosen by the teacher.  The primary email and primary phone for the contact is shown.
  8/26/19
  Top Three Phone Numbers per Contact (PST)
The report will return the active contacts for students in the section chosen by the teacher and the top three phone numbers per contact.
  8/26/19

 

 

© 2009 - present, All Rights Reserved - Matt Freund and Freund Resources