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