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:
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 | 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 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". |