Skip to main content
California Department of Education Logo

File Structure: CALPADS UPC Source File 2013-14

File structure for the CALPADS Unduplicated Pupil Count (UPC) Source File for 2013–14.

This file structure corresponds to the following data file:

CALPADS Unduplicated Pupil Count (UPC) Source File 2013–14.

Refer to the main CALPADS Unduplicated Pupil Count (UPC) Source File 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
NSLP Provision 2 or 3 School (Y/N) A Y or N value to indicate whether a school is on a National School Lunch Program (NSLP) provision 2 or 3 status. "Y" indicates the school is on a provision status; "N" indicates the school is not. For more information on NSLP provision status, please refer to the United States Department of Agriculture (USDA) School Meals Guidance and Resources Webpage. This indicator is provided for information purposes only. No special adjustments were made in the data for provision 2 and 3 schools.
Charter School 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 School Funding Type Indicates the charter school funding type. Values are as follows: Locally funded, Directly funded, Not in Charter School funding model, or Blank.
Low Grade Lowest grade offered
High Grade Highest grade offered
Enrollment (K-12) A total count of K-12 students enrolled (primary or short-term) on Census Day (the first Wednesday in October). These data were submitted to CALPADS as part of the annual Fall 1 submission.
Unduplicated FRPM Eligible Count (Unadjusted) Of the Enrollment (K-12) count, 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 homeless, migrant, or foster status in CALPADS; or being "directly certified" as participating in California's food stamp or CalWORKs programs during July - November 2013. This count corresponds to the "Total Unduplicated Eligible Free/Reduced Meal Counts" provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth - Count.
English Learner (EL) Count Of the Enrollment (K-12) count, a count of students identified in CALPADS as English learners (EL). This count corresponds to the "EL Funding Eligible" count provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth - Count.
CDSS Foster Youth Count Of the Enrollment (K-12) count, a count of students identified as being in foster care through a data match between CALPADS and the California Department of Social Services (CDSS) Child Welfare Services / Case Management System (CWS/CMS). This count corresponds to the "CDSS Foster Youth" count provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth - Count. This count may include foster youth identified from the statewide match with California Department of Social Services (CDSS) data conducted after LEAs' certification of their CALPADS Fall 1 data.
Unduplicated FRPM/EL/Foster Count (Unadjusted) Of the Enrollment (K-12) count, an unduplicated count of students who are FRPM eligible, EL, or Foster Youth. This count corresponds to the "Unduplicated FRPM/EL/Foster Youth Total" count provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth - Count. Note: If LEAs printed a version of this report prior to the February load of CDSS data, the printed report may not include additional foster students identified by the statewide match.  If LEAs view the report in CALPADS it will now reflect the updated counts.
Directly Certified (Dec - Feb) Count Of the Enrollment (K-12) count, a total count of students "directly certified" as participating in California's food stamp or CalWORKs programs during December 2013, January 2014, or February 2014, and therefore eligible for free meals.
Unduplicated FRPM/EL/Foster Count (Adjusted) Of the Enrollment (K-12) count, an unduplicated count of students who are FRPM eligible, EL, or Foster Youth that has been adjusted to include the Directly Certified (Dec - Feb) Count. This count augments the Unduplicated FRPM/EL/Foster Count (Unadjusted) to include the unduplicated count of students "directly certified" as participating in California's food stamp or CalWORKs programs during December 2013, January 2014, or February 2014. This adjustment is not reflected on the CALPADS certification report 1.17: FRPM/English Learner/Foster Youth - Count.
Unduplicated Non-Juvenile Hall Pupil Count For non-Juvenile Hall schools, the CALPADS Unduplicated Pupil Count (UPC) is equal to Unduplicated FRPM/EL/Foster Count (Adjusted).
Unduplicated Juvenile Hall Pupil Count For Juvenile Hall schools, the CALPADS Unduplicated Pupil Count (UPC) is equal to Enrollment (K-12), as all juvenile hall students are counted under the Local Control Funding Formula (LCFF).
CALPADS Unduplicated Pupil Count (UPC) Of the Enrollment (K-12) count, an unduplicated count of students who are FRPM eligible, EL, Foster Youth, or in Juvenile Hall. The CALPADS Unduplicated Pupil Count (UPC) is the starting point for determining the unduplicated pupil percentage (UPP) used in the Local Control Funding Formula (LCFF) supplemental and concentration grant calculations. These data, and additional adjustments made during the apportionment process, are displayed on Principal Apportionment exhibits for the appropriate fiscal year, apportionment cycle, and LEA. The specific exhibits are titled "School District [County/Charter School] Unduplicated Pupil Percentage".
2013–14 CALPADS Fall 1 Certification Status (Y/N) A Y or N value to indicate 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, September 25, 2018
Recently Posted in Demographics
  • College-Going Rate for HS Completers (12-month) (added 11-Jul-2019)
    College-Going Rate (CGR) for California high school completers 12 months after high school completion reported by race/ethnicity, student group, and academic year.
  • College-Going Rate for HS Completers (16-month) (added 11-Jul-2019)
    College-Going Rate (CGR) for California high school completers 16 months after high school completion reported by race/ethnicity, student group, and academic year.
  • File Structure: CGR Data (12-Month) (added 11-Jul-2019)
    File structure for the College-Going Rate (CGR) 12 months after high school completion reported by race/ethnicity, student group, and academic year.
  • File Structure: CGR Data (16-Month) (added 11-Jul-2019)
    File structure for the College-Going Rate (CGR) 16 months after high school completion reported by race/ethnicity, student group, and academic year.
  • Using the CGR Data File (added 11-Jul-2019)
    This page explains how to effectively use the sub-setting variables included in this CGR data file to obtain the desired counts.

  • Transitional Kindergarten Data (updated 17-May-2019)
    Downloadable data files for school-level transitional kindergarten program participation data racial/ethnic designation and subgroup (i.e., gender, English learner, migrant, and socio-economically disadvantaged status).