Academic Program

This file builds academic programs that include courses from across organizational units providing more flexible reporting in Outcomes and Insight. It should not be automated, because removing courses from a program can affect historical data. Depending on how your program data is stored in the SIS, it may be possible to script the file for manual import, but many campuses need to manually build this file.

The Academic Programs file references two other identifiers that are defined in other files: CourseIdentifier and OrgUnitIdentifier. These identifiers must either be present on program tables or be able to be mapped through another table or view to match the identifiers used in the Sections and Accounts files.

Pivoting CourseIdentifiers

Each record on the Academic Programs file defines an individual program, without CourseIdentifiers listed out in a variable number of columns. the SIS stores each course associated with a program on its own record, so the script will need to pivot this data from a derived table that assigns each CourseIdentifier a row number partitioned by program.

CourseIdentifier Duplicates

Duplicate course identifiers in a single Academic Program causes the file to fail. Be sure that your script only selects distinct courses for any given program. Courses can, however, belong to multiple programs.