Report 7.18 Incident Removals for Students with Disabilities – Student List

(Updated as of 05/10/2021)

Description: Reports students with disabilities who were removed from their regular instructional setting for disciplinary reasons, regardless of enrollment status. It also reports characteristics about each student and each incident including the Incident Results and Incident Result modifications.

Data As Of: - Snapshot version, any time in the reported academic year (7/1 – 6/30)

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 (SPED) data used for selecting Students with Disabilities are selected from qualifying SPED record that overlaps the qualifying enrollment at the Reporting LEA in the SINC record with the Incident Occurrence Date
  • Students with a qualifying enrollment who are Active Students with Disabilities on the incident date and who were involved in an incident at any time during the report period.
  • Qualifying Enrollment
    • Open enrollment at any time during the Report Period
    • Enrollment Status Code = Primary Enrollment (10), Secondary Enrollment (20), or Short Term Enrollment (30)
    • Grade Level = KN, 01 – 12, IN, TD, PS
  • Qualifying Data
    • Students with Disabilities
      • 14.24(Education Plan Type) = 100 (IEP/IFP), 150 (IFSP), or 200 (ISP), AND
      • (Plan Set Start Date <= Reporting Period Through (End) Date and either ((Plan Set has no End date) or (Plan Set Exit Date >= Reporting Period From (Start) Date))) Note- For reports, see also Records Selection Business for further restrictions.
    • Student Incident Record (Record Type = SINC) for the Academic Year being reported Student Data Rules, if applicable to report:
    • Student Incident Result (Record Type = SIRS) and Student Offense (Record Type = SOFF) data used for are associated with the same Incident ID local, School of Attendance, and SSID

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
  • Disability Category Code
  • Title I Part C Migrant
  • Socioeconomically Disadvantaged
  • English Language Acquisition Status
  • Foster Youth
  • Homeless Program Eligible
  • Armed Forces Family Member
  • Incident Result Duration
  • Offense Grouping - Use Valid Code Combo Offense Code – Offense Grouping
  • Incident Result
  • Student Offense
  • Weapon Category


Report Logic:


EOY 3 Report 7.18

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.
3 SELPA Code: SELPA Code from Most recent Active SPED record at same Reporting LEA
4 SSID – SENR Field 1.08-SSID
5 Student Name – SINF Fields 2.11(Student Legal First Name) + 2.12(Student Legal Middle name 2.13(Student Legal last Name)
6 Local ID – SINC Field 18.08(Local Student ID)
7 Gender – SINF Field 2.19(Student Gender Code)
8 Grade – SENR Field 1.25(Grade Level Code)
9 SPED Meeting Date – SPED Field 14.21(Special Education Meeting Date) – from most recent Active SPED record overlapping SINC Field 18.14 – Incident Occurrence Date
10 SPED Program Exit Date – SPED Field 14.46(Special Education Program Exit Date) – from most recent Active SPED record overlapping SINC Field 18.14 – Incident Occurrence Date
11 Primary Disability Code – SPED Field 14.28(Disability Code 1) – most recent Active SPED record
12 Ethnicity/Race - identified using SINF fields 2.24 (Student Hispanic Ethnicity Indicator), SINF 2.25 (Student Ethnicity Missing Indicator), SINF 2.26-2.30 (Student Race 1-5 Code), and SINF 2.31 (Student Race Missing Indicator) and the following rules:
1) If the Student Hispanic Ethnicity Indicator (Field 2.24) = Y, always roll up to Hispanic, even if one or more races are selected or the Student Race Missing Indicator (Field 2.31) = Y
2) If Student Hispanic Ethnicity Missing Indicator (Field 2.24) = N or null and the Student Ethnicity Missing Indicator (Field 2.25) = Y or null and Student Race 1 - 5 Codes (Fields 2.26 - 2.30) is indicated, then roll up per rules outlined in 5 below.
3) If the Student Hispanic Ethnicity Indicator (Field 2.24) = N and the Student Race Missing Indicator (Field 2.31) = Y, then roll up to "Missing".
4) If the Student Hispanic Ethnicity Indicator (Field 2.24) = N or null, and the Student Race Missing Indicator (Field 2.31) = Y, then roll up to "Missing."
5) If the Student Hispanic Ethnicity Indicator (Field 2.24) = N or null, and the Student Race Missing Indicator (Field 2.31) = N or null, and Student Race 1-5 Codes (Field 2.26 - 2.30) is indicated, then roll up as follows:
• If a single race = American Indian or Alaska Native (100), roll up to American Indian or Alaska Native
• If there is one or more of any of the Asian subgroups: ((201) Chinese, (202) Japanese, (203) Korean, (204) Vietnamese, (205) Asian Indian, (206) Laotian, (207) Cambodian, (208) Hmong, (299) Other Asian, and no other race category (100, 301, 302, 303, 304, 399, 400, 600, 700, 302, 303, 304, 399, 400, 600, 700) then roll up to Asian
• If a single race = Filipino (400) roll up to Filipino(400)
• If race includes Filipino (400) AND one or more of any of the Asian subgroups, [(201) Chinese, (202) Japanese, (203) Korean, (204) Vietnamese, (205) Asian Indian, (206) Laotian, (207) Cambodian, (208) Hmong, (299) Other Asian) and no other race category roll up to Filipino(400)
• If there is one or more of any of the Native Hawaiian/Pacific Islander subgroups ((301) Hawaiian, (302) Guamanian, (303) Samoan, (304) Tahitian, (399) Other Pacific Islander) and no other race category (100, 201, 202, 203, 204, 205, 206, 207, 208, 299, 400, 600, 700) then roll up to Hawaiian/Pacific Islander.
• If a single race = (600) Black or African American, roll up to Black or African American
• If a single race = (700) White, roll up to White
• If more than one of the following races: American Indian or Alaska Native, Asian, Black or African American, Native Hawaiian/Pacific Islander, White, roll up to "Multiple"
Note: The above rules apply to Snapshot reports starting AY 2016-2017 and ODS reports. For ODS reports that display Ethnicity/Race and are generated in AY 2016-2017, the Filipino ethnicity will not be displayed as a separate ethnicity/race or counted within Asian ethnicity/race category.

EOY 3 Report 7.18

Column Rules
13 Incident ID – SINC Field 18.13(Incident ID Local)
14 Incident Occurrence Date – SINC Field 18.14(Incident Occurrence Date)
15 Inst Support Provided – SINC Field 18.16(Student Instructional Support Indicator)
16 Removed to Interim Alternative Setting – SINC Field 18.17(Removal to Interim Alternative Setting Reason Code)
17 Incident Result Code – SIRS Field 19.14(Incident Result Code)
18 Authority – SIRS Field 19.15(Incident Result Authority Code)
19 Duration Days – SIRS Field 19.16(Incident Results Duration Days)
20 Modification – SIRS Field 19.17(Incident Result Modification Code)
21 Student offense – SOFF Field 20.14(Student Offense Code)
22 Weapon Category – SOFF Field 20.15 (Weapon Category Code)


User Roles for Access:

EOY 3 Reports


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.