Penn Computing

University of Pennsylvania
Penn Computing << go backback
APPROVED_ACADEMIC_PROGRAM column definitions . Pennant Student Records Home . Data Warehouse Home

Approved Academic Program table

(dwngss.approved_academic_program)

Explanation

Using the source system (Banner) curriculum rules tables, the Approved Academic Program table provides the current valid combination of division, degree, program, major (with concentration) and minor that can be used on student curriculum records.

Source

The warehouse APPROVED_ACADEMIC_PROGRAM table is refreshed in batch mode from the Operational Data Store (ODS), which gets its data from the Banner database. The UPENN_ODS source tables are SATURN_SOBCURR, SATURN_SORCMJR, SATURN_SORCCON.

Common Uses

  • Finding the current relationships of majors and minors to their associated divisions and degrees.

 

Primary Key Indexed Data Elements Related Tables
APPROVED_ACADEMIC_PROGRAM_PK

ST_DEGREE_PURSUAL

Cautions and notes

  • This table does not contain the history of previous curriculum rules; it reflects the current state.
APPROVED_ACADEMIC_PROGRAM column definitions . Pennant Student Records Home . Data Warehouse Home


Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania