Skip to main content
California Department of Education Logo

File Structure: Staff School FTE

This table contains the structure for the staff school FTE record. This file contains job classification and FTE data for each teacher at a school. There is one record for every staff member and job classification in a school or school district.


Field Name Type Field Width Description
AcademicYear Character

Academic year for the data. This data is collected on the first Wednesday in October. For example '1415' would indicate that the Academic school year is 2014–2015 and the data was collected in October 2014.

RecID Character
This code is a randomly generated number assigned to each staff. 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.
DistrictCode Character
This 7-digit code is the official, unique identification of a school district or county office within California. The first two digits identify the county and the next five digits identify the school district.
SchoolCode Character

This 7-digit code is the official, unique identification of a school within California.

CountyName Character
County name.
DistrictName Character
District name.
SchoolName Character
School name.
JobClassification Character

A coded value representing the Educational Service Job Classification. An Educational Service Job Classification is the classification of a specific occupation of an individual, such as teacher, administrator, and pupil services.

  • 10 = Administrator
  • 11 = Pupil services
  • 12 = Teacher
  • 25 = Non-certificated Administrator
  • 26 = Charter School Non-certificated Teacher
  • 27 = Itinerant or Pull-Out/Push-In Teacher
StaffType Character

This code indicates the type of staff assignment in the record. The field is coded as follows:

  • A = Administrator
  • P = Pupil services
  • T = Teacher
Full-time equivalent (FTE) teaching duties. A value of 100 represents one full time equivalent. A value of 50 represents one half FTE.
Date that the file was created.


Questions: Data Reporting Office | | 916-327-0219 
Last Reviewed: Friday, August 11, 2023
Recently Posted in Accessing Educational Data
  • DataQuest Update, Issue #19 (added 02-Feb-2024)
    DataQuest is an online data reporting resource that provides access to a wide variety of data reports and downloadable data files
  • File Structure: SPED Data by Program Setting (added 30-Jan-2024)
    File structure for downloadable files containing Special Education (SPED) Enrollment by Program Setting data disaggregated by race/ethnicity, disability category, age range, grade span, gender, and English learner status.