Suspension, Expulsion, and Remands Report by School and District - Section 2

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.

Log types and log entry fields must be set up at the district level via Start Page > District Setup > Log Entry Fields/Log Types. Log entries must be defined for students using the rules listed in the selection criteria and report output below via Start Page > Student > Log Entries. See State Reporting Setup for additional setup information. The districts have the option to select logs or IM for the first year.

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] or [Incidents] 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.
The student must have incident records with action code S, E, or R on Start Page > Student Selection > Incident List page.
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	Student ID	The student identification number.	[Student]ID
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 or Incident records 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).	[School]Number — PSRW_INCIDENTPARTICIPANT.schoolid [Student]ID — Students.id [Student]fed]ethnicity — Students.fedethnicity; 0 for Non Hispanic or 1 for Hispanic [Student]ethnicity — Students.ethnicity; H,W,A,P,I,B [Student]Number — PSRW_INCIDENTPARTICIPANT.Participant_Number [Student]gradeLevel — PSRW_INCIDENTPARTICIPANT.Grade_level [Student]gender — PSRW_INCIDENTPARTICIPANT.Gender [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)

Back to Top