Skip to main content
California Department of Education Logo

File Structure: Staff Assignments 2001–02

File structure for statewide assignment information including type of staff and time base.

File Name: paifa01.exe and paifa02.exe

Field Name Field Type Width Description

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.

REC_ID

Character

6

This 6-digit code is the unique record identification code assigned to each certificated staff member in California public schools. The code is an identifier with no meaning. The code assigned to a record for any particular 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.

ASN_CODE

Character

4

This 4-digit code is from an extensive list of assignment code numbers for teaching assignments, administrative assignments and pupil services assignments. For a list of all codes and course and assignment titles, use the assignment code file posted on the California Department of Education Staff Assignment and Course Data Web page.

ASN_PCT

Numeric

3

This field indicates the percent of time certificated staff spends "on the job" devoted to each assignment. It does not represent "total" time spent on the job.

CTYPE

Character

1

Type of assignment.

  • T = Teaching assignment
  • A = Administrative assignment
  • P = Pupil services assignment
Questions: Data Reporting Office | dro@cde.ca.gov | 916-327-0219 
Last Reviewed: Tuesday, August 28, 2018
Recently Posted in Demographics
  • File Structure: Classified Staff 2018 (added 02-Aug-2019)
    File structure for classified staff data by race/ethnicity, gender, and school for 2018–19.
  • File Structure: CBEDS Data About Schools/Districts (added 02-Aug-2019)
    File structure for California Basic Educational Data System (CBEDS) data about schools and districts for 2018–19.
  • File Structure: CGR Data (12-Month) (added 11-Jul-2019)
    File structure for the College-Going Rate (CGR) 12 months after high school completion reported by race/ethnicity, student group, and academic year.
  • File Structure: CGR Data (16-Month) (added 11-Jul-2019)
    File structure for the College-Going Rate (CGR) 16 months after high school completion reported by race/ethnicity, student group, and academic year.
  • Using the CGR Data File (added 11-Jul-2019)
    This page explains how to effectively use the sub-setting variables included in this CGR data file to obtain the desired counts.