Skip to main content
California Department of Education Logo

File Structure: Certificated Staff Profile

File structure for California Basic Educational Data System (CBEDS) Professional Assignment Information Form (PAIF) certificated staff for school, district, county, and state levels for years 1999 through the current year.

File Name: PRCERTnn.EXE

Field Name Field Type Width
Description

CDS_CODE

Character

14

County-District-School identification code.

COUNTY

Character

15

County name.

DISTRICT

Character

30

District name.

SCHOOL

Character

30

School name.

TOT_CERTIF

Numeric

6

Total count of certificated staff.

AVG_AGE

Numeric

5

Average age.

AVG_DSTYRS

Numeric

5

Average years of educational service in this district.

AVG_TOTYRS

Numeric

5

Average total years of educational service.

PCT_MALE

Numeric

5

Percent male.

PCT_FEML

Numeric

5

Percent female.

PCT_PHD

Numeric

5

Percent with doctorate.

PCT_MA30

Numeric

5

Percent with master's degree plus 30 or more semester units.

PCT_MA

Numeric

5

Percent with master's degree.

PCT_BA30

Numeric

5

Percent with bachelor's degree plus 30 or more semester units.

PCT_BA

Numeric

5

Percent with bachelor's degree.

PCT_LESSBA

Numeric

5

Percent with less than a bachelor's degree.

PCT_AM_IND

Numeric

5

Percent American Indian or Alaskan Native.

PCT_ASIAN

Numeric

5

Percent Asian.

PCT_PACISL

Numeric

5

Percent Pacific Islander.

PCT_FILPN

Numeric

5

Percent Filipino.

PCT_HISPN

Numeric

5

Percent Hispanic.

PCT_BLACK

Numeric

5

Percent Black (not Hispanic).

PCT_WHITE

Numeric

5

Percent White (not Hispanic).

PCT_MULT

Numeric

5

Percent Multiple or no response.

FTE_ADMIN

Numeric

9

Full-time equivalent* (FTE) administrators.

FTE_PUPSVC

Numeric

9

FTE* pupil services staff.

FTE_TEACH

Numeric

9

FTE* teachers.

*FTE calculation: the sum of the percent of full-time positions (represented as a decimal)

Questions: Data Reporting Office | dro@cde.ca.gov | 916-327-0219 
Last Reviewed: Monday, August 22, 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.