Penn Computing

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

V_DEPARTMENT table

(dwngss.v_department)

Explanation

This is a validation table, containing the values and descriptions for the Department codes associated courses, and also Department codes associated with major, minors and concentrations.

Source

The warehouse V_DEPARTMENT 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_STVDEPT.

Primary Key Indexed Data Elements Related Tables
DEPARTMENT_CODE

 

COURSE

Cautions and notes

  • Department codes have descriptions in the Banner baseline table, STVDEPT. The description fields are limited to 30 characters, so Penn has developed a custom solution for storing a longer descriptive name for departments. Long descriptions have specified start and end terms. When looking up the long description for a Department code, you can either 1) use the V_DEPARTMENT table and look for the code that falls within the desired start/end term, or 2) use the V_DEPARTMENT_V view to get the most recent long description.
V_DEPARTMENT 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