S - Students Restrained or Isolated File 2022-2023
Introduction
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis of report results when the report does not return the correct records.
Student Selection
The report selects records from the [Students] table based on the following criteria:
- The school must be included in the report.
- The school must not be excluded from state reporting.
- The student must not be excluded from state reporting or from CEDARS reporting.
- The student must be enrolled in a school included in the report.
- The student's Incident Date must have occurred after or on the Report Start date and before or on the Report End Date.
- The student's incident must have an incident Action Code of RES (Restraint) or ISO (Isolation)
Report Input
For help with report navigation and generation, see How to Find and Generate a Report.
Field | Description |
Select Schools | Choose one of the following:
The All Schools option is only available when running the report from the District Office. |
Current Selection Students | Indicate which students to include in the report by selecting one of the following options:
If you are running the report for a single student, or a group of students, select the students before running the report.
|
School Year | Choose the year for which to run the report. |
Scheduling | Select Schedule to run the report on a specific date and time. The default setting is 'Run Now.' |
Report Output
Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.
Item | Data Element | Description | [Table]FieldName | Reqd | Field Type | Length |
---|---|---|---|---|---|---|
S01 | School Year | The four-digit year in which the school year ends. | [Terms]LastDay | Yes | Char | 4 |
S02 | County District Code | The County District code for the district submitting the data. | [Prefs]Value [Prefs]Name=districtnumber | Yes | Char | 5 |
S03 | District Student ID | The locally assigned student identifier. | [Students]Student_Number | Yes | VarChar | 50 |
S04 | State Student ID (SSID) | The identifier assigned to each WA public school student by OSPI. Rule: This field is not required if the student has not yet been assigned an SSID. | [Students]State_StudentNumber | Con | Char | 10 |
S05 | Location ID | The Location ID for the school. The school number is reported. | [Schools]School_Number | Yes | VarChar | 4 |
S06 | Action ID | The unique ID that identifies the action. | Incident_Action.Incident_Action_ID | Yes | VarChar | 20 |
S07 | Action Date | The date the action occurred. MM/DD/YYYY format. | [Incident]Incident_TS | Yes | Date | 10 |
S08 | Action Duration | The approximate length of time in minutes that the student was restrained or isolated. Valid values: 0.5to 999.5 | [Incident_Action]Duration_Assigned | Yes | Numeric | 4,1 |
S09 | Type of Restraint or Isolation | The type of restraint or isolation used during this action. Valid Values: Restraint
Isolation
| [Incident_LU_Code] State_Aggregate_Rpt_Code [Incident_LU_Subcode]Code_Type=actioncode | Yes | Char | 2 |
S10 | Was the student injured during the action? | An indicator used to identify if the student was injured during the action in Valid Values:
| Incident_LU_Sub_Code.Code_Type = 'actionattribute' Incident_LU_Sub_Code.State_Aggregate_Rpt_Code = 'ResIso_Stu_Inj' | Yes | Char | 1 |
S11 | How many staff were injured during the action? | The number of staff injured during the reported action of restraint or isolation. Rule: If no staff is injured, the report extracts zero. | Incident_LU_Sub_Code.Code_Type = 'actionattribute' Incident_LU_Sub_Code.State_Aggregate_Rpt_Code = 'ResIso_Staff_Inj' | Yes | ||
S12 | Safety and Security Staff Involvement Status | This element indicates the involvement of the safety or security staff. All instances of school safety or security staff member involvement are reported, regardless of the action reported in Element S09 – Type of Restraint or Isolation. The corresponding action attribute while defining the incident is - Safety or security staff were involved Valid values:
| [Incident_LU_Sub_Code]Code_type=actionattribute [Incident_LU_Code]State_Aggregate_Rpt_Code | Yes | Integer | 1 |
S13 | Safety and Security Staff Involvement Type | This element indicates the involvement type of the safety or security staff. The corresponding action attribute while defining the incident is - Safety or security staff used force Valid values:
Note: If for element S12, Safety and Security Staff Involvement Status is 1 - Safety or security staff were involved, then the value for this data element is required. | [Incident_LU_Sub_Code]Code_type=actionattribute [Incident_LU_Code]State_Aggregate_Rpt_Code | Con | Integer | 1 |
S14 | Safety and Security Staff Involvement Outcome for Student | This element indicates if the student was arrested or not. The corresponding action attribute while defining the incident is - Student was arrested Valid values:
Note: If for element S12, Safety and Security Staff Involvement Status is 1 - Safety or security staff were involved, then the value for this data element is required. | [Incident_LU_Sub_Code]Code_type=actionattribute [Incident_LU_Code]State_Aggregate_Rpt_Code | Con | Integer | 1 |