C/A 7.11: Incident Result - Count
Updated as of 4/26/2023
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)
Security Role(s) Required: County (For COEs); Authorizing LEA Reports (For all other LEAs)
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
- 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 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
- County
- LEA
- 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
- Student Grouping - Use Valid Code Combo Offense Code – Offense Grouping
- Incident Result Code
- Incident Result Duration
Report Logic:
| Column | Rules |
|---|---|
| 1 | LEA code is derived from user ID permission and Expected Schools table |
| 2 | LEA Name is determined by #1 and the Expected Schools Table |
| 3 | School code is derived from user ID permission and Expected Schools table |
| 4 | School Name is determined by #1 and the Expected Schools Table. |
| 5 | Incident Result (SIRS Field 19.14-Incident Result Code) |
| 6 | Total Students (Unduplicated by Result) – Unduplicated count of SSIDs within each disaggregated category |
| 7 | 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) |
| 8 | 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. | |
| 9 | # 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. | |
Additional Resources
CALPADS File SpecificationsForm
Look for Student Incident (SINC), Student Incident Result (SIRS) for the fields indicated in the report logic.
CALPADS Data Guide
Chapter 2.1.4 provides additional information on student incident reporting.
CALPADS Code Sets
This document contains the current code values referenced in the file specifications for the coded value data elements. The program code definitions are listed in this document.