RETURN TO BANNER EDW META DATA REPORTS LIST
Race Star  

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_RACE

Description Race fact table contains one row per person per race value stored for that person. This data includes the confirmed date when the data is verified with the person. Data in this fact is used to calculate the data for the race/ethnicity indicators including the RACE_ETHNICITY_CONFIRM_IND on the WDT_DEMOGRAPHIC dimension table.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
DEMOGRAPHIC_KEY Key for the demographic dimension. NUMBER

ETL GENERATED

NA

NO

NO RACE
MULTI_SOURCE_KEY Key for the multi source dimension. NUMBER

ETL GENERATED

NA

NO

NO RACE
PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

PERSON_SENSITIVE_RACE

PERSON_SENSITIVE_RACE

PERSON_UID

PERSON_UID

NO

NO

NO RACE, RACE 

RACE, RACE

RACE_ETHNICITY_CONFIRM_DATE Date the race ethnicity values were verified for this person. DATE

PERSON

PERSON

RACE_ETHNICITY_CONFIRM_DATE

RACE_ETHNICITY_CONFIRM_DATE

NO

NO

NO RACE, RACE 

RACE, RACE

RACE_GROUP_KEY Key for the set of race dimension keys. NUMBER

ETL GENERATED

NA

NO

NO RACE
RACE_KEY Key for the race dimension. NUMBER

ETL GENERATED

NA

NO

NO RACE
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

ETL GENERATED

NA

NO

NO RACE
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL GENERATED

NA

NO

NO RACE


Ver: 8.4.3