Report 7.18 Incident Removals for Students with Disabilities – Student List

(Updated 04/15/2024)

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.

Security Role Required: EOY 3 Reports

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 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

  • Qualifying Enrollment

    • Enrollment Status Code = Primary Enrollment (10), Secondary Enrollment (20), Short Term Enrollment (30), -Grade Level = IN, TD, PS, TK, KN, 01 – 12

  • Qualifying Data

    • 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)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:


Report 7.18 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.
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 SWDS Status Start Date – SWDS status start date from record effective on the incident Occurrence Date
10 PLAN Effective Start Date – Plan Effective Start date from record effective on the incident Occurrence Date for students that are Eligible and participating on the Incident Occurrence date
11 Education Plan Code – Education Plan Code from the PLAN record effective on the incident Occurrence Date for students that are Eligible and participating on the Incident Occurrence date
12 Primary Disability Code – 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) (See CALPADS Glossary: Record Effective on)
13 Ethnicity/Race - identified using SINF fields 2.23 (Student Hispanic Ethnicity Indicator), SINF 2.24 (Student Ethnicity Missing Indicator), SINF 2.25-2.29 (Student Race 1-5 Code), and SINF 2.30 (Student Race Missing Indicator) and the following rules:
1) If the Student Hispanic Ethnicity Indicator (Field 2.23) = Y, always roll up to Hispanic, even if one or more races are selected or the Student Race Missing Indicator (Field 2.30) = Y
2) If Student Hispanic Ethnicity Missing Indicator (Field 2.23) = N or null and the Student Ethnicity Missing Indicator (Field 2.24) = Y or null and Student Race 1 - 5 Codes (Fields 2.25 - 2.29) is indicated, then roll up per rules outlined in 5 below.
3) If the Student Hispanic Ethnicity Indicator (Field 2.23) = N and the Student Race Missing Indicator (Field 2.30) = Y, then roll up to "Missing".
4) If the Student Hispanic Ethnicity Indicator (Field 2.23) = N or null, and the Student Race Missing Indicator (Field 2.30) = Y, then roll up to "Missing."
5) If the Student Hispanic Ethnicity Indicator (Field 2.23) = N or null, and the Student Race Missing Indicator (Field 2.30) = N or null, and Student Race 1-5 Codes (Field 2.25 - 2.29) 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.
14 Incident ID – SINC Field 18.13(Incident ID Local)
15 Incident Occurrence Date – SINC Field 18.14(Incident Occurrence Date)
16 Inst Support Provided – SINC Field 18.16(Student Instructional Support Indicator)
17 Removed to Interim Alternative Setting – SINC Field 18.17(Removal to Interim Alternative Setting Reason Code)
18 Incident Result Code – SIRS Field 19.14(Incident Result Code)
19 Authority – SIRS Field 19.15(Incident Result Authority Code)
20 Duration Days – SIRS Field 19.16(Incident Results Duration Days)
21 Modification – SIRS Field 19.17(Incident Result Modification Code)
22 Student offense – SOFF Field 20.14(Student Offense Code)
23 Weapon Category – SOFF Field 20.15 (Weapon Category Code)

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.