Penn Computing

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

ST_RACE table

(dwngss_ps.st_race)

Explanation

Contains both detail and "rollup" race codes for students.

Source

The warehouse ST_RACE table is refreshed in batch mode from the Operational Data Store (ODS), which gets its data from the Banner database. The ODS source tables are UPENN_ODS.SATURN_SPRIDEN, UPENN_ODS.GENERAL_GORPRAC and UPENN_ODS.GENERAL_GORRACE.

Common Uses

  • Aggregate reporting on students by race

 

Primary Key Indexed Data Elements Related Tables
ST_RACE_PK
PENN_ID, RACE_CODE

STUDENT, ST_RACE_ETHNICITY_FLAT

Cautions and notes

  • Students can have multiple rows in this table. To see a flattened view with just one row per student, see ST_RACE_ETHNICITY_FLAT.
ST_RACE 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