Report C/A 7.4 - C/A Discipline Actions-Count by Offense
Description: Reports the number of students in grades KN-12 who committed a reportable offense by Offense Code
Data As Of:
- Snapshot version, any time in the reported academic year (7/1 – 6/30)
Basic selection criteria:
- Any open or closed enrollment within the LEA at any time during the Report Period (7/1/2018 -6/30/2019) qualifies for selection
- Student information record that falls wholly or in part within a qualified enrollment
- Student Discipline Record (SDIS) for the Academic Year being reported
- Enrollment Status Code = 10, 20, 30
- Grade Level = KN, 01-12
Report Filters: Filters can be selected resulting in only totals for the selected filter being displayed
- Academic Year (Snapshot)
- LEA
- School Type
- School
- Grade
- Gender
- Ethnicity/Race
- Enrollment Status
- Special Education
- Disciplinary Removal Duration
- User Comments
Report Logic:
| Column | Rules |
|---|---|
| 1 | LEA 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 7.4-Disciplinary Actions-Count by Offense |
| 3 | Offense Code - SDIS 4.15 (Student Offense Code) when 4.15 = 100-105, 200-205, 300,400-403, 500, 500-513, 601-602 |
| 4 | Gender: SINF 2.19 – a coded value representing the student’s gender |
| 5 | Ethnicity/Race: |
| 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,amd 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. | |
| 6 | Ethnicity/Race: SINF Fields 2.23 and 2.25 - Ethnicity reported for students identified as Hispanic. Student who are not Hispanic have their race reported |
| 7 | # of Students That Committed an Offense (unduplicated): Enrollment Status (1.24) = Primary(10), Secondary (20), Short-Term (30), orReceiving Specialized Services (40) ; Student Offense Code ( 4.15) = 100-105, 200-205, 300, 400, 401, 403, 500-513, 600-603 (see CALPADS Code Sets for additional detail of codes) Unduplicated count of SSIDs. If multiple students reported for same offense associated with one incident, both students are counted |
| 8 | # of Offenses Committed: Student Offense Code (4.15) = 100-105, 200-205, 300, 400, 401, 403, 500-513, 600 603 (see CALPADS Code set for additional detail of codes) Count of all SDIS records at the School of Attendance within each disaggregated category (gender, ethnicity/race) |
| 9 | # of Out-of-School Suspensions (100): Incident Disciplinary Action Taken Code (4.18) = 100 (Out-of-School Suspension) Duplicated count of SSIDs If a Student is disciplined more than once for committing the same offense in separate incidents, include each discipline as a separate event in this count. |
| If a Student committed more than one offense for the same Incident (SSID has more than one SDIS record for the incident), count the discipline for that student and incident only once. | |
| 10 | # of Expulsions (200): Incident Disciplinary Action Taken Code (4.18) = 200 (Expulsion) Duplicated count of SSIDs If a Student is disciplined more than once for committing the same offense in separate incidents, include each discipline as a separate event in this count. If a Student committed more than one offense for the same Incident (SSID has more than one SDIS record for the incident), count the discipline for that student and incident only once. |
| 11 | # of In-School Suspensions (110): Incident Disciplinary Action Taken Code (4.18) = 110 (In-School Suspension) Duplicated count of SSIDs If a Student is disciplined more than once for committing the same offense in separate incidents, include each discipline as a separate event in this count. If a Student committed more than one offense for the same Incident (SSID has more than one SDIS record for the incident), count the discipline for that student and incident only once. |
| 12 | # of Other Means of Correction or No Action (300): # of Other Means of Correction or No Action (300): 4.18 = Other Means of Correction or No Action (300) Duplicated count of SSIDs If a Student is disciplined more than once for committing the same offense in separate incidents, include each discipline as a separate event in this count. If a Student committed more than one offense for the same Incident (SSID has more than one SDIS record for the incident), count the discipline for that student and incident only once. |
| 13 | # of Students Who Received Instructional Support (Unduplicated) Student Instructional Support Indicator (4.21): Student Instructional Support Indicator (4.21) = Y Unduplicated count of SSIDs within each disaggregated category. If multiple students are reported for the same offense associated with one incident, each student is counted. |
User Roles for Access:
** County or Authorizing LEA Reports**
Additional Resources
CALPADS File SpecificationsForm
Look for Student Discipline (SDIS) for the fields indicated in the report logic.
CALPADS Data Guide
Chapter 2.1.4 provides additional information on student discipline.
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.