Skip to main content
California Department of Education Logo

File Structure: Certificated Profile 1994–98

File structure for California Basic Educational Data System (CBEDS) Professional Assignment Information Form (PAIF) certificated staff profile for school, district, county, and state levels.

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: Friday, September 13, 2019
Recently Posted in Demographics
  • DataQuest Update 4 (added 24-Feb-2020)
    DataQuest Update 4, January 2020, Release of New Data
  • DataQuest Update Issue #2 (added 03-Feb-2020)
    The DataQuest Update is intended to keep DataQuest users informed about upcoming data releases, new reports and downloadable data files, enhancements and changes to DataQuest, and provide tips on how to use DataQuest
  • DataQuest Update Issue #1 (added 03-Feb-2020)
    The DataQuest Update is intended to keep DataQuest users informed about upcoming data releases, new reports and downloadable data files, enhancements and changes to DataQuest, and provide tips on how to use DataQuest
  • DataQuest Update Issue #3 (added 03-Feb-2020)
    The DataQuest Update is intended to keep DataQuest users informed about upcoming data releases, new reports and downloadable data files, enhancements and changes to DataQuest, and provide tips on how to use DataQuest
  • File Structure: One-Year Graduate Counts (added 29-Jan-2020)
    File structure for downloadable data files for one-year graduates by race/ethnicity, student program subgroup, and gender.