Skip to main content
Skip table of contents

New 2023 School Year Report (new) - Old - Do not refer

Introduction

The purpose of the Discipline Action File is to capture the students' who were disciplined, including 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.

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, 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.

Back to Top

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
3Special Education Program Code *

4
4Incident Identifier *

10
5Date of Incident  *

8
6Behavior Type *

2
7Weapon Type *

2
8Student’s State ID (SASID) *

10
9Student’s First Name *

30
10Student’s Last Name *

30
11Student’s Gender *

2
12Student’s Date of Birth *

8
13Special Education Action Flag *

1
14Discipline Action Identifier *

10
15Discipline Action Type *

2
16Referral to Law Enforcement *

1
17Handcuffed Status

1
18School-Related Arrest Status *

1
19Physically Restrained *

1
20Mechanically Restrained

1
21Placed in Seclusion *

1
22Received Education Services During Expulsion *

1
23Transferred to Alternative School (for Disciplinary Reasons)

1
24Discipline Action Length *

4
25Discipline Start Date *

8
26Special Education Removal Type

2
27Special Education Removal Reason

2

























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:

  • 01-Drug Violation (not marijuana)
  • 02-Alcohol Violation
  • 03-Tobacco Violation
  • 04-1st, 2nd or 3rd Degree or Vehicular Assault
  • 05-Dangerous Weapons
  • 06-Robbery
  • 07-Other Felony
  • 08-Disobedience/Defiant or Repeated Interference
  • 09-Detrimental Behavior
  • 10-Destruction of School Property
  • 11-Bullying
  • 12-Other Violation of Code of Conduct
  • 13-3rd Degree Assault/Disorderly Conduct
  • 14-Marijuana Violation
  • 15-Sexual Violence/Battery (other than Rape)
  • 16-Rape or attempted Rape
  • 17 - Threat of Physical Attack
  • 18 - Allegations of harassment on the basis of sex
  • 19 - Allegations of harassment on the basis of race, color, national origin
  • 20 - Allegations of harassment on the basis of disability
  • 21 - Allegations of harassment on the basis of sexual orientation
  • 22 - Allegations of harassment on the basis of religion

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

4Weapon Description

Indicates whether a weapon was used during the incident. 

Valid Values:

  • 0-No Weapon
  • 1-With Weapon
  • 2-With Firearm or Explosive Device
[Incident_Object]Incident_Object_ID1

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

Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.