Classic View: IN State Reporting > ES

Search Term: ES

The purpose of this data collection is to gather student suspension, expulsion, and arrest information as a form of disciplinary action. Bullying, gang related, and firearm data are also collected.

Expulsion & Suspension Report Editor

Data Submission

The Expulsion & Suspension Report collection period begins in early July and ends in early September.

Report Logic

Incidents only report if the incident status is Completed.

Students report when they are participants in a behavior incident with the behavior event date captured within the reporting period for one of the following scenarios:

Criminal Gang Related checkbox is marked on the Event Details.

A Bullying event where the Event Type is mapped to one of the following State Event Codes.

Code	Name
30	Physical Bullying
31	Verbal Bullying
32	Social/ Relational Bullying
33	Written Communication/ Electronic Bullying
34	Combination (more than one type of Bullying)

The Arrest field is 1 or 2 on the Event Details.
A student will only report one record if they have a suspension and expulsion for a single incident. The only exception is for a student with multiple State Mapped Behavior Resolutions tied to the same Behavior Incident where the first Resolution is Code 1 and the second resolution is Code 2.
If there there are multiple suspension resolutions, the incident reports once for each resolution but uses the same incident number.
A Behavior Event appears in this report if the Resolution code is 1 (In-School Suspension), 2 (Out-of-School Suspension) or 3 (Expulsion).
If the resolution is 4 (Alternative to Expulsion), the behavior event is not included in this report.
When an event date falls after a student's enrollment end date, the event will report if the event date is on or within the report's date range.
If there are multiple resolutions, the incident reports once for each resolution but uses the same incident number.
Days which fall outside of the school year being reported are not included in the resolution length.
School level events and resolutions must be mapped to a state code in order to be reported. (Behavior > Admin > Event Types; Resolution Types > State Event/Resolution Code)
Students report as Special Education students if they are identified as Special Education at any time during their suspension or expulsion.
Students do not report if any of the following conditions exist:
- The student's enrollment State Exclude field is checked.
- Students enrolled in the grade level where the Grade Level's Exclude from state reporting field is checked.
- Any students enrolled in a school where the Calendar's Exclude field is checked.

Report Editor Field Descriptions

Editor Field	Description
Start Date	The earliest date from which data is pulled for the report.
End Date	The latest date from which data is pulled for the report.
Ad Hoc Filter	Select an Ad hoc Filter to limit the information reported to students within the selected filter.
Format	The format in which the report will generate. Options include HTML, Comma Separated and XML. HTML and XML formats are used for data review and verification, while the CSV State Format should be used when submitting reports to the state.
Calendars	The calendar(s) from which data is pulled for the report. Can be set to display only the active year's calendars, or be sorted by school or by year.

Generating the Report

Enter a Start Date in mmddyyyy format or by clicking the calendar icon.
Enter an End Date in mmddyyyy format or by clicking the calendar icon.
Select the Format in which the report should be generated.
Select the Calendar(s) to be included in the report. Calendars can be sorted by active year, by school or by year.
Select an Ad hoc Filter to limit the information reported to students within the selected filter.
Click the Generate button.
Result:
The report displays in a separate window in the designated format.

Users have the option of submitting the report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process allows larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.

Report Examples

Expulsion & Suspension Report - State Format

Expulsion & Suspension Report - HTML

Expulsion & Suspension Report - Comma Separated

Expulsion & Suspension Report - XML

Expulsion & Suspension Report Layout

