Penn Computing

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

V_SUBJECT table

(dwngss.v_subject)

Explanation

This is a validation table, containing the values, decriptions, and long descriptions for Subject Areas used on courses.

Source

The warehouse V_SUBJECT 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_STVSUBJ and UP_ST_UP_S_BANNER_LONG_DESC.

 

Primary Key Indexed Data Elements Related Tables
V_SUBJECT_PK

COURSE, COURSE_XLIST, CRSE_ATTRIBUTE, CRSE_COREQ, CRSE_DESC, CRSE_EQUIV, CRSE_GRADE_MODE, CRSE_LEVEL, CRSE_MUTUAL_EXCL, CRSE_PREREQ, CRSE_SCHED_TYPE, CRSE_SECTION, CRSE_SECT_ATTR, CRSE_SECT_INSTRUCTOR, CRSE_SECT_MEETING, CRSE_SECT_OVERRIDE, CRSE_SECT_SCHED_WITH

Cautions and notes

  • Long descriptions can change, and thus have a start and end date. In the V_SUBJECT table, you will find every iteration of a long description, and you can join to the table based on dates to get the description that pertains to any term in a student's record. To get just the most recent long description, use the view V_SUBJECT_V.
V_SUBJECT 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