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

V_ACTIVITY_CAT table

(dwngss.v_activity_cat)

Explanation

This is a validation table, containing the values and descriptions for codes used to identify categories to which activities belong.

Source

The warehouse V_ACTIVITY_CAT 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_STVACCG.

Cautions and notes

• An activity can only belong to one category. A category can have multiple activity codes associated with it.

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