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: Data Reporting Office | dro@cde.ca.gov | 916-327-0219 
Last Reviewed: Wednesday, June 26, 2024
Trending in Accessing Educational Data
Recently Posted in Accessing Educational Data
  • DataQuest Schedule (added 20-Jun-2024)
    An overview of the DataQuest reports expected to be released in the coming year.
  • DataQuest Update, Issue #20 (added 17-May-2024)
    DataQuest is an online data reporting resource that provides access to a wide variety of data reports and downloadable data files.
  • File Structure: CBEDS by Race/Ethnic & Gender 2023 (added 16-May-2024)
    File structure for CBEDS data by race/ethnicity, gender, and school for 2023-24. Data include classified staff and home-to-school transportation data.
  • File Structure: CBEDS Data About Schools/Districts (added 16-May-2024)
    File structure for California Basic Educational Data System (CBEDS) data about schools and districts for 2023.
  • File Structure: Census Day Enrollment Data (added 16-May-2024)
    File structure for downloadable files containing Census Day TK/K–12 enrollment data from the California Longitudinal Pupil Achievement Data System (CALPADS) disaggregated by grade, race/ethnicity, gender, and other student details.