RETURN TO BANNER EDW META DATA REPORTS LIST
Race Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_RACE

Description Race dimension table defines both the race category and the race along with their associated descriptions. It uses the cleansing rules in the EDW for the short and long descriptions in this dimension.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
RACE Race to which a person belongs as identified by the person. There may be multiple race values selected and recorded for the person. VARCHAR2(63)

PERSON_SENSITIVE_RACE

RACE

NO

NO RACE
RACE_CATEGORY Race Category used for federal reporting associated with the race reported by the person. There may be multiple race category values for a persson when multiple races are selected and recorded for the person. VARCHAR2(63)

PERSON_SENSITIVE_RACE

RACE_CATEGORY

NO

NO RACE
RACE_CATEGORY_LD Long description for the race category. VARCHAR2(255)

PERSON_SENSITIVE_RACE

RACE_CATEGORY_DESC

NO

NO RACE
RACE_CATEGORY_SD Short description for the race category. VARCHAR2(255)

PERSON_SENSITIVE_RACE

RACE_CATEGORY_DESC

NO

NO RACE
RACE_KEY Key for the race dimension. NUMBER

ETL GENERATED

NA

NO

NO RACE
RACE_LD Long description for the race recorded. VARCHAR2(255)

PERSON_SENSITIVE_RACE

RACE_DESC

NO

NO RACE
RACE_SD Short description for the race recorded. VARCHAR2(255)

PERSON_SENSITIVE_RACE

RACE_DESC

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: 9.0