FA RACE ETHNICITY FLAT column definitions . Pennant Financial Aid Home . Data Warehouse Home

Financial Aid Race Ethnicity Flat table

(dwngss_pf.fa_race_ethnicity_flat)

Explanation

A flattened table of financial aid applicants that include details on ethnicity and race. One row per individual.

Source

The warehouse Financial Aid Race Ethnicity Flat (dwngss_pf.fa_race_ethnicity_flat) table is refreshed in batch mode from the Operational Data Store (ODS), which gets its data from the Banner database. The UPENN_ODS source tables are FAISMGR_RORSTAT, SATURN_SPBPERS, GENERAL_GORRACE.

Common Uses

• Identify specific ethnicity and race information for Financial Aid applicants.

Cautions and notes

• This table is a duplicate of the ST_RACE_ETHNICITY_FLAT table located in the DWNGSS_PS schema - using the same logic and information. The main difference is that the ST_RACE_ETHNICITY_FLAT table is limited to students who have matriculated. The FA_RACE_ETHNICITH_FLAT table includes Financial Aid applicants who may not have matriculated to Penn.

FA RACE ETHNICITY FLAT column definitions . Pennant Financial Aid Home . Data Warehouse Home