Penn Computing

University of Pennsylvania
Penn Computing << go backback
V_CLASS column definitions . Tables and Data Elements . Pennant Student Records Home . Data Warehouse Home

V_CLASS table

(dwngss.v_class)

Explanation

This is a validation table, containing the values and descriptions for student classifications. Examples of valid values: FR - Freshman, SO - Sophomore, L3 - Law 3rd Year, M6 - MD 6th Year, etc.

Source

The warehouse V_CLASS 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_STVCLAS.

Primary Key Indexed Data Elements Related Tables
CLASS_CODE

 

ST_DEGREE_TERM, ST_TERM, ST_ATTRIBUTE

Cautions and notes

  • Classification is system-calculated in Banner, and includes external transfer credit and AP credit awarded to the student, along with coursework completed at Penn. To see the student's "Penn Classification" of their class standing based on only courses taken at Penn, see the ST_ATTRIBUTE table, and validation codes in V_STDNT_ATTR.
V_CLASS column definitions . Tables and Data Elements . 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