Year of Data |
File |
File Structure |
Number of Records |
|---|---|---|---|
| All Years | Assignment Code File (Updated 27-Oct-2011; TXT; 104KB) | DBF (199KB) | File Structure: Assignment Code File | 1,032 |
| 2010-11 | assign10.txt (Modified* 16-Mar-2012; TXT; 110MB) | File Structure: Course Data 2010 | 969,265 |
| 2009-10 | NA | NA | NA |
2008-09 |
assign08.dbf (Modified* 02-Feb-2010; DBF; 54MB) | File Structure: Course Data 2005-08 | 950,418 |
2007-08 |
assign07.dbf (Modified* 27-Jan-2009; DBF: 102 MB) | File Structure: Course Data 2005-08 | 963,791 |
2006-07 |
assign06.dbf (Posted 03-Jul-2007; DBF; 53MB) | File Structure: Course Data 2005-08 | 933,878 |
2005-06 |
assign05.dbf (Posted 09-Mar-2007; DBF; 48MB) | File Structure: Course Data 2005-08 | 905,090 |
2004-05 |
assign04.exe (Modified* 04-Aug-2005; EXE; 6MB) | File Structure: Course Data 2000, 2003, & 2004 | 895,308 |
2003-04 |
assign03.exe (Posted 27-Jul-2004; EXE; 6MB) | File Structure: Course Data 2000, 2003, & 2004 | 877,630 |
2002-03** |
assigna02.exe (Modified* 29-Jul-2003; EXE; 2MB) | File Structure: Staff Assignments 2001 & 2002 | 879,184 |
2002-03** |
assignc02.exe (Posted 27-Jun-2003; EXE; 3MB) | 815,045 |
|
2001-02** |
assigna01.exe (Modified* 31-Dec-2002; EXE; 2MB) | File Structure: Staff Assignments 2001 & 2002 | 864,843 |
2001-02** |
assignc01.exe (Modified* 31-Dec-2002; EXE; 3MB) | File Structure: Course Data 2001 & 2002 | 871,765 |
2000-2001 |
assign00.exe (Posted 07-Jun-2001; EXE; 7MB) | File Structure: Course Data 2000, 2003, & 2004 | 851,359 |
1999-2000 |
assign99.exe (Posted 12-Jul-2000; EXE; 5MB) | File Structure: Course Data 1999 | 826,748 |
1998-99 |
assign98.exe (Posted 24-Sept-1999; EXE; 5MB) | File Structure: Course Data 1997 & 1998 | 790,598 |
1997-98 |
assign97.exe (Posted 23-Mar-2000; EXE; 5MB) | File Structure: Course Data 1997 & 1998 | 763,511 |
Files are in a database/spreadsheet format (.dbf) and files with an ".exe" extension are compressed into self-extracting files. Files with a ".txt" extension are tab delimited text files. 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 at 916-327-0219.
Special instructions for Excel and Access users
Special instructions for MAC users
*For details on specific file modifications, refer to the File Modifications Web page.
** For 2001-02 and 2002-03, 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.