Skip to Content

Project Success

university_layout.csv

The university layout file should provide the entity structure for the institution. The file should be provided each requested academic period to track changes in the structure over time. It should include any program that was offered in the institution each requested academic period.

Institutional structure will be as follows:

College -> College Division -> Department -> Major -> Program -> Concentration.
Within this structure, only College, Major, and Program data are required.

Examples can be found for each column in the image above or here in the sample file.

Note that column names are case sensitive and must be listed exactly as shown below.

Column Name Acceptable Values
college_name Name for each institutional college/department
college_code Code for each institutional college
program_name Name for each institutional program
program_code Code for each institutional program
cip_code The classification of instructional programs (CIP) code that is tied to this major. The format should be: ##.####
academic_period
  • The academic period that this program was available. If it is available for multiple periods, list them each as a different row in this file
  • This should be provided in term yyyy format: "Winter yyyy", "Spring yyyy", "Summer yyyy", "Fall yyyy". Where "yyyy" is the 4-digit year format
college_division_name
  • If an institution has college divisions, a name for each should be given
  • Empty cell
college_division_code
  • If an institution has college divisions, a code for each should be given
  • Empty cell
department_name
  • If an institution has departments, a name for each should be given
  • Empty cell
department_code
  • If an institution has departments, a code for each should be given
  • Empty cell
major_name
  • Name for each institutional major
  • Empty cell
major_code
  • Code for each institutional major
  • Empty cell
concentration_name
  • If an institution has concentrations, a name for each should be given
  • Empty cell
concentration_code
  • If an institution has concentrations, a code for each should be given
  • Empty cell

Questions?

What file format does my file need to be in?
When is my file due?
Where do I drop my file?