School Safety Survey Report
Contents
Introduction
This report function will create a zip file that contains:
- A PDF report that is used to meet state and federal requirements for the collection and reporting of school safety data.
- A CSV audit file that may be opened with a spreadsheet application or text editor that will allow users to see all the students who are enrolled during the user selected start and end date and under which school safety category or categories the students were reported.
The counts may differ between the PDF and CSV files as the PDF report is a summary of all reportable items. The CSV file explains how those totals were derived.
Report Set-Up
- Discipline events to be included in this report, must have a School Safety Category selected on the Log Entries page.
- Daily Attendance Codes are required for the truancy section of the report to be calculated.
Selection Criteria
- This report is to be run by school, not at the District Office.
- This report will include a school if not excluded from state reporting.
- Student has not been excluded from state reporting.
- Student discipline events occurred during the parameter report period.
- This report will include all Log Entries from the selected date range that have a School Safety Category selected.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
|---|---|
Report Parameters | Select Set All; this will store your selections for this report which is helpful when you need to submit a new file and you are unsure of how you created your last file. |
Start Date | Enter the Start Date for which you want to run this report. |
End Date | Enter the End Date for which you want to run this report. |
| Attendance Codes | Choose the codes for which the truancy calculations should be used. |
Scheduling – Run Now | Leave Run Now selected to run the report now. |
Scheduling – Please Select When to run | Click the Schedule button to schedule this report to run nightly. Check the weekdays only box |
PDF Summary Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Item # or Position | Description | [Table]FieldName | Field Type | Field Length |
| Section 1: Restraints & Seclusion Information | ||||
| Restraining Students | ||||
1.1 | Number of restraint reports generated this school year | Numeric | ||
| Of the restraint reports in the previous question, how many were investigated and; | ||||
1.1.1 | Active/On-going investigations | Numeric | ||
1.1.2 | Closed | Numeric | ||
| 1.1.3 | Occurred at a location other than the school building and/or campus | Numeric | ||
| 1.2 | Number of restraints resulting in bodily injury this school year | Numeric | ||
1.3 | Number of restraints resulting in "serious injury or death" this school year | Numeric | ||
Seclusion of Students | ||||
| 1.4 | Number of seclusion reports generated this school year | Numeric | ||
| Of the seclusion reports in the previous question, how many were investigated and are; | ||||
| 1.4.1 | Active/On-going investigations | Numeric | ||
| 1.4.2 | Closed | Numeric | ||
| 1.4.3 | Occurred at a location other than the school building and/or campus | Numeric | ||
| Section 2: Harassment: How Many Incidents were reported during the past school year on the basis of: | ||||
| 2.1 | Gender | Numeric | ||
| 2.2 | Sexual Orientation | Numeric | ||
| 2.3 | Race, color or national origin | Numeric | ||
| 2.4 | Disability | Numeric | ||
| 2.5 | Physical characteristics (other that race) | Numeric | ||
| How many students were reported to have been harassed during the past school year on the basis of: | ||||
| 2.6 | Gender | Numeric | ||
| 2.7 | Sexual Orientation | Numeric | ||
| 2.8 | Race, color or national origin | Numeric | ||
| 2.9 | Disability | Numeric | ||
| 2.10 | Physical characteristics (other that race) | Numeric | ||
| How many students were disciplined for engaging in harassment during the past school year on the basis of: | ||||
| 2.11 | Gender | Numeric | ||
| 2.12 | Sexual Orientation | Numeric | ||
| 2.13 | Race, color or national origin | Numeric | ||
| 2.14 | Disability | Numeric | ||
| 2.15 | Physical characteristics (other that race) | Numeric | ||
| Section 3: Bullying | Indicate the number of incidents during the past year of: | |||
| 3.1 | Reported bullying (of any kind) | Numeric | ||
| 3.2 | Reported cyber bullying | Numeric | ||
| 3.3 | Investigated and actual bullying (of any kind) | Numeric | ||
| 3.4 | Investigated and actual cyber bullying | Numeric | ||
| Number of incidents of investigated and actual bullying during the past year that were based on: | ||||
| 3.5 | Gender | Numeric | ||
| 3.6 | Sexual Orientation | Numeric | ||
| 3.7 | Race, color or national origin | Numeric | ||
| 3.8 | Disability | Numeric | ||
| 3.9 | Physical characteristics (other that race) | Numeric | ||
| 3.10 | Any other basis | Numeric | ||
| Number of incidents of investigated and actual bullying during the past year that were based on: | ||||
| 3.11 | Were a single significant event | Numeric | ||
| 3.12 | Were a pattern of deliberate harmful events | Numeric | ||
| 3.13 | Included physical harm to the victim | Numeric | ||
| 3.14 | Included harm to the victim’s property | Numeric | ||
| 3.15 | Used social/emotional alienation or tactics | Numeric | ||
| 3.16 | Interfered with the victim’s educational opportunities | Numeric | ||
| 3.17 | Substantially disrupted the orderly operation of the school | Numeric | ||
| Section 4: Student Discipline | ||||
| 4.1 | Count of incidents which resulted in expulsions or suspensions for at least one full day. | |||
| 4.1.1 | Violent Incident (with physical injury requiring professional medical attention) | Numeric | ||
| 4.1.2 | Violent Incident, including harassment & bullying (without physical injury) | Numeric | ||
| 4.1.3 | Weapons Possession (no injury) | Numeric | ||
| 4.1.4 | Illicit Drugs | Numeric | ||
| 4.1.5 | Alcohol | Numeric | ||
| 4.1.6 | Other Violent Incident, Weapons Possession, Drugs or Alcohol | Numeric | ||
| 4.1.7 | Disruption | Numeric | ||
| 4.1.8 | Defiance | Numeric | ||
| 4.1.9 | Inappropriate Language | Numeric | ||
| 4.1.10 | All Other | Numeric | ||
| 4.2 In-School Suspensions (students not days) | Count of students who received in-school suspensions for at least 1 full day during the past school year. Note: Counts are by grade-level (KG-15) | |||
| 4.2.1 Most Serious | Violent Incident (with physical injury requiring professional medical attention) | Numeric | ||
| 4.2.2 | Violent Incident, including harassment & bullying (without physical injury) | Numeric | ||
| 4.2.3 | Weapons Possession (no injury) | Numeric | ||
| 4.2.4 | Illicit Drugs | Numeric | ||
| 4.2.5 | Alcohol | Numeric | ||
| 4.2.6 | Other Violent Incident, Weapons Possession, Drugs or Alcohol | Numeric | ||
| 4.2.7 | Disruption | Numeric | ||
| 4.2.8 | Defiance | Numeric | ||
| 4.2.9 | Inappropriate Language | Numeric | ||
| 4.2.10 Least Serious | All Other | Numeric | ||
| 4.3 Out-of_School Suspensions (students not days) | Count of students who received out-of-school suspensions for at least 1 full day during the past school year. Note: Counts are by grade-level (KG-15) | |||
| 4.3.1 Most Serious | Violent Incident (with physical injury requiring professional medical attention) | Numeric | ||
| 4.3.2 | Violent Incident, including harassment & bullying (without physical injury) | Numeric | ||
| 4.3.3 | Weapons Possession (no injury) | Numeric | ||
| 4.3.4 | Illicit Drugs | Numeric | ||
| 4.3.5 | Alcohol | Numeric | ||
| 4.3.6 | Other Violent Incident, Weapons Possession, Drugs or Alcohol | Numeric | ||
| 4.3.7 | Disruption | Numeric | ||
| 4.3.8 | Defiance | Numeric | ||
| 4.3.9 | Inappropriate Language | Numeric | ||
| 4.3.10 Least Serious | All Other | Numeric | ||
| 4.4 Expulsions (students not days) | Count of students who were expelled during the past school year. Note: Counts are by grade-level (KG-15) | |||
| 4.4.1 Most Serious | Violent Incident (with physical injury requiring professional medical attention) | Numeric | ||
| 4.4.2 | Violent Incident, including harassment & bullying (without physical injury) | Numeric | ||
| 4.4.3 | Weapons Possession (no injury) | Numeric | ||
| 4.4.4 | Illicit Drugs | Numeric | ||
| 4.4.5 | Alcohol | Numeric | ||
| 4.4.6 | Other Violent Incident, Weapons Possession, Drugs or Alcohol | Numeric | ||
| 4.4.7 | Disruption | Numeric | ||
| 4.4.8 | Defiance | Numeric | ||
| 4.4.9 | Inappropriate Language | Numeric | ||
| 4.4.10 Least Serious | All Other | Numeric | ||
| Section 5: School Safety | ||||
| 5.1 Gun Free Schools Act of 1994 | Count of firearms incidents which occurred during the school year. | |||
| 5.1.1 | Handguns | Numeric | ||
| 5.1.2 | Rifles/Shotguns | Numeric | ||
| 5.1.3 | More than one type of weapon or firearm | Numeric | ||
| 5.1.4 | Other | Numeric | ||
| 5.2 Disciplined for possessing a firearm. | Output is by Grade, Type of Firearm, Student Identified as Disabled and Disciplinary Action Taken. | |||
| 5.3 Persistently Dangerous Schools | How many times did each of the following offenses occur during the past school year? | |||
| 5.3.1 | Homicide | Numeric | ||
| 5.3.2 | First or second degree assault | Numeric | ||
| 5.3.3 | Aggravated felonious sexual assault | Numeric | ||
| 5.3.4 | Arson | Numeric | ||
| 5.3.5 | Robbery (armed, violent or threatening) | Numeric | ||
| 5.3.6 | Firearms possession or sale | Numeric | ||
| Section 6: Truancy | How many students were habitually truant during the past school year? Habitually truant is defined as ten half days of unexcused absence during a school year. | |||
6.1 Total Truancy | Total number of students who were reported as absent unexcused based on the attendance code(s) selected at run time for 10 days or more. | Numeric | ||
CSV Audit Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Item # or Position | Description | [Table]FieldName | Field Type | Field Length |
Name | Student Full Name | [Students]LastFirst | Alpha | 135 |
| Student Number | Student Number | [Students]Student_Number | Numeric | 10 |
| Student ID | Student ID | [Students]ID | Numeric | 10 |
| State Grade Level | Student Grade Level | [Students]Grade_Level | Number | 10 |
| Incident ID | Log Incident ID | [S_NH_LOG_X]SS_incidentID | Numeric | 11 |
| Section 1: Restraints & Seclusion Information | ||||
| Restraining Students | ||||
1.1 | Number of restraint reports generated this school year | Numeric | ||
| 1.2 | Number of restraints resulting in bodily injury this school year | Numeric | ||
1.3 | Number of restraints resulting in "serious injury or death" this school year | Numeric | ||
| Of the restraint reports in the previous question, how many were investigated and; | ||||
1.1.1 | Active/On-going investigations | Numeric | ||
1.1.2 | Closed | Numeric | ||
| 1.1.3 | Occurred at a location other than the school building and/or campus | Numeric | ||
Seclusion of Students | ||||
| 1.4 | Number of seclusion reports generated this school year | Numeric | ||
| Of the seclusion reports in the previous question, how many were investigated and are; | ||||
| 1.4.1 | Active/On-going investigations | Numeric | ||
| 1.4.2 | Closed | Numeric | ||
| 1.4.3 | Occurred at a location other than the school building and/or campus | Numeric | ||
| Section 2: Harassment: How Many Incidents were reported during the past school year on the basis of: | ||||
| 2.1 | Gender | Numeric | ||
| 2.2 | Sexual Orientation | Numeric | ||
| 2.3 | Race, color or national origin | Numeric | ||
| 2.4 | Disability | Numeric | ||
| 2.5 | Physical characteristics (other that race) | Numeric | ||
| How many students were reported to have been harassed during the past school year on the basis of: | ||||
| 2.6 | Gender | Numeric | ||
| 2.7 | Sexual Orientation | Numeric | ||
| 2.8 | Race, color or national origin | Numeric | ||
| 2.9 | Disability | Numeric | ||
| 2.10 | Physical characteristics (other that race) | Numeric | ||
| How many students were disciplined for engaging in harassment during the past school year on the basis of: | ||||
| 2.11 | Gender | Numeric | ||
| 2.12 | Sexual Orientation | Numeric | ||
| 2.13 | Race, color or national origin | Numeric | ||
| 2.14 | Disability | Numeric | ||
| 2.15 | Physical characteristics (other that race) | Numeric | ||
| Section 3: Bullying | Indicate the number of incidents during the past year of: | |||
| 3.1 | Reported bullying (of any kind) | Numeric | ||
| 3.2 | Reported cyber bullying | Numeric | ||
| 3.3 | Investigated and actual bullying (of any kind) | Numeric | ||
| 3.4 | Investigated and actual cyber bullying | Numeric | ||
| Number of incidents of investigated and actual bullying during the past year that were based on: | ||||
| 3.5 | Gender | Numeric | ||
| 3.6 | Sexual Orientation | Numeric | ||
| 3.7 | Race, color or national origin | Numeric | ||
| 3.8 | Disability | Numeric | ||
| 3.9 | Physical characteristics (other that race) | Numeric | ||
| 3.10 | Any other basis | Numeric | ||
| Number of incidents of investigated and actual bullying during the past year that were based on: | ||||
| 3.11 | Were a single significant event | Numeric | ||
| 3.12 | Were a pattern of deliberate harmful events | Numeric | ||
| 3.13 | Included physical harm to the victim | Numeric | ||
| 3.14 | Included harm to the victim’s property | Numeric | ||
| 3.15 | Used social/emotional alienation or tactics | Numeric | ||
| 3.16 | Interfered with the victim’s educational opportunities | Numeric | ||
| 3.17 | Substantially disrupted the orderly operation of the school | Numeric | ||
| Section 4: Student Discipline | ||||
| 4.1 | Count of incidents which resulted in expulsions or suspensions for at least one full day. | |||
| 4.1.1 | Violent Incident (with physical injury requiring professional medical attention) | Numeric | ||
| 4.1.2 | Violent Incident, including harassment & bullying (without physical injury) | Numeric | ||
| 4.1.3 | Weapons Possession (no injury) | Numeric | ||
| 4.1.4 | Illicit Drugs | Numeric | ||
| 4.1.5 | Alcohol | Numeric | ||
| 4.1.6 | Other Violent Incident, Weapons Possession, Drugs or Alcohol | Numeric | ||
| 4.1.7 | Disruption | Numeric | ||
| 4.1.8 | Defiance | Numeric | ||
| 4.1.9 | Inappropriate Language | Numeric | ||
| 4.1.10 | All Other | Numeric | ||
| 4.2 In-School Suspensions (students not days) | Count of students who received in-school suspensions for at least 1 full day during the past school year. Note: Counts are by grade-level (KG-15) | |||
| 4.2.1 Most Serious | Violent Incident (with physical injury requiring professional medical attention) | Numeric | ||
| 4.2.2 | Violent Incident, including harassment & bullying (without physical injury) | Numeric | ||
| 4.2.3 | Weapons Possession (no injury) | Numeric | ||
| 4.2.4 | Illicit Drugs | Numeric | ||
| 4.2.5 | Alcohol | Numeric | ||
| 4.2.6 | Other Violent Incident, Weapons Possession, Drugs or Alcohol | Numeric | ||
| 4.2.7 | Disruption | Numeric | ||
| 4.2.8 | Defiance | Numeric | ||
| 4.2.9 | Inappropriate Language | Numeric | ||
| 4.2.10 Least Serious | All Other | Numeric | ||
| 4.3 Out-of_School Suspensions (students not days) | Count of students who received out-of-school suspensions for at least 1 full day during the past school year. Note: Counts are by grade-level (KG-15) | |||
| 4.3.1 Most Serious | Violent Incident (with physical injury requiring professional medical attention) | Numeric | ||
| 4.3.2 | Violent Incident, including harassment & bullying (without physical injury) | Numeric | ||
| 4.3.3 | Weapons Possession (no injury) | Numeric | ||
| 4.3.4 | Illicit Drugs | Numeric | ||
| 4.3.5 | Alcohol | Numeric | ||
| 4.3.6 | Other Violent Incident, Weapons Possession, Drugs or Alcohol | Numeric | ||
| 4.3.7 | Disruption | Numeric | ||
| 4.3.8 | Defiance | Numeric | ||
| 4.3.9 | Inappropriate Language | Numeric | ||
| 4.3.10 Least Serious | All Other | Numeric | ||
| 4.4 Expulsions (students not days) | Count of students who were expelled during the past school year. Note: Counts are by grade-level (KG-15) | |||
| 4.4.1 Most Serious | Violent Incident (with physical injury requiring professional medical attention) | Numeric | ||
| 4.4.2 | Violent Incident, including harassment & bullying (without physical injury) | Numeric | ||
| 4.4.3 | Weapons Possession (no injury) | Numeric | ||
| 4.4.4 | Illicit Drugs | Numeric | ||
| 4.4.5 | Alcohol | Numeric | ||
| 4.4.6 | Other Violent Incident, Weapons Possession, Drugs or Alcohol | Numeric | ||
| 4.4.7 | Disruption | Numeric | ||
| 4.4.8 | Defiance | Numeric | ||
| 4.4.9 | Inappropriate Language | Numeric | ||
| 4.4.10 Least Serious | All Other | Numeric | ||
| Section 5: School Safety | ||||
| 5.1 Gun Free Schools Act of 1994 | Count of firearms incidents which occurred during the school year. | |||
| 5.1.1 | Handguns | Numeric | ||
| 5.1.2 | Rifles/Shotguns | Numeric | ||
| 5.1.3 | More than one type of weapon or firearm | Numeric | ||
| 5.1.4 | Other | Numeric | ||
| 5.2 | Disciplined for possessing a firearm | Numeric | ||
| 5.3 Persistently Dangerous Schools | How many times did each of the following offenses occur during the past school year? | |||
| 5.3.1 | Homicide | Numeric | ||
| 5.3.2 | First or second degree assault | Numeric | ||
| 5.3.3 | Aggravated felonious sexual assault | Numeric | ||
| 5.3.4 | Arson | Numeric | ||
| 5.3.5 | Robbery (armed, violent or threatening) | Numeric | ||
| 5.3.6 | Firearms possession or sale | Numeric | ||
| Section 6: Truancy | How many students were habitually truant during the past school year? Habitually truant is defined as ten half days of unexcused absence during a school year. | |||
6.1 Total Truancy | The student's total number of days reported as absent unexcused based on the attendance code(s) selected at run time for any amount of time. | Numeric | ||