Student Restraint Event Report

Introduction

This report generates Behavioral Intervention records for students enrolled during the selected time frame.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Selection

The report selects records from the [Students] and [ReEnrollments] tables based on the following criteria:

The student must not be excluded from state reporting.
The student has one or more school enrollment records that meet the following criteria.
- The enrollment record is not excluded from state reporting.
- The enrollment Exit Date occurs after the report start date.
- The enrollment Entry Date occurs on or before the report end date.
- Entry date is less than exit date (NS records are ignored)
- The school of enrollment is not excluded from state reporting.
One or more Student Restraint Event records exist for the student in the specified reporting date range and within the student’s school enrolment dates.
- If the student has multiple school enrolments in the same year in a school, all records recorded within all enrollments are reported.
All Students Restraint records that fall within the student school enrolment and within the date range specified are included.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Select Schools	Choose one of the following: Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Note: The All Schools option is only available when running the report from the District Office.
Students to Include	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current selection. All students – Run the report for all students in the current school, selected schools* or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running report.
Start Date	Enter the start date for the report. The start date is the first date that extract scans for student enrollments.
End Date	Enter the end date for the report. The end date is the last date that the extract scans for student enrollments.
SFTP connections	Choose an SFTP connection from the pop-up menu to have the report output uploaded automatically. Please refer to the System Administrator portion of the PowerSchool Administrator User Guide for details on how to create an SFTP connection for use with this new report parameter. Note: Remote connection requires PowerSchool 7.1.4 or higher.

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 #	Data Element	Description	[Table]FieldName	Req	Max Length
1	Submitting District Code	The student’s district of responsibility code proceeded by the letters “NY.” If the Charter and Nonpublic Schools checkbox is selected on the Edit District Information page, then the 8-digit district code and 7-digit institution code are reported. Otherwise, the 6-digit BEDS District Code is reported. Enter the appropriate code for the report during your setup. Refer to BEDS Codes for valid values.	If Pref NY_CHARTER_NP = 0 then ‘NY’ concatenated with Pref NY_BEDS_CODE If Pref NY_CHARTER_NP = 1 and [S_NY_SCH_X]DistrictLocationCode is blank then ‘8’ concatenated with Pref NY_BEDS_CODE If Pref NY_CHARTER_NP = 1 and [S_NY_SCH_X]DistrictLocationCode is not blank then ‘8’ concatenated with [S_NY_SCH_X]DistrictLocationCode	Yes	20
2	Student District Code	The student’s district of responsibility code proceeded by the letters “NY.” If the Charter and Nonpublic Schools checkbox is selected on the Edit District Information page, then the 8-digit district code and 7-digit institution code are reported. Otherwise, the 6-digit BEDS District Code is reported. Enter the appropriate code for the report during your setup. Refer to BEDS Codes for valid values.	Same as above	Yes	20
3	Student ID	The school district student ID. This is a 9-digit number left padded with leading zeros.	[S_NY_STU_X]PreviousStudentNumber [Students]Student_Number	Yes	12
4	School Year Date	June 30^th of the current school year. The report uses the last day of the current/reported school year to get the year to report.	[Terms]LastDay. Picks the year from Last Day of the month and day will be June 30. Format YYYY-06-30	Yes	10
5	Restraint Event Location Code	The student’s building of enrollment code. The value from the Location Code on the Transfer Info page is reported, if populated.	Code [S_NY_SCH_X]BOCESBuilding	Yes	12
6	Restraint Event ID	A unique ID for each reported event.	[S_STU_RESTRAINT_SECL_C]ID	Yes	20
7	Restraint Event Date	Date the event occurred.	[S_STU_RESTRAINT_SECL_C].OCCURRENCEDATE Format: YYYY-MM-DD	Yes	10
8	Reporting Date	June 30 of the reported school year.	Format: YYYY-06-30 Same as School Year Date	Yes	10
9	Restraint Type	Restraint Type	[S_STU_RESTRAINT_SECL_C]EventType Reports: PS_common_code.Alt_report_code	Yes	50
10	Primary Disability Code	Will be blank.	N/A	No	30
11	Student Injured Indicator	Will be blank.	N/A	No	3
12	Staff Injured Indicator	Will be blank.	N/A	No	3
13	Restraint Event Timespan Code	The code of the RESTRAINT EVENT TIMESPAN.	Calculates the minutes between [S_STU_RESTRAINT_SECL_C]OCCURRENCEENDTIME and [S_STU_RESTRAINT_SECL_C]OCCURRENCESTARTTIME Reports as follows: 01 - for 1-5 minutes 02 - for 6-10 minutes 03 - for 11-20 minutes 04 - for 21 or more minutes	Yes	25
14	Substantiated Event	Reported only if the Restraint Type is Aversive, Corporal, Mechanical, Prone, or Seclusion; otherwise, blank. Valid values: Y=Yes N=No	S_STU_RESTRAINT_SECL_C]SubstantiatedEvent	No	3
15	Response Reason Code	Report code for the RESPONSE REASON. Reported only for authorized response types, otherwise blank.	[S_STU_RESTRAINT_SECL_C]PrimaryResponseReason	No	50
16	Staff Training	The type of training the staff person involved in the event has had.. Reported only for authorized response types otherwise, blank.	[S_STU_RESTRAINT_SECL_C]StaffTraining Truncated to 100	No	100
17	Incident Comment	A description of the event.	[S_STU_RESTRAINT_SECL_C]NOTES Truncated to 250	Yes	250