Skip to main content
California Department of Education Logo

File Structure: Staff Demographics 2009

File structure for statewide staff demographics, such as, gender, race/ethnicity, education level, and years of service for teachers, administrators, and pupil services staff.

File Name: paif09.txt

Note: This file contains hundreds of thousands of records and must be read by high powered database software (i.e., Access, Dbase, Foxpro, etc.). This file cannot be read by a software that limits the number of records that can be read (i.e., Excel).

Field Name Type Field Width Description

REC_ID

Character

10

This code is the District Assigned Staff Identification Number (DASIN) reported by the district. The code assigned for one year may not be the same code assigned to the same staff member for another year. Therefore, the code cannot be used to match records over time.

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.

GENDER

Character

1

This field is a coded field identifying gender. The gender is coded as follows:

  • M = Male
  • F = Female
  • Null or Blank = Not reported

ED_LEVEL

Character

1

This is a coded field for staff member's highest educational level (honorary degrees not included). The highest educational levels are coded as follows:

  • 1 = Doctorate
  • 2 = Master's degree plus 30 or more semester hours
  • 3 = Master's degree
  • 4 = Bachelor's degree plus 30 or more semester hours
  • 5 = Bachelor's degree
  • 6 = Less than bachelor's degree
  • 7 - Not reported

ETHNIC_GP

Character

1

This is a coded field for staff member's racial/ethnic designation. The code indicates the racial or ethnic designation to which the certificated staff belongs or with which he/she most closely identifies.

The racial/ethnic designations are coded as follows:

  • 0 = Not reported
  • 1 = American Indian or Alaska 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 (formerly known as Black, not Hispanic)
  • 7 = White, not Hispanic
  • 8 = Two or More Races, Not Hispanic

(See Glossary for complete definitions of the ethnic groups).

YRS_TEACH

Numeric

3

Total years of public and/or private educational service. Includes services in this district, other districts, other states, and countries. Does not include substitute teaching or classified staff service. The first year of service is counted as 1 year.

YRS_DIST

Numeric

3

Total years of service in a certificated position in the district. The first year of service is counted as 1 year

STATUS

Character

1

Indicates whether the teacher's position is tenured, probationary, or long-term substitute or temporary employee.
The field is coded as follows:

  • L = Long term substitute or temporary employee
  • P = Probationary
  • T = Tenured
  • O = Other
  • Blank = Not reported

TEACH

Decimal

1, 2

An employee of the school district who holds a position requiring certification and whose duties require direct instruction to the pupils in the school(s) of that district.

Full-time equivalent (FTE) percentage of teachers.

ADMIN

Decimal

1, 2

An employee of the district in a position requiring certification but who is not required to provide direct instruction to pupils or direct services to pupils.

FTE percentage of administrators.

PUPIL

Decimal

1, 2

An employee of the district in a position requiring a standard designated services credential, health, development credential, or a librarian credential and who performs direct services to pupils (e.g., counselors, guidance and welfare personnel, librarians, psychologists, etc.).

FTE percentage of pupil services.

Questions: Data Reporting Office | dro@cde.ca.gov | 916-327-0219 
Last Reviewed: Monday, December 9, 2019
Recently Posted in Demographics
  • DataQuest Update Issue #6 (added 01-Sep-2020)
    DataQuest is an online data reporting resource that provides access to a wide variety of data reports and downloadable data files.
  • Cumulative Enrollment Data (added 01-Sep-2020)
    Downloadable data files containing annual cumulative enrollment data by race/ethnicity, gender, and program subgroup.
  • File Structure: Cumulative Enrollment Data (added 01-Sep-2020)
    File structure for downloadable files containing cumulative enrollment data by race/ethnicity, gender, and program subgroup.
  • File Structure: Foster Youth Test Results (added 24-Aug-2020)
    File structure for the downloadable files containing Foster Youth Smarter Balanced Test Results data by race/ethnicity, gender, student program subgroup, and grade level for 2014–15 through 2018–19.
  • Foster Youth Smarter Balanced Test Results Data (added 24-Aug-2020)
    Downloadable data file of Smarter Balanced Math and English Language Arts (ELA) test results data for foster youth by race/ethnicity, gender, student program subgroup, and grade level.