Report 7.12 Incident Results – Student List

(Updated as of 05/10/2021)

Description: Reports students regardless of enrollment status, who were involved in an incident. Also reports information about each incident, including the incident result, duration days, and cumulative duration days.

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 were involved in an incident at any time during the Report Period at the school of attendance.
  • Enrollment Status Code = Primary Enrollment (10), Secondary Enrollment (20), Short Term Enrollment (30)
  • Default Grade Level = KN, 01 – 12
  • Student Incident Record (Record Type = SINC) for the Academic Year being reported
  • 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
  • School Type
  • School
  • Grade
  • Gender
  • Ethnicity/Race
  • Enrollment Status
  • Title I Part C Migrant
  • Socioeconomically Disadvantaged
  • Students with Disabilities
  • English Language Acquisition Status
  • Foster Youth
  • Homeless Program Eligible
  • Armed Forces Family Member
  • Student Offense
  • Offense Grouping- Use Valid Code Combo Offense Code – Offense Grouping
  • Incident Result Code
  • Incident Result Duration

Report Logic:


EOY 3 Report 7.12


Column Rules
1 School code is derived from user ID permission and Expected Schools tablee
2 School Name is determined by #1 and the Expected Schools Table
3 SSID – SENR Field 1.08-SSID
4 Student Name – SINF Fields 2.11(Student Legal First Name) + 2.13(Student Legal last Name)
5 Local ID – SINC Field 18.08(Local Student ID)
6 Gender: SINF Field 2.19 – a coded value representing the student’s gender
7 Grade Level - SENR Field- 1.25(Grade Level Code) = KN-12
8 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.
9 Incident ID – SINC Field 18.13(Incident ID Local)
10 Incident Occurrence Date – SINC Field 18.14(Incident Occurrence Date)
11 Inst. Support Supplied – SINC Field 18.16(Student Instructional Support Indicator)
12 Removal to Interim Alternative Setting Reason – SINC Field 18.17(Removal to Interim Alternative Setting Reason Code
13 Statutory Offense Indicator – SINC Field 18.15(Statutory Offense Indicator)
14 Incident Result Code – SIRS Field 19.14(Incident Result Code)
15 Authority – SIRS Field 19.15(Incident Results Authority Code)
16 Duration Days – SIRS Field 19.16(Incident Results Duration Days
17 Modification – SIRS Field 19.17(incident Results Modification Code)

User Roles for Access:

EOY 3 Reports

Additional Resources

CALPADS File SpecificationsForm

Look for Student Enrollment (SENR), Student Information (SINF), Incident Files (SINC, SIRS, SOFF) 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.