Penn Computing

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

V_ORIG_DEPT table

(dwngss.v_orig_dept)

Explanation

This is a validation table, containing the values and descriptions for the codes used for the department or academic unit originally associated with the student's originating record. Also used to identify origin of comments, and department-of-origin for student holds.

Source

The warehouse V_ORIG_DEPT 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_STVORIG.

Primary Key Indexed Data Elements Related Tables
ORIG_DEPT_CODE

 

ST_HOLD

Cautions and notes

V_ORIG_DEPT 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