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.


Admin Portal Reports

Report Name / Description Uploaded
  Basic Plugin Information
Basic information about plugins that have been installed by users.  Includes when the plugin was installed and column filtering is enabled.
  5/11/15 - O
10/8/19 - U
  Code Sets Information
The report will only show information for code sets with codes. Code sets that have been created but do not have any codes will not appear on the report.
  1/10/20
  CPM - Custom Files Information
Report which will list out all of the custom files in CPM and information about the files.
  5/11/15 - O
1/28/20 - U
  CPM Publish History
A report that allows the admin to see each time a file in CPM was published and who published it.
  1/28/20
  Data Change - Address
Report which shows when a student's or a contact's address was last changed and who changed it and when.
  1/10/20
  Data Change - Contact Email
Report which shows when a contact's email address was last changed and who changed it and when.
  1/10/20
  Data Change - Phone Number
Report which shows when a student's or a contact's phone number was last changed and who changed it and when.
  1/10/20
  Data Change - Student Information
Report which shows when a certain demographic information for a student was last changed and who changed it and when.
  1/10/20
  Data Dictionary - Core Field Search
Report which allows the user to find which core tables contain a field based on the search criteria. Does not include state reporting and user created extended tables like in the Data Dictionary - Field Search report below.
  1/10/20
  Data Dictionary - Core Table Search
Report which allows the user to find core tables contain based on the search criteria. Does not include state reporting and user created extended tables.
  1/10/20
  Data Dictionary - Field Search
Type in the field you want to find and the results should include any table, including extended tables, with that field in it.
  9/25/14
  Data Dictionary - List of Core Tables
Report which lists the core tables based on a data dictionary table. Does not include state reporting and user created extended tables like in the Data Dictionary - Tables report below.
  1/10/20
  Data Dictionary - Tables
Similar to the data dictionary for tables - lists fields, fieldtypes, and field size.
  8/23/14
  Data Dictionary - Views
Similar to the data dictionary for views - lists fields, fieldtypes, and field size.
  8/23/14
  Data Views SQL
Listing of PS views, such as PSRW_HEALTHOFFICEVISITS, and the sql used in creating the view.
  8/23/14
  Extended Field Information
A listing of the extended fields in the database, along with information such as field type and when the field was created.
  6/21/16 - O
10/8/19 - U
  Extended Field Mapping
A listing of the extended fields that are mapped to legacy fields.
  6/21/16
  Extended Table Information
A listing of the extended tables in the database, including the keys necessary to join the table to other tables.
  6/21/16
  Run History - Data As Of
A report that allows the admin to view sqlReports Run History Add-On data as of a specific date.
  2/13/20
  Run History - Overall Count As Of
A report that allows the admin to view a count of the number of times reports have been run based on the data from the sqlReports Run History Add-On as of a specific date.
  2/13/20
  Run History - Report History
A report that allows the admin to see sqlReports Run History Add-On data as of a specific date.
  2/13/20
  Run History - User History
A report that allows the admin to choose a user and view the sqlReports Run History Add-On data as of a specific date.
  2/13/20
  Saved Params - Data As Of
A report that allows the admin to see Saved Params data as of a specific date.
  2/6/20
  Saved Params - Report History
A report that allows the admin to enter a sqlReports ID and see Saved Params data as of a specific date.
  2/6/20
  Saved Params - User History
A report that allows the admin to choose a user and see Saved Params data as of a specific date.
  2/6/20
  Server History
A report that allows the admin to see information (server name, server ip, SIS version, dates and times, etc.) regarding each time a SIS server was restarted.
  1/28/20
  sqlReports Reports Information
Report will list all of the reports in sqlReports by category and show access groups and last time they were run.
  8/23/14

 

 

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