Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

When admin enters a discipline as the log type and parent notified is checked from the log entry page doesn’t send anything (that I can tell).

Useful SQL Reports?

  1. SQL Reports > Discipline > Bullying Aggressor and Victim Demographics

    1. Report to show you all the bullying incident types and if those events were founded or not. If there was a victim listed, those demographics are shown as “student 2”

      image-20240131-201841.pngImage Added
  2. SQL Reports > Discipline > Bullying Counts

    1. Gives an overview of a school or district level of the total # of bullying incidents during the date range. The unique number of aggressors, total victims and then the unique victim student count. How many were founded, unfounded or unknown founded count

      image-20240131-202202.pngImage Added
  3. SQL Reports > Discipline > Counts of DIsicipline Consequences

    1. Shows a report ran at school or district level of the total # of incidents within a date range, and then the number of unique students for those consequences.

      image-20240131-202327.pngImage Added
  4. SQL Reports > Discipline > Counts of Discipline Types by School

    1. Shows a report ran at school or district level of the total # of incidents within a date range, and then the number of unique students for those incident types. (Limited only to “discipline type” of entries)

      image-20240131-202441.pngImage Added
  5. SQL Reports > Discipline > Counts of Student Consequences

    1. Student centric report to show the number of incident consequences that were logged within a date range.

      image-20240131-202909.pngImage Added
  6. SQL Reports > Discipline > Counts of Student Incidents

    1. Student centric report to show the number of different discipline types entered during a date range.

      image-20240131-203114.pngImage Added
  7. SQL Reports > Discipline > Log Entry Search overview

    1. A student centric report to show a quick overview of the different “flags” that, plus the author of the entry, the date on which the incident occurred, the incident category, subject and a quick link back to the log page.

      image-20240131-203438.pngImage Added
  8. SQL Reports > Discipline > ISBE SIS EOY Collection

    1. A report to assist with the EOY collection details for the 5 discipline questions asked for EOY Data Collection starting in SY22-23. (Note the number in paranathesis is the number of incidents that occured during the date range). [Limited to only Discipline entries, AND where the state disciplinary action isn’t blank]

      image-20240131-203758.pngImage Added
  9. SQL Reports > Discipline > PS vs ISBE SIS - Discipline Comparison

    1. Report used to find “issues” before we send discipline information up to ISBE SIS. In order for the state to accept it, the discipline type, disciplinary action and duration taken needs to not be blank. (Limited only to disicpline type entries where the local consequence is either In School Suspension or Out of School Suspension).

  10. SQL Reports > Discipline > STudent Easy Printing Logs Entries

    1. This is a quick spreadsheet type of print out that you can print out if a parent wants general information on the entries of their student. (suggestion: Get the student as your selection first).