Skip to main content
California Department of Education Logo

File Structure: CALPADS UPC Source File

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

This file structure corresponds to the following data files:

CUPCxxxx-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 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 The values in this field indicate the school-level National School Lunch Program Provision Status for lunch and breakfast. Where no lunch or breakfast provision is specified, then the specified provision applies to both lunch and breakfast. Values are as follows: Community Eligibility Provision (CEP), Provision 1, Provision 2, Provision 3, Lunch Provision 1, Lunch Provision 2, Lunch Provision 3, Breakfast Provision 1, Breakfast Provision 2, Breakfast Provision 3, Multiple Provision Types, or N/A. This information is provided for informational purposes only. No special adjustments were made in the data for provision schools. For more information on NSLP provision status, please refer to the United States Department of Agriculture (USDA) School Meals Guidance and Resources Webpage.
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 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: Data Reporting Office | dro@cde.ca.gov | 916-327-0219 
Last Reviewed: Tuesday, July 23, 2019
Recently Posted in Demographics
  • DataQuest Update 4 (added 24-Feb-2020)
    DataQuest Update 4, January 2020, Release of New Data
  • 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
  • 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 #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
  • 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.