university_layout.csv

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?