Skip to main content
California Department of Education Logo

Staff Assignment and Course Data

Downloadable data files for course information (e.g., course enrollment, grade level, UC/CSU indicator, and NCLB core and compliant status) as well as assignment information (e.g., type of staff and time base).

Note that Local Educational Agencies (LEAs) are not required to submit demographic and Full Time Equivalent (FTE) information for staff that do not have Statewide Educator Identifiers (SEID). Following are examples of when this might occur:

  • Non-certificated charter school teachers.
  • Teachers delivering courses at a Regional Occupational Center.
  • College professors delivering college courses to high school students.
  • Teachers delivering online courses provided by a public or private agency.
  • New teachers who have not been issued a SEID.

Therefore course and course enrollment data will be available for these types of classes, but staff demographic and FTE data will not.

Beginning in 2012–13, staffing assignment and course data (first table below) have been re-organized and enhanced to include more detailed data about enrollment as well as information about classes that have more than one subject content area. A Staff Data - Entity Relationship Diagram (PDF) diagram is provided to help users understand the new organization of files associated with staff demographics, credentials, courses taught, and course enrollment. Accessible Alternate Version (AAV) of the Staff Data - Entity Relationship Diagram

Staff Assignment / Class Section / Class Section Enrollment Downloadable Data Files
Year of Data File File Structure Number of Records
2012–13 On AssignmentCodes12On (XLSX; Revised 18-Nov-2019) File Structure: Assignment Code 12 On
1,150
2018–19 StaffAssign18.zip (23MB; Posted 18-Nov-2019) File Structure: Staff Assignment 201213 to Current 1,269,836
2018–19 CoursesTaught18.zip (20MB; Posted 18-Nov-2019) File Structure: Courses Taught 201213 to Current 1,183,573
2018–19 CourseEnrollment18.zip (59MB; Posted 18-Nov-2019) File Structure: Course Enrollment FTE 201213 to Current 3,228,250
2018–19 ClassEnrollment18.zip (21MB; Revised 6-Jan-2020) File Structure: Class Enrollment FTE 201213 to Current 1,724,092
2017–18 StaffAssign17.zip (22MB; Posted 16-Jul-2018) File Structure: Staff Assignment 201213 to Current 1,235,706
2017–18 CoursesTaught17.zip (19MB; Posted 16-Jul-2018) File Structure: Courses Taught 201213 to Current 1,154,350
2017–18 CourseEnrollment17.zip (58MB; Posted 16-Jul-2018) File Structure: Course Enrollment FTE 201213 to Current 3,174,700
2017–18 ClassEnrollment17.zip (58MB; Posted 16-Jul-2018) File Structure: Class Enrollment FTE 201213 to Current 1,716,983
2016–17 StaffAssign16.zip (13MB; Posted 21-Sep-2017) File Structure: Staff Assignment 201213 to Current 1,229,237
2016–17 CoursesTaught16.zip (21MB; Posted 21-Sep-2017) File Structure: Courses Taught 201213 to Current 1,150,342
2016–17 CourseEnrollment16.zip (40MB; Revised 21-Dec-2017) File Structure: Course Enrollment FTE 201213 to Current 3,157,403
2016–17 ClassEnrollment16.zip (18MB; Revised 21-Dec-2017) File Structure: Class Enrollment FTE 201213 to Current 1,706,437
2015–16 StaffAssign15.zip (12MB; Posted 22-May-2017) File Structure: Staff Assignment 201213 to Current 1,155,998
2015–16 CoursesTaught15.zip (19MB; Posted 22-May-2017) File Structure: Courses Taught 201213 to Current 1,077,128
2015–16 CourseEnrollment15.zip (64MB; Posted 22-May-2017) File Structure: Course Enrollment FTE 201213 to Current 3,061,709
2015–16 ClassEnrollment15.zip (20MB; Posted 22-May-2017) File Structure: Class Enrollment FTE 201213 to Current 1,670,107
2014–15 StaffAssign14.zip (11MB; Posted 28-Oct-2015) File Structure: Staff Assignment 201213 to Current
1,142,660
2014–15 CoursesTaught14.zip (19MB; Posted 28-Oct-2015) File Structure: Courses Taught 201213 to Current
1,061,531
2014–15 CourseEnrollment14.zip (64MB; Posted 28-Oct-2015) File Structure: Course Enrollment FTE 201213 to Current
2,981,687
2014–15 ClassEnrollment14.zip (25MB; Posted 12-Feb-2016) File Structure: Class Enrollment FTE 201213 to Current 1,590,864
2013–14 StaffAssign13.zip (11MB; Revised 20-Aug-2015) File Structure: Staff Assignment 201213 to Current
1,115,612
2013–14 CoursesTaught13.zip (19MB; Revised 20-Aug-2015) File Structure: Courses Taught 201213 to Current
1,034,496
2013–14 CourseEnrollment13.zip (63MB; Revised 20-Aug-2015) File Structure: Course Enrollment FTE 201213 to Current
2,933,287
2013–14 ClassEnrollment13.zip (24MB; Posted 12-Feb-2016) File Structure: Class Enrollment FTE 201213 to Current
1,605,081
2012–13 StaffAssign12.zip (11MB; Revised 20-Aug-2015) File Structure: Staff Assignment 201213 to Current
1,107,251
2012–13 CoursesTaught12.zip (18MB; Revised 20-Aug-2015) File Structure: Courses Taught 201213 to Current
1,030,070
2012–13

