File Structure: Expulsion and Suspension DataFile structure for downloadable files containing student expulsion and suspension data by ethnicity. The file contains the total suspensions and expulsions reported by each local educational agency.
File Name: discipline12.txt, discipline13.txt, discipline14.txt
For each school, there is one record for every instance where there is data. A school may have 1 to 24 record(s), depending on data reported.
|Field Name||Type Field||Width||Description|
|CDS_CODE||Character||14||This 14-digit code is the official unique identification of a school within California. The first two digits identify the county, the next five digits identify the school district, and the last seven digits identify the school.|
|NAME||Character||100||Name of the county, district, or school depending on the AGGLEVEL.|
|WEAPONS||Character||8||Number of suspensions or expulsions under the "Weapons Possession" Federal category.|
|DRUGS||Character||8||Number of suspensions or expulsions under the "Illicit Drug Related" Federal category.|
|VIOLENCE_WITH_INJURY||Character||8||Number of suspensions or expulsions under the "Violence with Injury" Federal category.|
|VIOLENCE_WITHOUT_INJURY||Character||8||Number of suspensions or expulsions under the "Violence without Injury" Federal category.|
|OTHER_NOT_DEFIANCE||Character||8||Number of suspensions or expulsions under the "Other" Federal category, not including those students disciplined for "Defiance."|
|OTHER_DEFIANCE_ONLY||Character||8||Number of suspensions or expulsions under the "Other" Federal category for "Defiance" only.|
|TOTAL||Character||8||Total number of suspensions or expulsions.|
|YEAR||Character||7||Year of data.|
|DATE_CREATED||Date||10||Date of CALPADS submission deadline.|
|DATE_UPDATED||Date||10||The date of the most recent content addition or modification.|
This file is compiled using student-level data reported to the California Longitudinal Pupil Achievement Data System (CALPADS). This file includes state, county, district, and school level data of students by ethnicity involved in one or more incidents1 during the academic year who were subsequently suspended (in-school or out-of-school) or expelled2 from school. Although a student may have committed multiple offenses as part of a single incident; each student is only counted once per incident for which they were suspended or expelled. Students are counted more than once if they were suspended or expelled multiple times for different incidents.
For reporting purposes, students are counted within the Federal Offense Category corresponding to the most severe offense each student committed within a given incident (see Glossary). In this file, the "Other" Federal Offense Category is further broken into two separate categories: "OTHER_NOT_DEFIANCE" and "OTHER_DEFIANCE_ONLY." Suspended or expelled students whose most serious offense in an incident was violating California Education Code Section 48900(k), otherwise known as "Defiance," are counted under the "OTHER_DEFIANCE_ONLY" category.
The total counts in this file cannot be compared to totals previously collected and reported through the Uniform Management Information Reporting System (UMIRS). In UMIRS, LEAs reported the total number of offenses committed by offense type, and the LEAs likely were not able to report only the most severe offense committed per suspension, resulting in students being counted more than once for the same suspension. Thus it is not advisable to compare this CALPADS data with UMIRS data, as the two are different and not comparable.