PowerSchool SIS Colorado
PowerSchool SIS Colorado
Breadcrumbs

Student Restraint and Seclusion

Introduction

The report extracts one record for each action which has one of the following action attributes selected as Yes

  • Subjected to Seclusion^

  • Subjected to Physical Restraint^

  • Subjected to Mechanical Restraint^

  • Subjected to Prone Restraint^

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.

Student Selection

  • The Incident date falls within the report start and end dates.

  • The action is assigned to the behavior.

  • The behavior is attached to the participant.

  • The participant must be either an Offender or Victim.

  • The Incident, Behavior, and Action are all State Reportable except for the behavior code “Restraint/Seclusion without Discipline^ (00)”.

  • The student subjected to physical restraint or seclusion is not excluded from state reporting.

  • The school where the student is enrolled is not excluded from state reporting.

  • The student is enrolled between the report start and end dates.

Path to access the report: Start Page, Data and Reporting, Reports, Compliance Reports, Periodic Collections.

Report Input

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

Field

Description

Select Schools*

Select one, all or a selection of Schools. A school selection will only be offered at District Office. When running at a school, only that school will be available.

Select Students*

Indicate which students to include in the report by selecting one of the following options:

  • The Selected x Students Only – Run the report for students in the current selection.

  • All Students – Run the report for all students in the current school or district that meet the selection criteria.

If running the report for a single student, or group of students, select the students prior to running the report.

Report Start Date

Select the start date.

Report End Date

Select the end date.

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.

Date Element

Description

[Table]FieldName

Length

District_Code

The reporting School District Code (CDE state district code)

District Number from the District Info page

4

School_Code

The reporting school number.

[Schools]Alternate_School_Number
If not available, then
[Incident]School_Number

4

Event_Identifier

Identifies the action associated with the incident.

If an Action spans two school years, the same Action Identifier will be used to report the record in both school years.


10

SASID

A unique ten-digit number assigned to each student by CDE.

[Students]State_StudentNumber

10

LASID


Student Number

10

First_Name

The first name of the student.

Note: The legal first name is extracted if available, else the first name is extracted from the student's table.

[StudentCoreFields]PSCore_Legal_First_Name

[Students]First_Name

30

Last_Name

The last name of the student.

Note: The legal last name is extracted if available, else the last name is extracted from the student's table.

[StudentCoreFields]PSCore_Legal_Last_Name

[Students]Last_Name

30

Gender

Indicates the gender for action(s) reported.

Valid values:
01 - Female (F)
02 - Male (M)
03 - Non-binary (X)

[StudentCoreFields]PSCore_Legal_Gender

[Students]Gender

2

DOB

The date of birth of the student.

Format: MMDDYYYY.

[Students]DOB

8

Grade_Level

The grade level of the student based on the enrollment.


3

Section_504_Status

This is based on the following condition:

If the Incident Date falls within the Entry and Exit Dates of a student record in the Student’s Special Ed History child table on the Special Ed page and the Section 504 Handicapped checkbox is checked, then 1 is reported, else 0.


1

SPED_Status

This is based on the following condition:

If the Incident Date falls within the Entry and Exit Dates of a student record in the Student’s Special Ed History child table on the Special Ed page and the Special Education (IEP) checkbox is checked, then 1 is reported, else 0.


1

Restraint_Type

The value is taken from the fields under the Restraint and Seclusion of the action attributes.

Valid values:

  • 01 - When Subjected to Physical Restraint^ is Yes in action attributes.

  • 02 - When Subjected to Seclusion^ is Yes in action attributes.

  • 03 - When Subjected to Mechanical Restraint^ is Yes in action attributes.

  • 04 - When Subjected to Prone Restraint^ is Yes in action attributes.


2

Restraint_Length

The value is taken from the Restraint Length^ action attribute.

If the Restraint_Type is ‘01 (Subjected to Physical Restraint^)’, then the actual value of Restraint Length action attribute is displayed.

For any other Restraint_Type or blank value, 00 is displayed.


2

Handcuffed_Ind

Indicates if the student was handcuffed.

The Handcuffed^ action attribute is enabled only when the Subjected to Mechanical Restraint^ action attribute is set to Yes.

If the Handcuffed^ action attribute is set to No or blank, 0 is reported and 1 if it is set to Yes.

If the Handcuffed action attribute is not enabled, N/A is reported.

[PSRW_IncidentActionAttribute]Sub_Category
when [PSRW_IncidentActionAttribute]Incident_Category = 'Handcuffed^’

1