Penn Computing

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

V_SPORT_STATUS table

(dwngss.v_sport_status)

Explanation

This is a validation table, containing the values and descriptions for codes that define the status of a sports code.

Source

The warehouse V_SPORT_STATUS 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_STVSPST.

 

Primary Key Indexed Data Elements Related Tables
SPORT_STATUS_CODE

V_ACTIVITY

Cautions and notes

  • This is not the sport codes. This table contains the codes that indicate whether the sport code is active or inactive. The sport codes are found with other activity codes, in the V_ACTIVITY table.
V_SPORT_STATUS 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