Skip to content
Printer-friendly version

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 
Download Free Readers