Penn Computing

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

V_RELATION table

(dwngss.v_relation)

Explanation

This is a validation table, containing the values and descriptions for codes identifying a person's relationship to a student. Used in admissions (for relationship of alumni to student), and in emergency contact information.

Source

The warehouse V_RELATION 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_STVRELT.

 

Primary Key Indexed Data Elements Related Tables
RELATION_CODE

 

ST_EMERGENCY_ADDRESS, ST_ADM_INFO

Cautions and notes

V_RELATION 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