CourseEnrollment12.zip (63MB; Revised 20-Aug-2015)

File Structure: Course Enrollment FTE 201213 to Current
2,929,057
2012–13

ClassEnrollment12.zip (24MB; Posted 12-Feb-2016)

File Structure: Class Enrollment FTE 201213 to Current 1,638, 658
Prior Years Downloadable Data Files

The table below includes course information (e.g., course enrollment, grade level, University of California/California State University (UC/CSU) indicator, and No Child Left Behind Act of 2001 (NCLB) core and compliant status) as well as assignment information (e.g., type of staff and time base).

Year of Data File File Structure Number of Records

Up to 2011–12

Assignment Code File (TXT; Updated 27-Oct-2011) | DBF File Structure: Assignment Code File
1,032

2011–12

assign11 (TXT; 123MB; Posted 05-Apr-2013) File Structure: Course Data 2010–11
1,039,972
2010–11 assign10 (TXT; 110MB; Modified 16-Mar-2012) File Structure: Course Data 2010–11
969,265

Instructions: Click on the file name you wish to download and save the file to your computer. To view the file, import and open the file in a database or spreadsheet program.

Questions: Data Reporting Office | dro@cde.ca.gov | 916-327-0219 
Last Reviewed: Thursday, April 29, 2021
Recently Posted in Accessing Educational Data
  • File Structure: Stability Rate Data (added 25-Oct-2021)
    File structure for downloadable files containing student stability data disaggregated by race/ethnicity, gender, student group, and grade level. Adjusted cumulative enrollment counts, stability and non-stability counts and rate data are provided.
  • Information about the Stability Rate Report (added 25-Oct-2021)
    High-level overview of the School Stability Rate data sources, DataQuest reports, downloadable data files, definitions, and business rules helpful to understanding the data reports and downloadable data files.
  • Stability Rate Data (added 25-Oct-2021)
    Reports and data about student stability, including adjusted cumulative enrollment counts, stability and non-stability counts, and stability and non-stability rates disaggregated by race/ethnicity, gender, student group, and grade level.
  • Stability Rate Downloadable Data Files (added 25-Oct-2021)
    Downloadable data files about stability rate data disaggregated by race/ethnicity, gender, student group, and grade level. Adjusted cumulative enrollment counts, stability and non-stability counts and rates are provided.