Penn Computing

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

ST_SPORT table

(dwngss_ps.st_sport)

Explanation

Contains information about student activities specifically related to athletics and sports participation.

Source

The warehouse ST_SPORT table is refreshed in batch mode from the Operational Data Store (ODS), which gets its data from the Banner database. The ODS source table is UPENN_ODS.SATURN_SGRSPRT. In the online Pennant system, the data about students' athletic eligibility and compliance can be viewed on the SGASPRT form.

Common Uses

  • Reporting on student athletes

 

Primary Key Indexed Data Elements Related Tables
ST_SPORT_PK
 

STUDENT

Cautions and notes

  • Sports participation is also included in the ST_ACTIVITY table.
ST_SPORT 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