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
4

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
7
 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
7
 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
7

This 7-digit code is the official, unique identification of a school within California.
CountyName Character
15
 County name.
DistrictName Character
50
 District name.
SchoolName Character
50
 School name.
JobClassification Character
1

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
1

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

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

 

Questions:   Analysis Measurement & Accountability Reporting Division | dro@cde.ca.gov
Last Reviewed: Wednesday, October 30, 2024
Trending in Accessing Educational Data
Recently Posted in Accessing Educational Data
  • DataQuest Update, Issue #24 (added 17-Jul-2025)
    DataQuest is an online data reporting resource that provides access to a wide variety of data reports and downloadable data files.
  • Information about the Staff Experience Data (added 17-Jul-2025)
    Overview of the Staff Experience data, including data sources, DataQuest reports, downloadable files, definitions, and other information helpful to understanding the data, reports, and downloadable files.
  • Information about the Staff Race/Ethnicity Data (added 17-Jul-2025)
    Overview of the Staff Race/Ethnicity data, including data sources, DataQuest reports, downloadable files, definitions, and other information helpful to understanding the data, reports, and downloadable files.
  • Student/Staff Ratios Downloadable Data Files (added 17-Jul-2025)
    Downloadable data files about student/staff ratios as of Census Day disaggregated by staff type, academic year, and school grade span.
  • Staff Experience Downloadable Data Files (added 17-Jul-2025)
    Downloadable data files about certificated staff employed on Census Day disaggregated by years of experience, academic year, staff type, school grade span, and gender.

  • File Structure: Staff Race/Ethnicity Data (added 17-Jul-2025)
    File structure for downloadable data files containing Certificated Staff by Race/Ethnicity disaggregated by academic year, staff type, school grade span, and gender.
  • File Structure: Staff Experience Data (added 17-Jul-2025)
    File structure for downloadable data files containing Certificated Staff Experience disaggregated by academic year, staff type, school grade span, and gender.
  • File Structure: Staff Education Data (added 17-Jul-2025)
    File structure for downloadable data files containing Certificated Staff Education disaggregated by academic year, staff type, school grade span, and gender.
  • Staff Counts by Experience (added 17-Jul-2025)
    Reports and data about certificated staff employed on Census Day disaggregated by years of experience, academic year, staff type, school grade span, and gender.
  • Staff Counts by Education (added 17-Jul-2025)
    Reports and data about certificated staff employed on Census Day disaggregated by education level, academic year, staff type, school grade span, and gender.