Discipline Action File | PowerSchool SIS Compliance

Prelude

This new Student Discipline Snapshot will capture the data of students disciplined that LEAs would create and approve. This process replaces the following existing School Discipline data files:

Discipline by Action
Discipline by Student Demographic
Firearm (GFSA) Discipline Report

Introduction

The Discipline Action File summarizes state-reportable district discipline incidents. It captures details on students disciplined, the type of behavior, and the resulting disciplinary action taken for each disciplinary incident. This data can also be utilized to pre-populate data in the Civil Rights Data Collection file.

Each record represents a single disciplinary incident resulting in an action taken during the reporting school year. For students reported in special education, the IEP must be active at the time of the discipline start date. Students with multiple actions throughout the school year should have multiple records on the file.

Selection Criteria

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

Incident Management Record Selection

The report selects records from Incident Management based on the following criteria:

The student (Offender) is not flagged as Exclude from State Reporting.
The school is not flagged as Exclude from State Reporting.
The Incident Date falls between the user-selected start and end dates.
The Incident is associated with a school.
The Incident Behavior or Action, and Incident codes are State Reportable^.
The Incident has at least one Offender.
The Behavior is assigned to the Offender(s).
The Action is associated with the Behavior.

Record Selection Logic

Incidents are extracted when:

The Behavior is one of the state-reportable behavior codes (in the Student Incidents behavior code option set) but the action is not state-reportable.
The Incident resulted in a state-reportable classroom removal, suspension, expulsion or referral to law enforcement (in the Student Incidents action code option set), but the behavior is not state-reportable.
The Incident Type is State Reportable.
The report output will auto-generate a Bullying^ record corresponding to behavior code 11 when the behavior in the incident corresponds to behavior codes 41, 42, or 43. The action code for the record will correspond to the actual action taken.

If multiple behaviors occur in the same incident, the report will include only one record which corresponds to the behavior marked as primary. If no behavior is marked as primary, the record will correspond to the first behavior in the incident, treating it as primary. Therefore, it is essential to mark one behavior (the most severe) as primary to ensure the report meets CDE requirements.

Report Input

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

