The annual Academic File is due at the end of August each year. The file should include
every person with title codes falling within CTO's 010, 011, 030, 031, 040,
041, 520, 521, 530, 531, 210, 211, 221, 114 and 124 - who was appointed or separated
(including a change of emeritus status) in the previous fiscal year. Please
do not include individuals unless they have at least one of the specified titles.
If an employee was both appointed and separated in the same year, the file should
contain one record for that person with all the required data for both the appointment
and the separation.
Three sets of school codes are available on the Web (http://www.ucop.edu/irc/dd/cps/cps0921.html); one in alphabetical order, one in code order, and one in order by location code (state or country). Codes for institutions not listed may be obtained from Brandon Wong at Brandon.Wong@ucop.edu. As of Fall 1998, Educational Field is no longer required - input file columns previously reserved for Educational Field have now been turned into Filler (please refer to revised academic input file layout.) Also available for your reference is a list of all title codes to be included in the file, as well as the file specifications and data element descriptions.
To make it easier for you to create the academic file in the correct format, you may enter your data into a sample Microsoft Access academic file database, export the data as a text file, and send the text file to us. See instructions for using this Microsoft Access database to format your data.