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

V_ACTIVITY table

(dwngss.v_activity)

Explanation

This is a validation table, containing the values and descriptions for codes used to identify activities that students can participate in, in any given term. This table also contains the Activity Category Code and Activity Type Code to which an activity belongs. Students' activities can be found in the ST_ACTIVITY table.

Source

The warehouse V_ACTIVITY 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_STVACTC.

Cautions and notes

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