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

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