Skip to main content
California Department of Education Logo

File Structure: Chronic Absenteeism Data

File structure for downloadable files containing student chronic absenteeism data by race/ethnicity, gender, and program subgroup. Chronic absenteeism counts, cumulative enrollment, and chronic absenteeism rate data are provided.

File Name: chronicabsenteeism17.txt, chronicabsenteeism18.txt

General Description of the Data File

Field Name Description
Academic Year

The academic year (July 1 – June 30) corresponding to the time period during which the data were collected.

Aggregate Level

An indicator of the aggregation level. NOTE: One of these values must be chosen to obtain an unduplicated count at the selected level.

  • T = State
  • C = County
  • D = District
  • S = School
County Code A unique two-digit code corresponding to the county.
District Code

A unique five-digit code corresponding to the district.

School Code

A unique seven-digit code corresponding to the school.

County Name County Name
District Name District or Administrative Authority Name
School Name School Name
Charter (ALL/Y/N)

An indicator of whether data for all schools, only charter schools, or only non-charter schools are included. NOTE: One of these values must be chosen to obtain an unduplicated count at the selected level.

All = Includes data for all schools regardless of charter status. For Aggregate Level = S, all schools are included. For Aggregate Levels T, C, and D, data for all schools are included in the aggregate.

Y = Includes only data for charter schools. For Aggregate Level = S, only charter schools are included. For Aggregate Levels T, C, and D, only data for charter schools are included in the aggregate.

N = Includes only data for non-charter schools. For Aggregate Level = S, only non=charter schools are included. For Aggregate Levels T, C, and D, only data non-charter schools are included in the aggregate.

Reporting Category An indicator of the student group reporting category (race/ethnicity, gender, program subgroup, or grade span) disaggregation or subset. NOTE: Select Reporting Category = TA for aggregate totals without consideration of a Reporting Category student group.
  • RB = African American
  • RI = American Indian or Alaska Native
  • RA = Asian
  • RF = Filipino
  • RH = Hispanic or Latino
  • RD = Did not Report
  • RP = Pacific Islander
  • RT = Two or More Races
  • RW = White
  • GM = Male
  • GF = Female
  • SE = English Learners
  • SD = Students with Disabilities
  • SS = Socioeconomically Disadvantaged
  • SM = Migrant
  • SF = Foster
  • SH = Homeless
  • GRK = Kindergarten
  • GR13 = Grades 1–3
  • GR46 = Grades 4–6
  • GR78 = Grades 7–8
  • GRK8 = Grades K–8
  • GR912 = Grades 9–12
  • GRUG = Ungraded Elementary and Secondary
  • TA = Total
Cumulative Enrollment Cumulative enrollment consists of the total number of unduplicated primary and short-term enrollments within the academic year (July 1 to June 30), regardless of whether the student is enrolled multiple times within a school or district. Cumulative enrollment is calculated at each reporting level (e.g., school, district, county, and state) and therefore is not necessarily additive from one reporting level to the next. For example, if a student is enrolled in multiple schools within a district during the academic year, they are counted once at each school, but only once in the district's cumulative enrollment.
Chronic Absenteeism Enrollment This count uses the Cumulative Enrollment of the selected entity as the baseline and removes students that were not eligible to be considered chronically absent at that entity. Students that are expected to attend less than 31 instructional days at the selected entity or who were enrolled but did not attend the selected entity are not eligible to be considered chronically absent at that entity. This is calculated by looking at the number of expected days to attend and actual days attended that LEAs submit for each student in CALPADS. Students with exempt status are also removed from Chronic Absenteeism eligibility. Students are considered to be exempt if they are enrolled in a Non-Public School (NPS), receive instruction through a home or hospital instructional setting or are attending community college full-time.
Chronic Absenteeism Count Total count of ALL chronically absent students at the selected entity for the selected population using the available filters. Students are determined to be chronically absent if they were eligible to be considered chronically absent at the selected level during the academic year and they were absent for 10% or more of the days they were expected to attend. Chronic absenteeism is calculated for each student at each reporting level (e.g., school, district, county, and state) based on the expected days of attendance and actual days attended reported by local educational agencies (LEAs) in the California Longitudinal Pupil Achievement Data Systems (CALPADS). Expected attendance days are determined for each student at each reporting level based on the total number of days a student was scheduled to attend. Days attended are determined for each student at each reporting level based on the total number of days the student attended the school. A day attended is defined as any day a student attended for all or part of a school day.
Chronic Absenteeism Rate The unduplicated count of students determined to be chronically absent (Chronic Absenteeism Count) divided by the Chronic Absenteeism Enrollment at the selected entity for the selected population using the available filters.
General Description of the Data File

The absenteeism data are submitted by local educational agencies (LEAs) and charter schools to the California Department of Education (CDE) as part of the annual End of Year 3 (EOY 3) data submission in the California Longitudinal Pupil Achievement Data System (CALPADS). Absenteeism data and Cumulative Enrollment are reviewed and certified in CALPADS as being accurate by authorized district or school personnel. In order to certify data in CALPADS, authorized district or charter school personnel are required to review the accuracy of all data associated with the applicable CALPADS submission. CALPADS certification is a two-step process with Level-2 certification reserved for the district superintendents, charter school administrators, or their designees. Please contact the district or school if you have any questions about their certified CALPADS data.

Source: Absenteeism and Cumulative Enrollment data are submitted and certified by LEAs and/or charter schools as part of the annual CALPADS End of Year 3 submission.

Note: An asterisk (*) appearing in a data field is used to protect student privacy.

Questions: Data Reporting Office | dro@cde.ca.gov | 916-327-0219 
Last Reviewed: Wednesday, January 8, 2020
Recently Posted in Demographics
  • DataQuest Update (added 03-Feb-2020)
    The DataQuest Update is intended to keep DataQuest users informed about upcoming data releases, new reports and downloadable data files, enhancements and changes to DataQuest, and provide tips on how to use DataQuest.
  • DataQuest Update Issue #3 (added 03-Feb-2020)
    The DataQuest Update is intended to keep DataQuest users informed about upcoming data releases, new reports and downloadable data files, enhancements and changes to DataQuest, and provide tips on how to use DataQuest
  • DataQuest Update Issue #1 (added 03-Feb-2020)
    The DataQuest Update is intended to keep DataQuest users informed about upcoming data releases, new reports and downloadable data files, enhancements and changes to DataQuest, and provide tips on how to use DataQuest
  • DataQuest Update Issue #2 (added 03-Feb-2020)
    The DataQuest Update is intended to keep DataQuest users informed about upcoming data releases, new reports and downloadable data files, enhancements and changes to DataQuest, and provide tips on how to use DataQuest
  • File Structure: One-Year Graduate Counts (added 29-Jan-2020)
    File structure for downloadable data files for one-year graduates by race/ethnicity, student program subgroup, and gender.