Skip to content
Printer-friendly version

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

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

All Years Assignment Code File (TXT; Updated 27-Oct-2011) | DBF File Structure: Assignment Code File 1,032
2012–13 staffassign12.zip (14MB; Revised 03-Jan-2014) File Structure: Staff Assignment 201213 1,105,533
2012–13 classsection12.zip (10MB; Revised 18-Dec-2013) File Structure: Class Section 201213 1,037,452
2012–13

classsectionenroll12.zip 35MB; Revised 18-Dec-2013)

File Structure: Class Section Enrollment 201213 2,915,949
Prior Years Downloadable Data Files

The table below includes 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).

Year of Data

File

File Structure

Number of Records

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
2009–10 Data not available for this year. N/A N/A

200809

assign08 (DBF; 54MB; Modified* 02-Feb-2010)

File Structure: Course Data 2005–08

950,418

200708

assign07 (DBF 102 MB; Modified* 27-Jan-2009) File Structure: Course Data 2005–08

963,791

200607

assign06 (DBF; 53MB; Posted 03-Jul-2007) File Structure: Course Data 2005–08

933,878

200506

assign05 (DBF; 48MB; Posted 09-Mar-2007) File Structure: Course Data 2005–08

905,090

200405

assign04 (DBF; 40MB; Modified* 04-Aug-2005) File Structure: Course Data 2000, 2003, & 2004

895,308

200304

assign03 (DBF; 45MB; Posted 27-Jul-2004) File Structure: Course Data 2000, 2003, & 2004

877,630

200203**

assigna02 (DBF; 25MB; Modified* 29-Jul-2003) File Structure: Staff Assignments 2001 & 2002

879,184

200203**

assignc02 (DBF; 21MB; Posted 27-Jun-2003)

File Structure: Course Data 2001 & 2002

815,045

200102**

assigna01 (DBF; 24MB; Modified* 31-Dec-2002) File Structure: Staff Assignments 2001 & 2002

864,843

200102**

assignc01 (DBF; 23MB; Modified* 31-Dec-2002) File Structure: Course Data 2001 & 2002

871,765

20002001

assign00 (DBF; 43MB; Posted 07-Jun-2001) File Structure: Course Data 2000, 2003, & 2004

851,359

19992000

assign99 (DBF; 42MB; Posted 12-Jul-2000) File Structure: Course Data 1999

826,748

199899

assign98 (DBF; 43MB; Posted 24-Sept-1999) File Structure: Course Data 1997 & 1998

790,598

199798

assign97 (DBF; 39MB; Posted 23-Mar-2000) File Structure: Course Data 1997 & 1998

763,511

Files are in either a tab delimited text file or a database/spreadsheet format (.dbf). To use a file: (1) click and download; (2) from Windows Explorer, double click on the file name; (3) to view the file, open the uncompressed file (.dbf) in a database or spreadsheet program. For further instructions choose a link below or contact our office for assistance.

Special instructions for Excel and Access users

*For details on specific file modifications, refer to the File Modifications Web page.

** For 200102 and 200203, PAIF data are collected in such a way that does not allow staff data to be linked to some of the assignment data. Consequently, the "ASSIGNnn" file format was not used for these years.

Questions: Data Reporting Office | dro@cde.ca.gov | 916-327-0219 
Download Free Readers