Skip to main content
California Department of Education Logo

File Structure: Course Data 2001–02

File structure for statewide course data Including course enrollment, grade level, and UC/CSU indicator.

File Name: paifc01.exe and paifc02.exe

Field Name Field Type 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.

ASN_CODE

Character

4

This is a 4-digit code from the "Assignment Code List" that identifies a course taught or other assignment for certificated staff (teachers, administrators and pupil services staff).

M_ENROLL

Numeric

3

Male enrollment in this class.

F_ENROLL

Numeric

3

Female enrollment in this class.

GD_LEV

Character

1

Grade level of majority of students in this class. This field is coded as follows:

  • A = Kindergarten through grade three
  • B = Grade four
  • C = Grade five
  • D = Grade six
  • E = Grade seven
  • F = Grade eight
  • G = Grade nine
  • H = Grade ten
  • I = Grade eleven
  • J = Grade twelve
  • K = Multiple grades, no majority (kindergarten through grade eight)
  • L = Multiple grades, no majority (grades nine through twelve)
  • Blank = No response

UC_CSU

Character

1

Course designated as meeting the University of California (UC) / California State University (CSU) requirements for admission. This field is coded as follows:

  • Y = True
  • N = False
  • Blank = No response
Questions: Data Reporting Office | dro@cde.ca.gov | 916-327-0219 
Last Reviewed: Friday, August 19, 2016
Recently Posted in Demographics
  • Dropouts by Race & Gender (updated 11-Apr-2017)
    Downloadable data files for grade seven through twelve dropouts and enrollment by race/ethnic designation and gender by school.
  • Graduates by Ethnicity and School (updated 11-Apr-2017)
    Downloadable data files for graduates by racial/ethnic group and school.
  • Graduates Meeting UC/CSU Entrance Requirements (updated 11-Apr-2017)
    Downloadable data files for graduates meeting University of California/California State University (UC/CSU) entrance requirements.
  • Graduates by Race & Gender (updated 11-Apr-2017)
    Downloadable data files for graduates and graduates meeting University of California (UC)/California State University (CSU) entrance requirements by race/ethnic designation and gender by school.
  • Cohort Outcome Data (updated 11-Apr-2017)
    California Longitudinal Pupil Achievement Data System (CALPADS) cohort outcome data reported by race/ethnicity, program participation, and gender.

  • Transitional Kindergarten Data (updated 16-Mar-2017)
    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).
  • Classified Staff by Race/Ethnicity & Gender (updated 10-Mar-2017)
    Downloadable data files for classified staff by race/ethnicity, gender, and school for 2008–09 through current year.