File Structure: CALPADS UPC Source File
File structure for the CALPADS Unduplicated Pupil Count (UPC) Source File.This file structure corresponds to the following data file:
cupcXXYY-k12.xls (2022–23 and prior) and cupcXXYY-tk12.xls (2023–24 and beyond)
Refer to the main CALPADS Unduplicated Pupil Count (UPC) Source File (TK/K–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 | 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 | A total count of all TK/K–12 students 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. |
| Free & Reduced Meal Program | Of the Total Enrollment, a total count of students reported being eligible on Census Day for the National School Lunch Program (NSLP) based on Education Program records with an Education Program Membership Code 181 (Free) or 182 (Reduced). This count corresponds to the "Free & Reduced Meal Program 181/182" count provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth - Count. |
| Foster | Of the Total Enrollment, a total count of students identified through the weekly CALPADS Foster Matching process or matched by the LEA through the CALPADS online match process as being in Foster Students on Census Day. This count corresponds to the "Foster" count provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth - Count. |
| Tribal Foster (beginning in 2020) | Of the Total Enrollment, a total count of students identified reported as being Tribal Foster on Census day based on Education Program record with an Education Program Membership Code 193 (Tribal Foster Youth). This count corresponds to the "Tribal Foster" count provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth - Count. |
| Homeless | Of the Total Enrollment, a total count of students reported as being homeless on Census Day based on Education Program record with an Education Program Membership Code 191 (Homeless). This count corresponds to the "Homeless" count provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth - Count. |
| Migrant Program | Of the Total Enrollment, a total count of students eligible for the Migrant Education Program on Census Day based on and Education Program record with an Education Program Membership Code 135 (Migrant). This count corresponds to the "Migrant Program: 135" count provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth - Count. |
| Direct Certification | Of the Total Enrollment, a total count of students identified as being "directly certified" through CALPADS as participating in California's food stamp or CalWORKs programs and who are therefore eligible for free meals. This count corresponds to the "Direct Certification" count provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth - Count. |
| Unduplicated FRPM Eligible Count | Of the Total Enrollment, a total unduplicated count of students who meet household income or categorical eligibility criteria for free or reduced price meals (FRPM) based on applying for the National School Lunch Program (NSLP); submitting alternative household income forms; their foster, homeless, or migrant statuses in CALPADS; or being "directly certified" through CALPADS as participating in California's food stamp or CalWORKs programs. This count corresponds to the "Unduplicated Eligible Free/Reduced Meal Counts" provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth - Count. This count does NOT represent the "official" FRPM eligible count because early TK children have been removed (Kindergarten students who turn five years old after December 2). |
| English Learner (EL) | Of the Total Enrollment, a count of students enrolled on Census Day who were identified in CALPADS as English learners (EL) on or before Census Day. This count corresponds to the "EL Funding Eligible" count provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth - Count. (Note: For 2020, the data for EL identification was extended through December 31 for LCFF purposes only). |
| CALPADS Unduplicated Pupil Count (UPC) | Of the Total Enrollment, 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. |
| 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