R - Student Exclusionary Discipline File 2019-2020

Introduction

This file captures information regarding behavior and exclusionary discipline actions for students involved in incidents during school or school-related activities. All firearm incidents must be reported, regardless of the exclusionary action applied. This file only collects information related to students who received disciplinary actions, not all student(s) affected by the disciplinary incident.

This file consists of one record for each exclusionary discipline action recorded for a student offender as part of an incident during the current school year. If multiple students are associated with the same incident, then one record must be submitted for each student being disciplined.

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 student must be the offender in an incident with a reportable behavior or a reportable action.
The student must have had disciplinary action taken against them connected to the incident.

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: 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. 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: 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 or district that meet the selection criteria. 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. Default 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
R01	School Year	The four-digit year in which the school year ends.	[Terms]LastDay	Yes	Char	4
R02	Serving County District Code	The County District code for the district submitting the data.	[Prefs]Value [Prefs]Name=districtnumber	Yes	Char	5
R03	District Student ID	The locally assigned student identifier.	[Students]Student_Number	Yes	VarChar	50
R04	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
R05	Location ID	The Location ID for the school. The school number is reported.	[Schools]School_Number	Yes	VarChar	4
R06	Incident ID	The ID number of the incident with which the offender is associated.	[Incident]Incident_ID	Yes	VarChar	20
R07	Incident Date	The date the reported incident occurred	[Incident]Incident_TS	Yes	Date	10
R08	Behavior Code	The behavior of the student as it relates to the incident.	[Incident_LU_Code] State_Aggregate_Rpt_Code [Incident_LU_Code]Code_Type = behaviorcode	Yes	Integer	2
R09	Other Behaviors	This element indicates any additional behaviors associated with the incident.	[Incident_LU_Code] State_Aggregate_Rpt_Code [Incident_LU_Code]Code_Type = behaviorcode	No	VarChar	40
R10	Weapon Type	If the incident involved a weapon, this element provides the type of weapon involved. If Element R08 – Behavior Code reports a valid value of 8 – Possession of a Weapon, this element is required. If the State Weapon Type is (Handgun, Rifle or Shotgun, Multiple Firearms) AND (Knife or Dagger, Other Weapon), the code FO (Firearm and Other Weapon) is output.	[Incident_LU_Sub_Code]Code_type=objectcode [Incident_LU_Code]State_Aggregate_Rpt_Code	Con	VarChar	2
R11	Exclusionary Action Applied	This element indicates the intervention applied for the behavior reported in Element R08 – Behavior Code. This field only reports as NA if an incident involves reportable behavior but no exclusionary action 1as taken. When Action Code = XS (Suspension), then: When Action Duration is greater than 10 days, LS is reported. When Action Duration is 10 days or less, SS is reported.	[Incident_LU_Code] State_Aggregate_Rpt_Code [Incident_LU_Subcode]Code_Type=actioncode	Yes	VarChar	2
R12	Exclusionary Action Date	The date the action against the student began.	[Incident_Action]Action_Plan_Begin_Dt	Yes	Date	10
R13	Duration of Exclusionary Action Days	The total number of consecutive school days a student is excluded from their regular education setting as a result of the corrective or disciplinary action(s). If more than one exclusionary action is applied to this student for this incident, each exclusionary action is reported as an individual record. The reported value will be the least value of the calculated duration. If the list value of duration is blank, then 180 days are reported.	[Incident_Action]Duration_Assigned	Con	Integer	4, 1
R14	Total Amount of Exclusionary Time	The total amount of time the student was excluded from a regular educational setting due to the exclusionary action. This value can be considered 'missed seat time' and is different than the duration of the action collected in Element R13 – Duration of Exclusionary Action Days. Students excluded from a regular educational setting for less than a full school day are reported with an FTE value of less than 1.0, rounded to the nearest 0.1.	[Incident_Action]Duration_Actual	Con	Numeric	4, 1
R15	Interim Alternative Education Setting	Indicates if students, identified as receiving special education services, are receiving educational services in an Interim Alternative Education Setting (IAES) due to disciplinary action. IA Action Code Dates must be within the action dates of another action (EX, IS, LS, etc.) If Element R11, Exclusionary Action Applied, reports a valid value other than No Intervention Applied (NA) and the student is reported as receiving special education services in Student Special Education Programs File (K), then this element is required. If more than one exclusionary action is applied to this student for this incident, each exclusionary action is reported as an individual record.	[Incident_LU_Code] State_Aggregate_Rpt_Code=IA [Incident_LU_Subcode]Code_Type=actioncode	Con	VarChar	1
R16	Academic Services	This element reports if academic services, as defined by district policy, were offered and the student participated during the exclusionary action. Valid values: 1 – Academic Services were not offered 2 – Student offered Academic Services and participated 3 – Student offered Academic Services and did not participate If the selected action code is Expulsion or Suspension, then Academic Services is required.	[S_WA_IAC_X]Academic_Services	Con	Char	1
R17	Behavior Services	This element reports if behavior services, as defined by district policy, were offered and the student participated during the exclusionary action. Valid values: 1 – Behavior Services were not offered 2 – Student offered Behavior Services and participated 3 – Student offered Behavior Services and did not participate If the selected action code is Expulsion or Suspension, then Behavior Services is required.	[S_WA_IAC_X]Behavior_Services	Con	VarChar	1
R18	Date Petition for Readmission Submitted	The date that a Petition for Readmission was submitted by or on behalf of the student expelled or suspended.	[S_WA_IAC_X]Pet_Read_Submit_Date	No	Date	10
R19	Date Petition for Readmission Granted	The date that a Petition for Readmission was granted or approved for the expelled or suspended student.	[S_WA_IAC_X]Pet_Read_Grant_Date	No	Date	10
R20	Petition For Extension of an Expulsion	This element indicates if a petition to exceed more than one calendar year for a suspension or expulsion was made. Valid values: 0 – No petition made 1 – Petition to exceed the length of an academic term. Petition denied. 2 – Petition to exceed the length of an academic term. Petition granted.	[S_WA_IAC_X]Pet_Exceed_Year	Con	Integer	1
R21	Reengagement Plan	This element indicates if the district developed a re-engagement plan for the student’s return from a suspension or expulsion. Valid values: 0 – No Reengagement Plan 1 – Reengagement Plan With Academic Services 2 – Reengagement Plan With Behavior Services 3 – Reengagement Plan With Both Academic and Behavior Services 4 – Reengagement Plan Not Yet Developed	[S_WA_IAC_X]ReEngage_Plan	Con	VarChar	1
R22	Date Reengagement Meeting Held	The date that a reengagement meeting was held with the student returning from a suspension or expulsion.	[S_WA_IAC_X]ReEngage_Meeting_Date	No	Date	10
R23	Appeal Code	This element indicates if a suspension or expulsion was appealed. Valid values: 0 – No appeal made 1 – Appeal made and granted 2 – Appeal made and denied, not appealed to the school board 3 – Appeal made and denied, appealed to the school board, denied by school board 4 – Appeal made and denied, appealed to the school board and granted by school board	[S_WA_IAC_X]Appeal_Code	Con	Integer	1

[data-colorid=sxszpdvcys]{color:#444444} html[data-color-mode=dark] [data-colorid=sxszpdvcys]{color:#bbbbbb}Introduction

Selection Criteria

Student Selection

Report Input

Report Output

Introduction