Discipline by Action – School Discipline and Attendance
Introduction
The Discipline by Action report summarizes state reportable district discipline incidents grouped by action.
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.
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, 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 15 specified, 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.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
|---|---|
Schools to Include | Select Multiple Schools using 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 | School District/ BOCES Code | The district number. | [Prefs]value [Prefs]name=districtnumber | 4 |
2 | School Code | The reporting school number. | [Incident]School_Number [Schools]Alternate_School_Number [Schools]School_Number | 4 |
3 | Behaviors/Allegations | The behavior or allegation code. Note: To report allegation data, districts must be on PowerSchool 12.0.1 or higher and the Allegation checkbox must be selected for any incidents of Bullying/Harassment that were allegations. Valid Values:
The corresponding action code is also pulled in the report wherever applicable. For example, if the Behavior Code is 11 (Bullying) and the action code is Expulsion, then the report displays 11 for this field and 1 under the Exp column. | A custom State Reporting SQL View obtains data from Students and Incident Management tables. The [Incident_CO_BehaviorAction]Behavior_Code is obtained from the SQL Table below: [Incident_Lu_Sub_Code]Lu_Sub_Code_ID (subcodes: 100037-100048). [Incident_Detail]Allegation_Indicator | 2 |
| 4 | Weapon Description | Indicates whether a weapon was used during the incident. Valid Values:
| [Incident_Object]Incident_Object_ID | 1 |
5 | Total Number of Incidents/Allegations | The total number of incidents (not students) or allegations reported for the specified behavior. For reported behaviors, this is the sum of Classroom Suspension/Teacher Removal, In School Suspension, Out of School Suspension, Expulsion, and Other Action Taken. Only include Referred to Law Enforcement if no other action is being reported for that behavior. For reported allegations, this is the total number of allegations. Note: To report allegation data, customers must be using the Allegations flag that is part of PowerSchool 12.0.1 | Aggregate function derived from the custom view: [Incident_CO_BehaviorAction] [Incident_Detail]Allegation_Indicator | 4 |
6 | Classroom Removal Incidents | The total number of incidents (not students) or allegations in which the most severe action taken was the student(s) being suspended from the classroom or removed by the teacher. | Aggregate function derived from the custom view: [Incident_CO_BehaviorAction] [Incident_Detail]Allegation_Indicator | 4 |
7 | In-School Suspension Incidents | The total number of incidents (not students) in which the most severe action taken was the student(s) being suspended in school. | Aggregate function derived from the custom view: [Incident_CO_BehaviorAction] | 4 |
8 | Out-of-School Suspension Incidents | The total number of incidents (not students) in which the most severe action taken was the student(s) being suspended out of school. | Aggregate function derived from the custom view: [Incident_CO_BehaviorAction] | 4 |
9 | Expulsion Incidents | The total number of incidents (not students) in which the most severe action was the student(s) being expelled. | Aggregate function derived from the custom view: [Incident_CO_BehaviorAction] | 4 |
10 | Law Enforcement Referral Incidents | The total number of incidents (not students) in which the student(s) were referred to law enforcement. If the incident was referred to law enforcement, indicate the most serious action taken (e.g., suspension, expulsion) in addition to the referral to law enforcement. Law enforcement referrals will not be counted in the total incident count unless law enforcement referral is the only column checked. | Aggregate function derived from the custom view: [Incident_CO_BehaviorAction] | 4 |
11 | Other Action Taken Incidents | The total number of incidents (not students) in which the most severe action taken to the student(s) is not included as a data field type. Less serious disciplinary actions such as warnings, Saturday school, sent to the office, detention for three tardies, etc. are not included in the "Other" column. | Aggregate function derived from the custom view: [Incident_CO_BehaviorAction] | 4 |
