File Structure: Cumulative Enrollment Data

File structure for downloadable files containing cumulative enrollment data from the California Longitudinal Pupil Achievement Data System (CALPADS) reported by race/ethnicity, gender, and program subgroup.

These files include state, county, district, and school-level data. Please refer to the file structure for details on what data are contained in the file. These files also contain aggregate data with disaggregated data subsets at different levels and reporting categories to provide enhanced analytical flexibility. For more detailed examples about how to properly use these data, please refer to the Using the Cumulative Enrollment Data File examples below.

Note: To protect student privacy, data are suppressed (*) on the data file if the cell size within a selected student population (cumulative students) is 10 or less. Additionally, the "Not Reported" race/ethnicity is suppressed, regardless of actual cell size, if the student population for one or more other race/ethnicity groups is suppressed. Data are not included for districts and independently reporting charter schools (IRCs) that did not certify their California Longitudinal Pupil Achievement Data System (CALPADS) End-of-Year 3 submission.

General Description of the Cumulative Enrollment 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. T = State C = County D = District S = School Note: One of these values must be chosen to obtain an unduplicated count at the selected level.
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: All = Includes data for all schools regardless of charter status. For Aggregate Levels T, C, and D, data for all schools are included in the aggregate. For Aggregate Level = S, "All" is not an applicable status; rather, for Aggregate Level = S, either Charter = Y or Charter = N, depending on the school 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 for non-charter schools are included in the aggregate. Note: One of these values must be chosen to obtain an unduplicated count at the selected level.
Reporting Category	An indicator of the student group reporting category (race/ethnicity, gender, or program subgroup) disaggregation or subset. RB = African American RI = American Indian or Alaska Native RA = Asian RF = Filipino RH = Hispanic or Latino RD = Not Reported RP = Pacific Islander RT = Two or More Races RW = White GM = Male GF = Female GX = Non-Binary Gender (Beginning 2019–20) GZ = Missing Gender SE = English Learners SD = Students with Disabilities SS = Socioeconomically Disadvantaged SM = Migrant SF = Foster SH = Homeless TA = Total Note: Select Reporting Category = TA for aggregate totals without consideration of a Reporting Category student group.
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.

General Description of the Data File

The cumulative enrollment 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 CALPADS. Data 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. The data certification must be performed by 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: Cumulative Enrollment data are submitted and certified by LEAs and/or charter schools as part of the annual CALPADS End of Year 3 submission.

Using the Cumulative Enrollment Data File

This file contains different subsets of data based on the values of different variables. If these sub-setting variables are not used properly, it is easy to end up with incorrect or duplicative data. Please refer to the following examples below as a guide for properly using these data:

Get school-level data totals with one record per school (without student group totals)
1. Aggregate Level = S (School)
2. Reporting Category = TA
Get school-level data totals by student group (Reporting Category) for all non-charter schoolss
1. Aggregate Level = S (School)
2. Charter (All/Y/N) = N
3. Reporting Category Not equal to TA
Get district-level data totals with one record per district (without student group totals)
1. Aggregate Level = D (District)
2. Charter (All/Y/N) = All
3. Reporting Category = TA
Get district-level data totals by student group (Reporting Category) for charter schools
1. Aggregate Level = D (District)
2. Charter School (All/Y/N) = Y
3. Reporting Category Not equal to TA
Get statewide-level data totals for non-charter schools (without student group totals)
1. Aggregate Level = T (State)
2. Charter School (All/Y/N) = N
3. Reporting Category = TA

Questions: Data Reporting Office | dro@cde.ca.gov | 916-327-0219

Last Reviewed: Wednesday, January 03, 2024

Trending in Accessing Educational Data

Recently Posted in Accessing Educational Data

Annual Aggregate Reports (added 09-Apr-2024)
The page displays the annual California State Preschool Program enrollment data by Statutory Age and Program Length for fiscal years 2020−23, providing an unduplicated count of children served by the California Department of Education (CDE).
CSPP Enrollment by Provider County Reports (added 09-Apr-2024)
The page provides links to annual October California State Preschool Program (CSPP) enrollment reports by provider county for 2020−22 in XLSX format.
Single-Month Reports (added 09-Apr-2024)
The page displays California State Preschool Program (CSPP) Enrollment by Program Length, Statutory Age, Agency Classification, and Race/Ethnicity.
Two-Month Average Data Reports (added 09-Apr-2024)
The page displays two-month average Early Education Division (EED) enrollment data for children by Program Length and Statutory Age for October/April in 2020−23.