Skip to content
Printer-friendly version

File Structure: Staff Demographics 1997 & 1998

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: PAIF98.DBF

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
Field Type Width
Description

REC_ID

Character

6

This 6-digit code is the unique record identification code assigned to each certificated staff member in California public schools for this specific year. The code is an identifier with no meaning. The code assigned to a record for this specific year will not match the code assigned to the same staff members' record for prior or future years. 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

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

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:

  • 1 = American Indian or Alaska Native
  • 2 = Asian
  • 3 = Pacific Islander
  • 4 = Filipino
  • 5 = Hispanic or Latino
  • 6 = African American, not Hispanic (formerly known as Black, not Hispanic)
  • 7 = White, not Hispanic
  • 8 = Multiple or No Response

(See Glossary for complete definitions of the racial/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

OVER_100

Logical

1

Indicates teacher is paid to teach in excess of the districts' full-time teaching position (i.e., an extra period or more). Does not include mentor teacher, coaching, adult education, ROP, department chair, or non-teaching assignments.
The field is coded as follows:

  • T = True
  • F = False

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

F_P_TIME

Character

1

Indicates whether the position is Full or Part time as defined by the district. For Part time employees, see field PERC_TIME below for percentage of full time position held.
The field is coded as follows:

  • F = Full time
  • P = Part time

PERC_TIME

Numeric

4

Indicates percent of full or part time position reported in field F_P_TIME above.
The field is coded as follows:

  • F = Full time
  • P = Part time

FULL_CRED

Logical

1

Completed a teacher preparation program and holds a preliminary, clear, professional clear, or life credential
The field is coded as follows:

  • T = True
  • F = False

UNIT_INT

Logical

1

University credential program in which the intern is enrolled in the University taking coursework while teaching
The field is coded as follows:

  • T = True
  • F = False

DIST_INT

Logical

1

District credential program in which interns participate in preparation that includes staff development, but may not include college coursework
The field is coded as follows:

  • T = True
  • F = False

EMERGENCY

Logical

1

Requested by an employer on behalf of an individual who does not qualify for a credential or internship but meets minimum certification requirements. The permit holder completes credential requirements through a college or university for renewal.
The field is coded as follows:

  • T = True
  • F = False

WAIVER

Logical

1

Requested by an employer on behalf of an individual when the employer is unable to find credentialed teachers or individuals who qualify for an emergency permit.
The field is coded as follows:

  • T = True
  • F = False

ELEM

Logical

1

Indicates the teaching credential held by the certificated staff member. Authorizes teaching in an elementary/self-contained classroom
The field is coded as follows:

  • T = True
  • F = False

SEC

Logical

1

Authorized teaching area for a secondary/subject-specific classroom
The field is coded as follows:

  • T = True
  • F = False

GEN_SEC

Logical

1

Authorized teaching area for general secondary (all subjects)
The field is coded as follows:

  • T = True
  • F = False

AGRI

Logical

1

Authorized teaching area for agriculture
The field is coded as follows:

  • T = True
  • F = False

ART

Logical

1

Authorized teaching area for art
The field is coded as follows:

  • T = True
  • F = False

BUSINESS

Logical

1

Authorized teaching area for business
The field is coded as follows:

  • T = True
  • F = False

ENGLISH

Logical

1

Authorized teaching area for English
The field is coded as follows:

  • T = True
  • F = False

FOR_LANG

Logical

1

Authorized teaching area for foreign language
The field is coded as follows:

  • T = True
  • F = False

HEALTH

Logical

1

Authorized teaching area for health
The field is coded as follows:

  • T = True
  • F = False

HOME_ECON

Logical

1

Authorized teaching area for home economics
The field is coded as follows:

  • T = True
  • F = False

IND_TECH

Logical

1

Authorized teaching area for industrial and technology
The field is coded as follows:

  • T = True
  • F = False

LIFE_SCI

Logical

1

Authorized teaching area for life science
The field is coded as follows:

  • T = True
  • F = False

MATH

Logical

1

Authorized teaching area for mathematics
The field is coded as follows:

  • T = True
  • F = False

MUSIC

Logical

1

Authorized teaching area for music
The field is coded as follows:

  • T = True
  • F = False

PHYS_ED

Logical

1

Authorized teaching area for physical education
The field is coded as follows:

  • T = True
  • F = False

PHYS_SCI

Logical

1

Authorized teaching area for physical science
The field is coded as follows:

  • T = True
  • F = False

SOC_SCI

Logical

1

Authorized teaching area for social science
The field is coded as follows:

  • T = True
  • F = False

VOC

Logical

1

Authorized teaching area for vocational
The field is coded as follows:

  • T = True
  • F = False

SPEC_ED

Logical

1

Authorized teaching area for special education specialist
The field is coded as follows:

  • T = True
  • F = False

READING

Logical

1

Authorized teaching area for reading specialist
The field is coded as follows:

  • T = True
  • F = False

BCC

Logical

1

Authorized teaching area for bilingual
The field is coded as follows:

  • T = True
  • F = False

ELD

Logical

1

Authorized teaching area for English language development
The field is coded as follows:

  • T = True
  • F = False

SDAIE

Logical

1

Authorized teaching area for specially designed academic instruction in English
The field is coded as follows:

  • T = True
  • F = False

ADULT

Logical

1

Authorized teaching area for adult education
The field is coded as follows:

  • T = True
  • F = False
Questions: Data Reporting Office | dro@cde.ca.gov | 916-327-0219 
Download Free Readers