Report 7.17 Unilateral Removals for Students with Disabilities – Count

(Updated 04/15/2024)

Description: Reports the number of students with disabilities (by Primary Disability Category) who were removed from their regular instructional setting to an interim alternative setting for disciplinary reasons, regardless of enrollment status. It also reports the counts of removals to interim alternative setting by federal offense category.

Security Role Required: EOY 3 Reports

Data As Of:

  • Snapshot version, any time in the reported academic year (7/1 – 6/30)

Report Period:

  • Report Period (July 1 thru June 30 of the reporting year)

Basic Selection Criteria:

  • Student Enrollment (SENR) and Student Information (SINF) data reported or used for selecting student subgroups (e.g. Enrollment Status and Grade Level) are associated with the most recent qualifying enrollment at the school during the Report Period, regardless of when the incident occurred
  • Student Program (SPRG) data used for student groups are selected from the most recent SPRG record for the school of attendance in the associated SINC record with Education Program Membership Start Date and Education Program Membership End Date (if exists) that overlap with the Incident Occurrence Date.
  • Special Education Status (SWDS) data used for selecting Students with Disabilities are selected from the Eligible and Participating SWDS record [Special Education Status Code = 1 {Eligible and Participating)] effective during 1) the qualifying enrollment in the SINC record and 2) the Incident Occurrence Date

  • Special Education Plan (PLAN) Data used for selecting Disability 1 Code and Disability 2 Code are selected from the Most Recent PLAN record effective during 1) the qualifying enrollment in the SINC record and 2) the Incident Occurrence Date for only students identified as Eligible and Participating in the Special Education Program (see SWDS data)

  • Qualifying Enrollment

  • Enrollment Status Code 10-Primary, 20-Secondary, 30-Short Term

  • Grade Level: TK, KN, 01-12, IN, TD, PS

  • Qualifying Data

  • Student Incident (Record Type = SINC) and Student Offense (Record Type = SOFF) for the Academic Year being reported
  • SINC Field 18.17-Removal to Alternative Setting Reason Code = 1 or 2

Report Filters: Filters can be selected resulting in only totals for the selected filter being displayed

  • Academic Year
  • LEA
  • Status
  • SELPA Code
  • School Type
  • School
  • Grade
  • Gender
  • Ethnicity/Race
  • Enrollment Status
  • Title I Part C Migrant
  • Socioeconomically Disadvantaged
  • English Language Acquisition Status
  • Foster Youth
  • Homeless Program Eligible
  • Amed Forces Family Member
  • Disability Category Code
  • Incident Result
  • Incident Result Duration
  • User Comments

Report Logic:


Report 7.17 Screenshot

Click image to expand


Column Rules
1 School code is derived from user ID permission and Expected Schools table
2 School Name is determined by #1 and the Expected Schools Table
Links to Report 7.18 Incident Removals for Students with Disabilities – Student List
3 Disability Category is the most recent PLAN record effective on Incident Occurrence Date that overlaps the Most Recent SWDS record effective on Incident Occurrence Date where Status = 1 (Eligible and Participating)
4 Total # Student Removed to an Interim Alternative Setting (Unduplicated) - Unduplicated count of SSIDs within each disaggregated category at the School of Attendance that have at least one Student Incident (SINC) record where 18.17- Removal to Interim Alternative Setting Reason Code = 1 or 2
If a Student is removed from their regular instructional setting in separate incidents, count the student only once within each disaggregated category.
5 # of Students Removed by a Hearing Officer (Unduplicated) - Unduplicated count of SSIDs within each disaggregated category at the School of Attendance that have at least one Student Incident (SINC) record Removal to 18.17-Interim Alternative Setting Reason Code = 1
If a Student is removed from their regular instructional setting in separate incidents, count the student only once within each disaggregated category.
6 # of Students Removed by School Personnel (Unduplicated) - Unduplicated count of SSIDs within each disaggregated category at the School of Attendance that have at least one Student Incident (SINC) record 18.17-Removal to Interim Alternative Setting Reason Code = 2
If a Student is removed in separate incidents, count the student only once within each disaggregated category.
7 # of Drug-Related Offenses - Count of student offenses within each disaggregated category at the School of Attendance where SINC Field 18.17-Removal to Interim Alternative Setting Reason Code = 1 or 2 and SOFF Field 20.14-Student Offense Code = 200, 201, 202, 203, 204, 205, 300
If a Student is removed to an interim alternative setting as a result of multiple drug-related offenses within the same incident, count each drug-related offense.
8 # of Weapon-Related Offenses - Count of student offenses within each disaggregated category at the School of Attendance where SINC Field 18.17-Removal to Interim Alternative Setting Reason Code = 1 or 2 and SOFF Field 20.14-Student Offense Code = 100, 101, 103, 104, 105
If a Student is removed to an interim alternative setting as a result of multiple weapon-related offenses within the same incident, count each weapon-related offense.
9 # of Violent Incident (with Physical injury) Offenses - Count of student offenses within each disaggregated category at the School of Attendance where SINC Field 18.17-Removal to Interim Alternative Setting Reason Code = 1 or 2 and SOFF Field 20.14-Student Offense Code = 400, 401, 500, 503, 504, 505, 509
If a Student is removed to an interim alternative setting as a result of multiple violent with injury-related offenses within the same incident, count each violent with injury-related offense.

Additional Resources

CALPADS File SpecificationsForm

Look for Incident files (SINC, SIRS, SOFF), Student Enrollment (SENR), Student Information (SINF) and Student Program (SPRG) tabs for the fields indicated in the report logic.

CALPADS Data Guide

Chapter 2.1.4 provides additional information on student incident.

CALPADS Code Sets

This document contains the current code values referenced in the file specifications for the coded value data elements.