Field	Description
Schools to Include	Use Ctrl+Click to select multiple schools or Shift+Click to select a range of schools or All Schools. School selection will only be available when at District Office.
Select Start Date*	Enter the starting date of the date range for the report.
Select End Date*	Enter the ending date of the date range for the report.

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	Field Length
1	Admin Unit/BOCES Code	A valid AU Code. The field value is fetched from [New UI] Start Page, District Management, District Setup, District Info, Admin Unit/SOP code (from the Colorado State Specific Information) Field in the report must be zero-filled to 5 digits if value is not available in Admin Unit/SOP code. If zero-filled, will automatically populate in the snapshot based on the district code.		5
2	District Code	The district number. Must be a valid district code within the reporting Administrative Unit.	[Prefs]Value where [Prefs]Name=districtnumber	4
2	School Code	The reporting school number.	[Schools]Alternate_School_Number If not available, then [Incident]School_Number	4
3	Special Education Program Code	A unique code assigned to an AU run Special Education Program by CDE. Zero filled if not applicable.	A custom State Reporting SQL View obtains data from [S_CO_STU_X]SPED_ProgramCode	4
4	Incident Identifier	A locally assigned ten-digit number for each incident. An Incident Identifier may be duplicated in cases where a student incurs more than one discipline action associated with the incident or more than one student is involved in the incident.	A custom State Reporting SQL View obtains data from [Incident_Detail]Incident_Id	10
5	Date of Incident	Date of the incident. Format: MMDDYYYY	A custom State Reporting SQL View obtains data from [Incident]Incident_TS	8
6	Behavior Type	The behavior type associated with the incident. Valid values: Refer to Behavior Codes in Incident Management State-Specific Codes The following subcodes under Bullying/Harassment^ are treated similar to Reason Unknown^ Based on Creed^ Based on Family^ Based on Ancestry^ Based on Age^ The following subcodes under Bullying/Harassment are treated similar to Based on Sex^ Based on Gender Expression^ Based on Gender Identity^	A custom State Reporting SQL View obtains data from [Incident_Lu_Sub_Code]State_Detail_Report_Code. The corresponding valid value is assigned based on programmed logic.	2
7	Weapon Type	The weapon used by the student in the incident. Valid values: 00 - No Weapon^ 01 - Handgun^ 02 - Rifle/Shotgun^ 03 - Other Firearms^ 04 - Multiple Firearms^ 05 - Other Weapon^ Note: If the object code Weapons^ is not added to an incident, then also 00 is reported for this field in the output.	A custom State Reporting SQL View obtains data from [Incident_Lu_Code]Lu_Code_id. The corresponding valid value is assigned based on programmed logic.	2
8	Student State ID (SASID)	A unique ten-digit number assigned to each student by CDE.	A custom State Reporting SQL View obtains data from [Students]State_StudentNumber	10
9	Student First Name	First name of the student. Note: The legal first name is extracted if available, else the first name is extracted from the Students table.	A custom State Reporting SQL View obtains data from [Students]First_Name	30
10	Student Last Name	Last name of the student. Note: The legal last name is extracted if available, else the last name is extracted from the Students table.	A custom State Reporting SQL View obtains data from [Students]Last_Name	30
11	Student Gender	Indicates the gender for action(s) reported. Valid values: 01 - Female (F) 02 - Male (M) 03 - Non-binary (X) If gender is blank or has a value other than the above values, the report will have 00 as the value for gender.	A custom State Reporting SQL View obtains data from [Students]Gender	2
12	Student Date of Birth	Date of birth of the student. Format: MMDDYYYY.	A custom State Reporting SQL View obtains the value from [Students]DOB	8
13	Special Education Action Flag	Indicates if the student is a Special Education student at the time of the incident. The value is reported based on the Special Education History table on the Student’s Special Ed page. Valid values: 1 0 Note: The incident date must fall within the special education entry and exit dates.	A custom State Reporting SQL View obtains the value from Student’s Special Education History table.	1
14	Discipline Action 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.	A custom State Reporting SQL View obtains the action code from [Incident_Lu_Sub_Code]State_Detail_Report_Code	10
15	Discipline Action Type	Indicates the action taken on the student due to the incident. Must be zero-filled if the student was unilaterally removed. Valid Values: 00 - Unilateral Removal^ 10 - Classroom Suspension/Teacher Removal^ 11 - In School Suspension^ 12 - Out of School Suspension^ 13 - Expulsion^ 14 - Others this field is reported as 00. In addition to Expulsion^, Discipline Action Type will have the value 13 for the following subcategories: Expelled Less than the Mandatory One Calendar Yr^, Expelled for the Mandatory One Calendar Year^, Expelled less One Year Referred Alt. School Prog^, Expelled One Yr Who Referred to Alt. School Prog^ Discipline Action Type will have the value 00, for the following conditions: When the action has Referral to Law Enforcement, Handcuffed, Seclusion, or Restraint (physical or mechanical), irrespective of the action taken. When a Special Education student was unilaterally removed and the special education removal type is 01 - Unilaterally Removed by School Personnel OR 02 - Unilaterally Removed Based on a Hearing Officer. When reporting CRDC behaviors. When the behavior type is Bullying/Harassment^. However, when the behavior type is Bullying/Harassment^ and the subcode selected is Reason Unknown^ (11), then the code of the actual action associated with the behavior is reported. For example, if Out of School Suspension^ (12) is the associated action, then the code 12 will be reported. When the action code N/A^ (00) is added to an incident.	A custom State Reporting SQL View obtains action code from [Incident_Lu_Sub_Code]State_Detail_Report_Code. The corresponding valid value is assigned based on programmed logic.	2
16	Referral to Law Enforcement	Indicates if the student was referred to law enforcement due to the incident. Valid values: 1 - Yes 0 - No	A custom State Reporting SQL View obtains action code from [Incident_Lu_Sub_Code]State_Detail_Report_Code. The value is set based on the whether the action code corresponds to ‘Referred to Law Enforcement^’ action code sub-category or not.	1
17	Handcuffed Status	Indicates if the student was handcuffed. Valid values: 1 - Yes 0 - No	A custom State Reporting SQL View obtains the value from [PSRW_IncidentActionAttribute]Sub_Category when [PSRW_IncidentActionAttribute]Incident_Category = 'Handcuffed^’	1
18	School-Related Arrest Status	Indicates if the student was arrested for any activity conducted on school grounds, during off-campus school activities, or due to a referral by any school official. Valid values: 1- Yes 0 - No	A custom State Reporting SQL View obtains action code from [Incident_Lu_Sub_Code]State_Detail_Report_Code. The value is set based on the whether the action code corresponds to ‘School Related Arrest^’ action code sub-category or not.	1
19	Received Education Services During Expulsion	Indicates if the student received education services during expulsion. Only required on expulsion records. Valid values: 0 - No 1 - Yes This reporting field will have the value 1 (Yes) for the following action codes: 03 - Removal by School Personnel - Weapons^, 03 - Expulsion - Received Educational Services^, 04 - Expulsion - Did not Receive Educational Services^, 330 - Expulsion^, 510 - Retired - Student Expulsions^	A custom State Reporting SQL View obtains action code from [Incident_Lu_Sub_Code]State_Detail_Report_Code. The corresponding value is assigned based on programmed logic.	1
20	Transferred to Alternative School (for Disciplinary Reasons)	Indicates if the student was transferred to alternative school for disciplinary reasons. (Optional for CRDC reporting purpose only) Valid values: 1 - Yes 0 - No	A custom State Reporting SQL View obtains sub category from [PSRW_IncidentActionAttribute]Sub_Category where [PSRW_IncidentActionAttribute]Incident_Category = 'Transferred to Alt School (for disc reasons)^’	1
21	Discipline Action Length	The number of school days missed because of the discipline. An Action that spans two school years should be reported in both collection years and reflect the number of school days missed within each year. Note: This information is pulled for both SPED and non-SPED students. This field can have values ranging from 0005 for half day to 2600 for 260 days.	A custom State Reporting SQL View obtains action duration from [PSRW_IncidentAction]Duration_Actual	4
22	Discipline Start Date	Start date of the discipline or removal. Format: MMDDYYYY For special education students, the Date of Entry to Special Education reported in the Participation File must precede the Discipline Start Date. An Action that spans two school years should contain a start date of the days missed from school within that reporting year.	A custom State Reporting SQL View obtains action start date from [PSWR_ParticipantBehavorAction]Action_Plan_Begin_Dt UI Navigation: Select student > Compliance > Special Ed > Special Education (IEP) is checked	8
23	Special Education Removal Type	Indicates if student was unilaterally removed by school personnel or hearing officer. Valid Action Codes: Student Actions^ Unilateral Removal^ (State Detail Report Code=370) Valid Action Attributes: Type of Removal^ 01 - Removal by School Personnel^ 02 - Removal based on Hearing Officer^ Required for Special Education Students only.	A custom State Reporting SQL View obtains data from [PSRW_IncidentActionAttribute]Sub_Category where [PSRW_IncidentActionAttribute]Incident_Category = ‘Type of Removal^’ Will not have zero-filled value only for SPED students i.e. [s_co_stu_x]specialeducation = 1 for current enrollment OR [s_co_ren_x]specialeducation = 1 for previous enrollments UI Navigation: Select student > Compliance > Special Ed > Special Education (IEP) is checked	2
24	Special Education Removal Reason	Reason for unilateral removal of student by school personnel. Valid Action Codes: Student Actions^ Unilateral Removal^ (State Detail Report Code=370) Valid Action Attributes: Removal Reason^ 01 - Removal by School Personnel - Drugs^ 02 - Removal by School Personnel - Injury^ 03 - Removal by School Personnel - Weapons^ Required for Special Education Students only.	A custom State Reporting SQL View obtains data from [PSRW_IncidentActionAttribute]Sub_Category where [PSRW_IncidentActionAttribute]Incident_Category = ‘Removal Reason^’ Will not have a zero-filled value only for SPED students i.e. [s_co_stu_x]specialeducation = 1 for current enrollment OR [s_co_ren_x]specialeducation = 1 for previous enrollments UI Navigation: Select student > Compliance > Special Ed > Special Education (IEP) is checked	2
25	Off Campus Behavior Flag	The value is pulled from the Off Campus Behavior Flag field available on the Incident detail page. Valid values: 0 1 If the source field is bank, zero is reported.		1

