School Safety Data Collection for Incident Management

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 incidents from the selected date range that are in the (NH/CRDC) Discpline^ Incident Type and the incident has a state reportable Behavior or Action Code with school safety category.

About the School Safety Survey

Harassment Section:
- 2.1 - 2.5 are not on the audit report, this is the count of unique harassment incidents that have at least 1 student reported.
- 2.6 - 2.10 are the student counts of student’s who have a Role of Victim.
- 2.11 - 2.15 are the student counts of student’s who have a Role of Offender and has an Action of In School Suspension, Out of School Suspension or Expelled.
Bullying Section:
- 3.1 - 3.4 Are the counts of all unique bullying/cyberbullying incidents that have at least 1 student reported.
- 3.5 - 3.10 Are the counts of the unique bullying/cyberbullying incidents that have an action code of (NH) Investigated/Actual Bullying/Cyberbullying^.
- 3.11 - 3.17 Are the counts of the unique bullying/cyberbullying incidents that have an action code of (NH) Investigated/Actual Bullying/Cyberbullying^.
Student Discipline Section:
- 4.1.1 - 4.1.10 are not on the audit report, this is the count of unique incidents that have at least 1 student reported with an Action Attribute of (NH) School Safety Category/Student Discipline^. If more than one student with the same action attribute is in the same incident, the action attribute will only be counted once here, but will report all students in the 4.2, 4.3 and 4.4 student counts.
- 4.2.1 - 4.2.10 are the student counts of selected student discipline.
- 4.3.1 - 4.3.10 are the student counts of selected student discipline.
- 4.4.1 - 4.4.10 are the student counts of selected student discipline.
School Safety Section:
- Gun Free Schools Act of 1994
  - 5.1.1 - 5.1.4 are not on the audit report, this is the count of unique incidents that have an Object code of (NH) Weapons^.
- Possession of Firearm
  - 5.2 - Lists each student Grade, Type of Firearm, Identified as Disabled (Participant Attribute of (NH/CRDC) GFSA 1994 Disabled^ or (NH/CRDC) GFSA 1994 Not Disabled^) and Disciplinary Action Taken (subcodes of Participant Attribute of (NH/CRDC) GFSA 1994 Disabled^ or (NH/CRDC) GFSA 1994 Not Disabled^)
