V_INSTITUTION column definitions . Pennant Student Records Home . Data Warehouse Home

V_INSTITUTION table

(dwngss.v_institution)

Explanation

This is a validation table, containing descriptions, addresses, and start and end dates for institution codes. Values include high school, college, university, and other academic institutions.

Source

The warehouse V_INSTITUTION table is refreshed in batch mode from the Operational Data Store (ODS), which gets its data from the Banner database. The UPENN_ODS source tables are SATURN_SOBSBGI, SATURN_STVSBGI, and UP_ST_UP_S_BANNER_LONG_DESC.

Cautions and notes

V_INSTITUTION column definitions . Pennant Student Records Home . Data Warehouse Home