Element Name	Description	Type, Format and Length	Campus Database	Campus Application
School Number	State Assigned school ID.	Numeric, 4 digits	School.number	System Administration > Resources > School > State School Number
Student Test Number	Official student test number (State ID).	Numeric, 9 digits	Person.stateID	Census > People > Demographics > Person Identifiers > State ID
Last Name	The student's last name. HTML Format Only	Alphanumeric, 40 characters	Identity.lastName	Census > People > Demographics > Person Information > Last Name
First Name	The student's first name. HTML Format Only	Alphanumeric, 35 characters	Identity.firstName	Census > People > Demographics > Person Information > First Name
Grade Level	Student's grade level. If there are multiple enrollments in the year and they don’t overlap, reports the grade level set on the last enrollment If there are multiple enrollments that have overlapping dates, reports the grade level set on the Primary enrollment If there are multiple Primary enrollments that have overlapping dates, reports the grade level set on the enrollment with the highest enrollmentID	Alphanumeric, 2 characters	Enrollment.gradeLevel	Student Information > General > Enrollments > Grade
Incident Number	The Event ID.	Numeric, 9 digits	BehaviorEvent.eventID	Behavior > Behavior Management > Incident > Event > EventID
Type of Suspension, Expulsion or Event	Code indicating type of behavior event resolution. See options in the Behavior Resolution Options table following. If there is one or more suspension resolution for a student for a single event each suspension code reports with the corresponding dates as separate records. If there is one or more suspension resolutions AND an expulsion for a student for a single event, 3 (Expulsion) reports. If there is no qualifying State Resolution code for the student, 4 reports.	Numeric, 1 digit	BehaviorResType.code BehaviorResType.name	Student Information > General > Behavior > Behavior Resolution
Beginning Expulsion or Suspension Date	First day of expulsion. If the Type of Suspension, Expulsion or Event is 4, the Incident Date reports. Otherwise, the Start date of the behavior resolution reports. If there is one or more suspension resolution for a student for a single event, the start date for each suspension reports as separate records with the other data corresponding to that record. If there is one or more suspension resolutions AND an expulsion for a student for a single event, the earliest start date from the resolutions reports.	Date field, 8 digits MMDDYYYY	BehaviorResolution. discAssignDate BehaviorResolution.stateResCode	Student Information > General > Behavior > Resolution > Resolution Date
Ending Expulsion or Suspension Date	Last day of expulsion. If the Type of Suspension, Expulsion or Event is is 4, the Incident Date reports. Otherwise, the End Date of the behavior resolution reports. If there is one or more suspension resolutions for a student for a single even the end date for each suspension reports as separate records with the other data corresponding to that record. If there is one or more suspension resolutions AND an expulsion for a student for a single event, the end date from the expulsion resolution reports. If the Resolution End Date falls outside of the school year in which the Incident/Event falls, the calendar end date for the latest student enrollment in the selected calendar reports. For example, if a school year and summer school are selected, the student is enrolled in both, and the resolution end date is after the end date of both calendars, the latest end date of the calendar reports.	Date field, 8 digits MMDDYYYY	BehaviorResolution. endDate	Student Information > General > Behavior > Resolution > End Date
Length of Expulsion or Suspension	The total number of instructional days that the student was expelled, OR the total number of instructional days between the beginning date and ending date. When the Duration in School Days field is a decimal value OR the calculated value is a decimal, then the reported value is rounded up. For example if the value was 7.25 then this field reports 8. The "Duration in School Days" on the Behavior editor is considered first. When that field is NULL, the report looks at the calendar and instructional days in which the incident occurs and calculates the value in this field as the Resolution Start Date through the Resolution End Date. Instructional days that fall outside the school year in which the event occurs are not included. If the Type of Suspension, Expulsion or Event is 4 (Alternative to Exp.), 000 reports.	Numeric, 3 digits NNN	Not dynamically stored	Not dynamically stored
Reason for Event	The Behavior Event that led to the resolution of expulsion or suspension. If no State Mapped Event code is used, 10 (Other) reports. See options in the following Behavior Event Options table.	Numeric, 2 digits	Behavior.name	Student Information > General > Behavior > Behavior Event
Services Provided During Removal	Indicates if services were provided to the student during the term of removal. See options in the Services Provided During Removal Options table following. This field reports blank when the field is Null or when the Type of Suspension, Expulsion or Event is 4 (Alternative to Exp.)	Numeric, 1 digit	BehaviorResolution. servicesProvided	Student Information > General > Behavior > Resolution > Services Provided During Removal
Special Education Participant	Indicates if the student has an active IEP. Reports Y if a student had an active, locked IEP at any time during the Suspension or Expulsion period.	Alphabetic, 1 character Y or N	Plan.status	Student Information > Special Ed > Documents > IEP > Enrollment Editor > Special Ed Status
Interim Alternative Educational Setting	Indicates that the special ed student was referred to an interim alternative educational setting prior to suspension or expulsion. If the student is not a Special Ed student, the field reports N. If the student is a Special Ed student AND they have been assigned interim alternative education on the Behavior > Behavior Management > Resolution Editor, this field reports Y. If the Special Ed student is NOT assigned interim alternative education, this field reports N.	Alphabetic, 1 character Y or N	BehaviorResolution. interimAltEduSetting	Student Information > General > Behavior > Resolution > Interim Alternative Educational Setting
Criminal Gang Related Event	Indicates whether the student was involved in a Criminal Gang Related Event. If Criminal Gang Related checkbox is NOT marked, 0 reports. If Criminal Gang Related checkbox IS marked and the Referred to Local Law Enforcement checkbox is NOT marked, 1 reports. IS marked, 2 reports.	Numeric, 1 digit	BehaviorEvent. gangRelated BehaviorEvent. policeNotified	Behavior > Behavior Management > Incident > Event > Event Details > Criminal Gang Related Behavior > Behavior Management > Incident > Event > Event Details > Referred to Local Law Enforcement
Arrest	Indicates whether the student was arrested on school property or off school property. Arrests only report for students who also have an Arrest Reason Code. 0 - No Arrests made 1 - Arrests occurred ON School Property 2 - Arrests occurred OFF School Property	Numeric, 1 digit	BehaviorEvent. policeReport	Behavior > Behavior Management > Incident > Event > Event Details > Arrest
Arrest Reason Codes	Indicates the School Related Arrest Reason Code. If the Arrest on the Behavior Event Details is 0: No Arrests made, 000 reports. Otherwise, all Resolutions to the Event Participants are considered. If there is no resolution for the student or if the Arrest Reason is blank, 000 reports. In all other scenarios, the value from the Arrest Reason reports.	Numeric, 3 digits	BehaviorEvent. policeReport BehaviorResolution. lawEnforcement	Behavior > Behavior Management > Incident > Event > Event Details > Arrest Behavior > Behavior Management > Incident > Event > Resolution Details

Behavior Resolution Options

Code	Description
1	In-School Suspension
2	Out-of-School Suspension
3	Expulsion
4	Alternative to Exp.

Behavior Event Options

Code	Description
01	Alcohol
02	Drugs
03	Deadly Weapons (other than firearms)
04	Handguns
05	Rifles or Shotguns (not BB or Carbon Dioxide gun)
06	Other Firearms
07	Tobacco
09	Legal Settlement - I.C. 20-33-8-17
10	Other
11	Fighting - incident does not rise to Battery
12	Battery
13	Intimidation
14	Verbal aggression or profanity
15	Defiance
16	Attendance
17	Destruction of Property
18	Theft
19	Sexual Misconduct
20	Technology Misuse
21	Non-Deadly Weapons
30	Physical Bullying
31	Verbal Bullying
32	Social/Relational Bullying
33	Written Communication/Electronic Bullying
34	Combination (more than one type of Bullying)

Services Provided During Removal Options

Code	Description
1	Ref., didn't rec services for the entire removal
2	Referred but refused services
3	No services provided
4	Referred and received services

ES (Expulsion and Suspension) (Indiana)