- 5.3 Persistently Dangerous Schools
  - 5.3.1 - 5.3.6 are counts of how many times did each of the selected offenses occur during the past school year. There may be multiple offenses involved for any
    one incident that occurred. Each offense is counted separately.

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 for This School	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
Last Name	Student Last Name If an Incident has an Persistently Dangerous School (PDS) Attribute, the last name will be populated with ^PDS)	[Students]Last_Name	Alpha	100
First Name	Student First Name	[Students]First_Name	Alpha	100
Student Number	Student Number	[Students]Student_Number	Numeric	10
Grade	Student Grade Level	[Students]Grade_Level	Number	10
Student School	Student School ID	[Students]SchoolID	Number
Incident Number	Incident ID	[S_NH_LOG_X]SS_incidentID	Numeric	11
Incident School	School the incident occurred
Incident Date	The Incident Date
Role	Role of the Participant If the Last Name is ^PDS the role will be ‘PDS’_ If the record is for Truancy the role will be ‘Truancy’. If the Last Name is blank, this is an unknown participant in the incident.
ISS	Student has an In School Suspension Action Code
OSS	Student has an Out of School Suspension Action Code
Exp	Student has an Expelled Action Code
Section 1: Restraints & Seclusion Information
Restrained Students
SR_1_1	Number of restraint reports generated this school year		Numeric
SR_1_1_1	Active/On-going investigations		Numeric
SR_1_1_2	Closed		Numeric
SR_1_1_3	Occurred at a location other than the school building and/or campus		Numeric
SR_1_2	Number of restraints resulting in bodily injury this school year		Numeric
SR_1_3	Number of restraints resulting in "serious injury or death" this school year		Numeric
Secluded Students
SR_1_4	Number of seclusion reports generated this school year		Numeric
SR_1_4_1	Active/On-going investigations		Numeric
SR_1_4_2	Closed		Numeric
SR_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' are in 2.1 - 2.5 of the School Safety Survey ‘How many students were reported to have been harassed during the past school year on the basis of’ are in 2.6 - 2.10 of the School Safety Survey ‘How many students were disciplined for engaging in harassment during the past school year on the basis of’ are in 2.11 - 2.15 of the School Safety Survey
H_2_G	Gender The numbers of Incidents reported are found in 2.1. Students with a Role of Victim will report in 2.6. Students with a Role of Offender will report in 2.11.		Numeric
H_2_SO	Sexual orientation The numbers of Incidents reported are found in 2.2. Students with a Role of Victim will report in 2.7. Students with a Role of Offender will report in 2.12.		Numeric
H_2_RC	Race, color or national origin The numbers of Incidents reported are found in 2.3. Students with a Role of Victim will report in 2.8. Students with a Role of Offender will report in 2.13.		Numeric
H_2_D	Disability The numbers of Incidents reported are found in 2.4. Students with a Role of Victim will report in 2.9. Students with a Role of Offender will report in 2.14.		Numeric
H_2_PC	Physical characteristics (other that race) The numbers of Incidents reported are found in 2.5. Students with a Role of Victim will report in 2.10. Students with a Role of Offender will report in 2.15.		Numeric
Section 3: Bullying	Indicate the number of incidents during the past year of:
B_3_1	Reported bullying (of any kind)		Numeric
B_3_2	Reported cyber bullying		Numeric
B_3_3	Investigated and actual bullying (of any kind)		Numeric
B_3_4	Investigated and actual cyber bullying		Numeric
Section 3: Bullying	Number of incidents of investigated and actual bullying during the past year that were based on:
B_3_5_G	Gender		Numeric
B_3_6_SO	Sexual Orientation		Numeric
B_3_7_R	Race, color or national origin		Numeric
B_3_8_D	Disability		Numeric
B_3_9_PC	Physical characteristics (other that race)		Numeric
B_3_10_OB	Any other basis		Numeric
Section 3: Bullying	Number of incidents of investigated and actual bullying during the past year that were based on:
B_3_11	Were a single significant event		Numeric
B_3_12	Were a pattern of deliberate harmful events		Numeric
B_3_13	Included physical harm to the victim		Numeric
B_3_14	Included harm to the victim’s property		Numeric
B_3_15	Used social/emotional alienation or tactics		Numeric
B_3_16	Interfered with the victim’s educational opportunities		Numeric
B_3_17	Substantially disrupted the orderly operation of the school		Numeric
Section 4: Student Discipline Section 4.1 is the Count of Incidents and will not print on this audit report. Each unique incident will report in the selected area.
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)
ISS_4_2_1	Violent Incident (with physical injury requiring professional medical attention)		Numeric
ISS_4_2_2	Violent Incident, including harassment & bullying (without physical injury)		Numeric
ISS_4_2_3	Weapons Possession (no injury)		Numeric
ISS_4_2_4	Illicit Drugs		Numeric
ISS_4_2_5	Alcohol		Numeric
ISS_4_2_6	Other Violent Incident, Weapons Possession, Drugs or Alcohol		Numeric
ISS_4_2_7	Disruption		Numeric
ISS_4_2_8	Defiance		Numeric
ISS_4_2_9	Inappropriate Language		Numeric
ISS_4_2_10	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)
OSS_4_3_1	Violent Incident (with physical injury requiring professional medical attention)		Numeric
OSS_4_3_2	Violent Incident, including harassment & bullying (without physical injury)		Numeric
OSS_4_3_3	Weapons Possession (no injury)		Numeric
OSS_4_3_4	Illicit Drugs		Numeric
OSS_4_3_5	Alcohol		Numeric
OSS_4_3_6	Other Violent Incident, Weapons Possession, Drugs or Alcohol		Numeric
OSS_4_3_7	Disruption		Numeric
OSS_4_3_8	Defiance		Numeric
OSS_4_3_9	Inappropriate Language		Numeric
OSS_4_3_10	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)
EXP_4_4_1	Violent Incident (with physical injury requiring professional medical attention)		Numeric
EXP_4_4_2	Violent Incident, including harassment & bullying (without physical injury)		Numeric
EXP_4_4_3	Weapons Possession (no injury)		Numeric
EXP_4_4_4	Illicit Drugs		Numeric
EXP_4_4_5	Alcohol		Numeric
EXP_4_4_6	Other Violent Incident, Weapons Possession, Drugs or Alcohol		Numeric
EXP_4_4_7	Disruption		Numeric
EXP_4_4_8	Defiance		Numeric
EXP_4_4_9	Inappropriate Language		Numeric
EXP_4_4_10	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.
GFA_5_1_1	Handguns		Numeric
GFA_5_1_2	Rifles/Shotguns		Numeric
GFA_5_1_3	More than one type of weapon or firearm		Numeric
GFA_5_1_4	Other		Numeric
GFA_5_2_Disabled	Disciplined for possessing a firearm		Numeric
GFA_5_2_ExpLYmod_Services	One year expulsion not modified, receiving services for possessing a firearm		Numeric
GFA_5_2_Exp1yr_Services	Expulsion modified to less than one year, receiving services for possessing a firearm		Numeric
GFA_5_2_Exp_AltPlace	Expulsion with alternative placement for possessing a firearm		Numeric
GFA_5_2_ExpLYmod_AltPlace	Expulsion modified to less than one year, alternative placement for possessing a firearm		Numeric
GFA_5_2_ExpLYmod_noAltPlace	Expulsion modified to less than one year, no alternative placement for possessing a firearm		Numeric
GFA_5_2_Exp1yr_noAltPlace	One year expulsion not modified, no alternative placement for possessing a firearm		Numeric
GFA_5_2_OtherDA	Other disciplinary action for possessing a firearm		Numeric
GFA_5_2_OtherRemoval	Other Removal (such as death, withdrawal, or incarceration) for possessing a firearm		Numeric
GFA_5_2_NoActiontaken	No action taken 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?
PDS_5_3_1	Homicide		Numeric
PDS_5_3_2	First or second degree assault		Numeric
PDS_5_3_3	Aggravated felonious sexual assault		Numeric
PDS_5_3_4	Arson		Numeric
PDS_5_3_5	Robbery (armed, violent or threatening)		Numeric
PDS_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_
Truancy_6_1	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