Skip to main content
California Department of Education Logo

File Layout: Graduates in California Colleges

File structure for State Fiscal Stabilization Fund (SFSF) postsecondary indicator C12, high school graduates enrolled in California postsecondary institutions, by race/ethnicity & subgroup for 2006–07.

Name

Type Field

Width

Description

CDS_Code

Character

14

This 14-digit code is the official, unique identification of a school within California. The first two digits identify the county, the next five digits identify the school district, and the last seven digits identify the school.

Name

Character

90

Agency name.

SubGroup

Character

10

This is a coded field for identifying subgroups of students. The subgroups are coded as follows:

  • EL – English learners
  • SD – Socioeconomically Disadvantaged
  • SE – Students with Disabilities
  • ALL – Total of all subgroups

SubGroupType

Character

10

This is a coded field for identifying racial/ethnic designation. The racial/ethnic designations are coded as follows:

  • 0 – Not Reported
  • 1 – American Indian or Alaskan Native, not Hispanic
  • 2 – Asian, not Hispanic
  • 3 – Pacific Islander, not Hispanic
  • 4 – Filipino, not Hispanic
  • 5 – Hispanic or Latino
  • 6 – African American, not Hispanic
  • 7 – White, not Hispanic
  • 9 – Two or more races, not Hispanic
  • ALL – Total of all races/ethnicities

Grads

Character

10

Total number of students who have graduated from California public high schools.

GradsEnrlCAPS

Character

10

Numbers of high school graduates who have enrolled in California public postsecondary institutions within 16 months of their high school graduation.

PercentGradsCAPS

Character

10

Percentage of total high school graduates who have enrolled in California public postsecondary institutions within 16 months of their high school graduation.

Comp1YrCredt

Character

10

Number of high school graduates who have enrolled in California public postsecondary institutions within 16 months of their high school graduation and have completed one year of credit within two years of their postsecondary enrollment.

Percent1YrCredit

Character

10

Percentage of high school graduates who have enrolled in California public postsecondary institutions within 16 months of their high school graduation and have completed one year of credit within two years of their postsecondary enrollment.

Fields marked with an asterisk (*) in the data file are used to protect student privacy where there are ten or fewer students.

Process used to develop Indicator C12

  • The California Department of Education (CDE) extracted an electronic data file from the California Longitudinal Pupil Achievement Data System (CALPADS) containing those students that California public school districts reported as having graduated between October 4, 2006 and October 3, 2007. The data file was securely transmitted to the California Postsecondary Education Commission (CPEC).

  • The CPEC developed a process to match students in the K-12 file to those students in the CPEC database on postsecondary student enrollments in California public postsecondary institutions. Only students enrolling at the University of California (UC), California State University (CSU) and the California Community Colleges (CCC) are included in this match. Those students who were found as enrolled in postsecondary institutions within 16 months of the date of graduation, the students were flagged as having enrolled in postsecondary institutions.

  • For those students flagged as enrolled (in step 2 above), CPEC then determined whether or not, within the two-year time frame after postsecondary enrollment, the student completed one year of credit. One year of credit is defined as 24 semester units for UC and CSU students, and a student status of sophomore for CCC students.

  • The CPEC returned electronic data files to the CDE with the following indicators:
  • Students that enrolled in a California public postsecondary institution within 16 months of graduation.
  • Students from (a.) that earned one-year of credit within two years of enrolling in a California public institution.

  • The CDE produced the school-, district-, county-level and statewide reports.

Disclaimers on the accuracy of Indicator C12

Most likely, the numbers and percentages of students represented in this report are underestimated. Below is a list of reasons for the possible underestimations.

  • CPEC match process: The CPEC used both deterministic and probabilistic algorithms to match students. A student may provide a slightly different version of his or her name to different educational agencies and institutions. Depending on how variant the name is, the match may not be a strong match and, as a result, the student will not be indicated as enrolled in a postsecondary institution. The CDE data separates student name into first name, middle name and last name columns. The postsecondary data (as of 9/1/2011) does not have consistent name data: UC – Name is in a single column. CSU – Name is in a single column. CCC – Name is in two columns, but the length of each column is three characters, and as such, virtually all names are cut short.

  • Students with misspelled names, nicknames or names with alternate spellings may not be identified. Hyphenated last names and last names consisting of multiple names may not be identified.

  • The CDE data includes a statewide student identifier (SSID) but does not include SSN because of state law. All postsecondary data includes SSN, but it is optional or missing for some students. Therefore, the match must be made by name, graduating high school code, gender, birthdate and ethnicity/race. A number of CDE high school graduates were identified in the postsecondary data but they did not use an SSN. These students cannot be tracked through their postsecondary career.

  • Students enrolling at community colleges located outside of their home district are frequently coded as coming from an "Unknown High School." Many of these students cannot be matched because they have similar names to other students.
Questions: Data Reporting Office | dro@cde.ca.gov | 916-327-0219 
Last Reviewed: Monday, August 22, 2016