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




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.




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.




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.




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.




Type of assignment.

  • T = Teaching assignment
  • A = Administrative assignment
  • P = Pupil services assignment
Questions: Data Reporting Office | | 916-327-0219 
Last Reviewed: Friday, August 19, 2016
Recently Posted in Demographics
  • File Structure: Staff Demographics Record (added 22-May-2017)
    File structure for the staff demographics record, which includes demographic and full-time equivalent (FTE) data for K-12 public education certificated teachers, administrators, and pupil services personnel reported as employed on Information Day.
  • Dropouts by Race & Gender (updated 11-Apr-2017)
    Downloadable data files for grade seven through twelve dropouts and enrollment by race/ethnic designation and gender by school.
  • Graduates by Ethnicity and School (updated 11-Apr-2017)
    Downloadable data files for graduates by racial/ethnic group and school.
  • Graduates Meeting UC/CSU Entrance Requirements (updated 11-Apr-2017)
    Downloadable data files for graduates meeting University of California/California State University (UC/CSU) entrance requirements.
  • Graduates by Race & Gender (updated 11-Apr-2017)
    Downloadable data files for graduates and graduates meeting University of California (UC)/California State University (CSU) entrance requirements by race/ethnic designation and gender by school.

  • Cohort Outcome Data (updated 11-Apr-2017)
    California Longitudinal Pupil Achievement Data System (CALPADS) cohort outcome data reported by race/ethnicity, program participation, and gender.