Penn Computing

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

V_DEGREE table

(dwngss.v_degree)

Explanation

This is a validation table, containing the values and descriptions for the valid Degree codes that can be used in Pennant Student Records.

Source

The warehouse V_DEGREE table is refreshed in batch mode from the Operational Data Store (ODS), which gets its data from the Banner database. The UPENN_ODS source table is SATURN_STVDEGC.

Primary Key Indexed Data Elements Related Tables
DEGREE_CODE

 

ST_TERM, ST_DEGREE_TERM, ST_MAJOR_MINOR, ST_DEGREE_PURSUAL, ST_DEGREE_OUTCOME, ST_DEG_OUTCOME_MAJOR

Cautions and notes

  • Degree codes in the legacy SRS system were sometimes converted to new codes in Pennant Student Records.
  • Degree codes that start with 'Z' are used with to identify types of concurrent degree programs, such as Dual Degree/Coordinated Multiple Degree, Submatriculant, and External Submatriculant.
V_DEGREE 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