Skip to main content
California Department of Education Logo

File Structure: CALPADS UPC Source File-z2

File structure for the CALPADS Unduplicated Pupil Count (UPC) Source File (9-12).

This file structure corresponds to the following data files:

cupcXXYY-912.xls

Refer to the main CALPADS Unduplicated Pupil Count (UPC) Source File (9–12) Web page for the data file. The file is downloadable and is available in Microsoft Excel format

Field Description

Academic Year

The academic year corresponding to the annual Census Day from which official enrollment counts are determined using data submitted as part of the annual Fall 1 submission to the California Longitudinal Pupil Achievement Data System (CALPADS) by local educational agencies (LEAs), which includes school districts, charter schools, and county offices of education. Census Day or Information Day is always the first Wednesday in October.

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.

District Type

 District Ownership Type Description.
School Type School Ownership Type Description.
Educational Option Type Educational Option Type Description.
NSLP Provision Status Note: Data element was retired beginning 2023–24.
Charter School (Y/N) A "Y" or "N" value indicating whether a school is a charter school in the current academic year.
Charter Number A four character value (any combination of numbers and letters) assigned to a charter school. A blank value indicates the school is not a charter school.
Charter Funding Type The values in this field indicate the charter school funding type. Values are as follows: Locally funded, Directly funded, Not in Charter School funding model, or Blank.
IRC A "Y" or "N" value indicating whether a school is an independently reporting charter (IRC) school in the current academic year.
Low Grade Lowest grade offered.
High Grade Highest grade offered.
Total Enrollment (Grades 9–12) A total count of all students in grades 9–12 enrolled (primary or short-term) on Census Day. This count corresponds to the "Total Enrollment" count provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth - Count when filtered for grades 9–12.
CALPADS Unduplicated Pupil Count (CUPC) (Grades 9–12) Of the Total Enrollment (Grades 9–12), an unduplicated count of students who are FRPM eligible (including foster youth students) or EL eligible. This count corresponds to the "Total Unduplicated FRPM/EL Eligible Count" provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth - Count when filtered for grades 9–12.
CALPADS Unduplicated Pupil Percentage (CUPP) (Grades 9–12) Of the Total Enrollment (Grades 9-12), the percentage of unduplicated students in grades 9-12 who are FRPM eligible (including foster youth students) or EL eligible.
CUPP 75% or more (Grades 9–12) A "Y" or "N" value indicating whether a school has a CALPADS Unduplicated Pupil Percentage (CUPP) (Grades 9-12) that is 75% or greater.
CALPADS Fall 1 Certification Status (Y/N) A "Y" or "N" value indicating whether data were submitted and certified in CALPADS. No data are provided where the certification status is "N".
Questions:   Analysis Measurement & Accountability Reporting Division | dro@cde.ca.gov
Last Reviewed: Friday, October 25, 2024
Trending in Accessing Educational Data
Recently Posted in Accessing Educational Data
  • DataQuest Update, Issue #24 (added 17-Jul-2025)
    DataQuest is an online data reporting resource that provides access to a wide variety of data reports and downloadable data files.
  • Information about the Staff Experience Data (added 17-Jul-2025)
    Overview of the Staff Experience data, including data sources, DataQuest reports, downloadable files, definitions, and other information helpful to understanding the data, reports, and downloadable files.
  • Information about the Staff Race/Ethnicity Data (added 17-Jul-2025)
    Overview of the Staff Race/Ethnicity data, including data sources, DataQuest reports, downloadable files, definitions, and other information helpful to understanding the data, reports, and downloadable files.
  • Student/Staff Ratios Downloadable Data Files (added 17-Jul-2025)
    Downloadable data files about student/staff ratios as of Census Day disaggregated by staff type, academic year, and school grade span.
  • Staff Experience Downloadable Data Files (added 17-Jul-2025)
    Downloadable data files about certificated staff employed on Census Day disaggregated by years of experience, academic year, staff type, school grade span, and gender.

  • File Structure: Staff Race/Ethnicity Data (added 17-Jul-2025)
    File structure for downloadable data files containing Certificated Staff by Race/Ethnicity disaggregated by academic year, staff type, school grade span, and gender.
  • File Structure: Staff Experience Data (added 17-Jul-2025)
    File structure for downloadable data files containing Certificated Staff Experience disaggregated by academic year, staff type, school grade span, and gender.
  • File Structure: Staff Education Data (added 17-Jul-2025)
    File structure for downloadable data files containing Certificated Staff Education disaggregated by academic year, staff type, school grade span, and gender.
  • Staff Counts by Experience (added 17-Jul-2025)
    Reports and data about certificated staff employed on Census Day disaggregated by years of experience, academic year, staff type, school grade span, and gender.
  • Staff Counts by Education (added 17-Jul-2025)
    Reports and data about certificated staff employed on Census Day disaggregated by education level, academic year, staff type, school grade span, and gender.