When the behavior code is 00, then the following fields are reported as 0s if one or more records are marked as Yes for physical restraint, mechanical restraint, or seclusion:

Behavior Type (00): Behavior code N/A^ (00) should be added to the incident.
Weapon Type (00): No weapon type should be added to the incident.
Discipline Action Identifier (0000000000): The report will default this to 0s when behavior type is N/A^ (00) and action type is also N/A^ (00).
Discipline Action Type (00): Action type N/A^ (00) should be added to the incident.
Referral to Law Enforcement (0 for No): Referral to law enforcement should not be added to to the incident.
Handcuffed Status (0 for No): Handcuffed should not be Yes.
School Related Arrest (0 for No): School Related Arrest should not be added to the incident.
Mechanically Restrained (for CRDC reporting purposes only) (0 for No): Mechanically Restrained should not be Yes if Physical Restraint or Seclusion as Yes.
Received Education Services During Expulsion (0 for No): Should not be added to the incident.
Transferred to Alternative School (0 for No): Should not be marked as Yes in the incident.
Discipline Action Length (0000): The report will default this to 0s when behavior type is N/A^ (00) and action type is also N/A^ (00).
Discipline Start Date (00000000): The report will default this to 0s when behavior type is N/A^ (00) and action type is also N/A^ (00).
Special Education Removal Type (00 N/A): Should not be added to the incident.
Special Education Removal Reason (00 N/A): Should not be added to the incident.

Note: If only one record is marked as Yes for physical restraint, mechanical restraint, or seclusion, then only that particular field is extracted as 1 and all the above-mentioned fields are extracted as 0s if Behavior Type = 00 and Action Type = 00.