Suspension, Expulsion, and Remands Report by School and District

Introduction

This report includes totals for students who received suspension, expulsion or remands as the result of a discipline incident. The report also returns totals for student incidents based on cause, such as drugs, handgun, alcohol, or theft. Students and incidents are grouped by gender and ethnicity.

You need to set up the Reporting Discipline mode to capture data from either the Log types/log entry fields or the Incident management fields. Set up the Reporting Discipline mode in Start Page > District Setup > District Info > Reporting Discipline. Depending on the discipline mode selected this report will publish data.

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.

Student Selection

The report selects records from the [Students] and [Log] tables based on the following criteria:

The student must be enrolled in a school included in the report during the report date range.
The student must note be excluded from state reporting.
The student must be assigned a valid ethnicity (W, B, H, A, I, P).
The student must be assigned a valid gender (M or F).
The student must have a log entry record with a Discipline Action Taken of S, I, E, or R.
If the student has a log entry with a Discipline Action Taken of R, then they must have a Discipline Action Taken Detail of R for the same log entry.
Special education students must be enrolled in a special program with the name Option 07, Option 08, or Option 09.

Note: The name of the special program must be exactly Option 07, Option 08, or Option 09. The report will not recognize Option 7, Option7, or other variations.

Report Input

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

Field	Description
Use	If run at the district level, choose one of the following from the pop-up menu: Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria. Select Schools – Select Multiple Schools or All Schools. This Includes all records associated with the school that meet the selection criteria. Students to Include – The selected one student or all the students. District Wide – Includes all records on the PowerSchool server that meet the selection criteria. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Start Date	Enter the first day of the reporting period to display in the header. Please note that the report runs cumulative, year to date. The start date value entered is for display purposes only.
End Date	Enter the last day of the reporting period.
Report Type	Choose the appropriate report type from the pop-up menu: Suspension Expulsions Remands

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
1	School Year	The current school year selected at report runtime. The report extracts the year associated with the first and last days in the school calendar.	[Terms]FirstDay [Terms]LastDay
2	District Number	The district number.	[Prefs]Value [Prefs]Name=districtnumber
3	District Name	The district name.	[Prefs]Value [Prefs]Name=districtname
4	School Number	The school number. This field is blank if the report is run for the district.	[Schools]School_Number
5	School Name	The name of the school. This field is blank if the report is run for the district.	[Schools]Name
6	Section 1: Incidents by Grade	The number of discipline incidents that resulted in suspension, expulsion or remands. The incidents are grouped by gender, grade level, and ethnicity. Students must meet the selection criteria and have a grade level of 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, or 12. Special education students must also have a Discipline Incident Type Category (offense code) of 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, or 38. See the Appendix for valid offense code values (incident type category). The Section 1 report output is in .HTML format.	[Students]State_ExcludeFromReporting=False [Students]Gender=M or F [Studentrace]racecd=W, B, H, A, I, P or M (multiple combination) [Students]Grade_Level=0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, or 12 Discipline Logs [Log]Discipline_ActionTaken=S, E, or R [Log]Discipline_ActionTakenDetail=R [Log]Discipline_IncidentTypeCategory=17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, or 38 OR Incidents [incident]Date — psrw_incident.incident_ts [incident]Id — psrw_incident.incident_id [incident]Behavior — PSRW_INCIDENTBEHAVIOR.State_detail_report_code =17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, or 38 [incident]actionCode — PSRW_INCIDENTACTION.State_detail_report_code (S,E,R)
7	Section 2: Incidents by Cause	The number of discipline incidents for a particular offense. The incidents are grouped by gender, grade level, and cause. The cause is identified using an offense code for drugs, handgun, alcohol, theft, etc. Students must meet the selection criteria and have a log entry with a Discipline Incident Type Category of 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, or 38. See the Appendix for valid offense code values (incident type category). The number of discipline incidents that resulted in suspension, expulsion or remands. The incidents are grouped by gender, grade level, and ethnicity. Students must meet the selection criteria and have a grade level of 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, or 12. Special education students must also have a Discipline Incident Type Category (offense code) of 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, or 38. See the Appendix for valid offense code values (incident type category). The Section 2 report output is in .pdf format.	Discipline Logs [Log]Discipline_ActionTaken=S, E, or R [Log]Discipline_ActionTakenDetail=R [Log]Discipline_IncidentTypeCategory=17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, or 38 OR Incidents [incident]Date — psrw_incident.incident_ts [incident]Id — psrw_incident.incident_id [incident]Behavior — PSRW_INCIDENTBEHAVIOR.State_detail_report_code =17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, or 38 [incident]actionCode — PSRW_INCIDENTACTION.State_detail_report_code (S,E,R)
8	Section 3: Number of Students Suspended by Race and Sex -And- Number of Students Remanded by Race and Sex	The number of students with 1 or discipline incidents that resulted in suspension or remands. The students are grouped by gender, ethnicity, and incident count. If a student has 1 incident that resulted in suspension or remands, then a value of 1 is added to the “1 Time Only” row. If a student has 2 incidents that resulted in suspension or remands, then a value of 1 is added to the “2 Times Only” field, and so on. Students must meet the selection criteria and have a log entry with a Discipline Incident Type Category of 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, or 38. See the Appendix for valid offense code values (incident type category). Note: The log entry must have a log type of Discipline to be included in this section of the report.	[Students]State_ExcludeFromReporting=False [Students]Gender=M or F [Studentrace]racecd=W, B, H, A, I, P or M (multiple combination) [Log]Discipline_ActionTaken=S, R [Log]Discipline_ActionTakenDetail=R [Log]Discipline_IncidentTypeCategory=17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, or 38 [Log]LogTypeID [Gen]ID [Gen]Name=Discipline

Back to Top