RETURN TO EDW META DATA REPORTS LIST
(ODS Target Report)

SGHE Enterprise Data Warehouse EDW Source: PERSON

Source Column Local Source Target Type Target Target Column Local Target
FULL_NAME_FMIL NO

DIMENSION TABLE

WDT_INSTRUCTOR

INSTRUCTOR_NAME

NO

FUNCTION NO        
GENDER NO

DIMENSION TABLE

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

GENDER

GENDER

GENDER

GENDER

NO

NO

NO

NO

GENDER_DESC NO

DIMENSION TABLE

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

GENDER_SD

GENDER_LD

GENDER_SD

GENDER_LD

GENDER_LD

GENDER_LD

GENDER_SD

GENDER_SD

NO

NO

NO

NO

NO

NO

NO

NO

NATION_OF_CITIZENSHIP NO

DIMENSION TABLE

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

NATION_OF_CITIZENSHIP

NATION_OF_CITIZENSHIP

NATION_OF_CITIZENSHIP

NATION_OF_CITIZENSHIP

NO

NO

NO

NO

NATION_OF_CITIZENSHIP_DESC NO

DIMENSION TABLE

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

NATION_OF_CITIZENSHIP_SD

NATION_OF_CITIZENSHIP_SD

NATION_OF_CITIZENSHIP_LD

NATION_OF_CITIZENSHIP_SD

NATION_OF_CITIZENSHIP_LD

NATION_OF_CITIZENSHIP_SD

NATION_OF_CITIZENSHIP_LD

NATION_OF_CITIZENSHIP_LD

NO

NO

NO

NO

NO

NO

NO

NO

PERSON_UID NO        
PRIMARY_ETHNCITY_CATEGORY NO

DIMENSION TABLE

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

ETHNICITY_CATEGORY

ETHNICITY_CATEGORY

ETHNICITY_CATEGORY

ETHNICITY_CATEGORY

NO

NO

NO

NO

PRIMARY_ETHNICITY NO

DIMENSION TABLE

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

ETHNICITY

ETHNICITY

ETHNICITY

ETHNICITY

NO

NO

NO

NO

PRIMARY_ETHNICITY_DESC NO

DIMENSION TABLE

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

ETHNICITY_SD

ETHNICITY_LD

ETHNICITY_LD

ETHNICITY_LD

ETHNICITY_SD

ETHNICITY_LD

ETHNICITY_SD

ETHNICITY_SD

NO

NO

NO

NO

NO

NO

NO

NO

PRIM_DISABILITY NO

DIMENSION TABLE

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

PRIMARY_DISABILITY

PRIMARY_DISABILITY

PRIMARY_DISABILITY

PRIMARY_DISABILITY

NO

NO

NO

NO

PRIM_DISABILITY_DESC NO

DIMENSION TABLE

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

PRIMARY_DISABILITY_LD

PRIMARY_DISABILITY_SD

PRIMARY_DISABILITY_LD

PRIMARY_DISABILITY_SD

PRIMARY_DISABILITY_SD

PRIMARY_DISABILITY_LD

PRIMARY_DISABILITY_LD

PRIMARY_DISABILITY_SD

NO

NO

NO

NO

NO

NO

NO

NO

PRIM_ETHNICITY_CATEGORY_DESC NO

DIMENSION TABLE

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

ETHNICITY_CATEGORY_LD

ETHNICITY_CATEGORY_LD

ETHNICITY_CATEGORY_LD

ETHNICITY_CATEGORY_LD

ETHNICITY_CATEGORY_SD

ETHNICITY_CATEGORY_SD

ETHNICITY_CATEGORY_SD

ETHNICITY_CATEGORY_SD

NO

NO

NO

NO

NO

NO

NO

NO

VETERAN_TYPE NO

DIMENSION TABLE

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

VETERAN_TYPE

VETERAN_TYPE

VETERAN_TYPE

VETERAN_TYPE

NO

NO

NO

NO

VETERAN_TYPE_DESC NO

DIMENSION TABLE

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

VETERAN_TYPE_SD

VETERAN_TYPE_LD

VETERAN_TYPE_SD

VETERAN_TYPE_LD

VETERAN_TYPE_SD

VETERAN_TYPE_LD

VETERAN_TYPE_SD

VETERAN_TYPE_LD

NO

NO

NO

NO

NO

NO

NO

NO

VISA_TYPE NO

DIMENSION TABLE

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

VISA_TYPE

VISA_TYPE

VISA_TYPE

VISA_TYPE

NO

NO

NO

NO

VISA_TYPE_ADMIT NO        
VISA_TYPE_ADMIT_DESC NO        
VISA_TYPE_DESC NO

DIMENSION TABLE

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

VISA_TYPE_SD

VISA_TYPE_LD

VISA_TYPE_SD

VISA_TYPE_SD

VISA_TYPE_LD

VISA_TYPE_LD

VISA_TYPE_LD

VISA_TYPE_SD

NO

NO

NO

NO

NO

NO

NO

NO



Ver: 3.1