Report 7.14 Student Offense – Student List

(Updated 04/15/2024)

Description: RReports 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.

Security Role Required: EOY 3 Reports

Data As Of:

  • Snapshot version, any time in the reported academic year (7/1 – 6/30)

Report Period:

  • Report Period (July 1 thru June 30 of the reporting year)

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
  • 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)
  • Grade Level = TK, 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
  • Socioeconomically Disadvantaged
  • Students with Disabilities
  • Gifted and Talented
  • 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
  • Weapon Category Code
  • User Comment

Report Logic:


Report 7.14 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.
Links from Report 7.13 Student Offense – Count by Offense
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(Student Gender Code)
7 Grade Level – SENR Field 1.25(Grade Level Code) = KN-12
8 Ethnicity/Race:
1) If the Student Hispanic Ethnicity Indicator (SINF 2.24) = Y, always roll up to Hispanic, even if one or more races are selected or the Student Race Missing Indicator (SINF 2.31) = Y
2) If Student Hispanic Ethnicity Missing Indicator (SINF 2.24) = N or null and the Student Ethnicity Missing Indicator (SINF 2.25) = Y or null and Student Race 1 - 5 Codes (SINFs 2.26 - 2.30) is indicated, then roll up per rules outlined in 5 below.
3) If the Student Hispanic Ethnicity Indicator (SINF 2.24) = N and the Student Race Missing Indicator (SINF 2.31) = Y, then roll up to ""Missing"".
4) If the Student Hispanic Ethnicity Indicator (SINF 2.24) = N or null, and the Student Race Missing Indicator (SINF 2.31) = Y, then roll up to ""Missing.""
5) If the Student Hispanic Ethnicity Indicator (SINF 2.24) = N or null, and the Student Race Missing Indicator (SINF 2.31) = N or null,amd Student Race 1-5 Codes (SINF 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 America
- 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 Offense Indicator – SINC Field 18.15(Statutory Offense Indicator)
12 Student Offense – SOFF Field 20.14(Student Offense Code)
13 Weapon Category – SOFF Field 20.15(Weapon Category Code)

Additional Resources

CALPADS File SpecificationsForm

Look for Student Enrollment (SENR), Student Information (SINF), Student 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.