Report 7.11 Incident Result – Count

(Updated as of 05/10/2021)

Description: Reports an unduplicated count of students and Students with Disabilities by Incident Result type, total of count of each incident result, and the number of incident results that were modified all by School of Attendance.

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 Information (SINF) data reported or used for selecting student subgroups (e.g. Ethnicity/Race) are selected from the most recent SINF record with Effective Start Date and Effective End Date (if exists) that overlap 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
  • Open enrollment at any time during the Report Period
  • 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 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
  • School Type
  • School
  • Grade
  • Gender
  • Ethnicity/Race
  • Enrollment Status
  • Title I Part C Migrant
  • Socio-economically 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 Results Code

Report Logic:


EOY 3 Report 7.11


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.12 Report 7.12 Incident Results – Student List
3 Incident Result (19.14-Incident Result Code)
4 Total Students (Unduplicated by Result) – Unduplicated count of SSIDs within each disaggregated category
5 Total Students with Disabilities – Unduplicated count of SSIDs within each disaggregated category where student is a Student with Disability on Incident Occurrence Date (See CALPADS Glossary, Students with Disabilities)
6 Total Count of Incident Results - Duplicated Count of SSIDs within each disaggregated category
Note – If the student has the same incident result in two different incidents, the student is counted twice.
7 7. # of Incident Results with Modification – Duplicated Count of SSIDs within each disaggregated category where SIRS Field 19.17 - Modification Category = 100 (enforcement suspended) or 200 (Shortened)
Note – If the student has the same incident result in two different incidents, the student is counted twice.

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.