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

SGHE Enterprise Data Warehouse EDW Source: GRANT_VIEW

Source Column Local Source Target Type Target Target Column Local Target
ADMINISTRATIVE_GROUP NO

DIMENSION TABLE

WDT_MULTI_SOURCE

ADMINISTRATIVE_GROUP

NO

CATEGORY NO

DIMENSION TABLE

WDT_GRANT_TYPE

WDT_GRANT_TYPE

WDT_GRANT_TYPE

CATEGORY_SD

CATEGORY_LD

CATEGORY

NO

NO

NO

CATEGORY_DESC NO        
GRANT_TYPE NO

DIMENSION TABLE

WDT_GRANT_TYPE

GRANT_TYPE

NO

GRANT_TYPE_DESC NO

DIMENSION TABLE

WDT_GRANT_TYPE

WDT_GRANT_TYPE

GRANT_TYPE_LD

GRANT_TYPE_SD

NO

NO

LOCATION NO

DIMENSION TABLE

WDT_GRANT_TYPE

LOCATION

NO

LOCATION_TITLE NO

DIMENSION TABLE

WDT_GRANT_TYPE

WDT_GRANT_TYPE

LOCATION_SD

LOCATION_LD

NO

NO

MULTI_SOURCE NO

DIMENSION TABLE

WDT_MULTI_SOURCE

MULTI_SOURCE

NO

MULTI_SOURCE_DESC NO

DIMENSION TABLE

WDT_MULTI_SOURCE

WDT_MULTI_SOURCE

MULTI_SOURCE_LD

MULTI_SOURCE_SD

NO

NO

ON_OFF_CAMPUS NO

DIMENSION TABLE

WDT_GRANT_TYPE

ON_CAMPUS_IND

NO

ORGANIZATION_CODE NO

DIMENSION TABLE

WDT_GRANT_DEMOGRAPHIC

RESPONSIBLE_ORGANIZATION

NO

ORGANIZATION_DESC NO

DIMENSION TABLE

WDT_GRANT_DEMOGRAPHIC

WDT_GRANT_DEMOGRAPHIC

RESPONSIBLE_ORGANIZATION_LD

RESPONSIBLE_ORGANIZATION_SD

NO

NO

PRINCIPAL_INVESTIGATOR_UID NO

DIMENSION TABLE

WDT_GRANT_DEMOGRAPHIC

PRINCIPAL_INVESTIGATOR_NAME

NO

PROCESS_GROUP NO

DIMENSION TABLE

WDT_MULTI_SOURCE

PROCESS_GROUP

NO

RESEARCH_PURPOSE NO

DIMENSION TABLE

WDT_GRANT_TYPE

RESEARCH_PURPOSE

NO

SUBCATEGORY NO

DIMENSION TABLE

WDT_GRANT_TYPE

WDT_GRANT_TYPE

WDT_GRANT_TYPE

SUBCATEGORY

SUBCATEGORY_LD

SUBCATEGORY_SD

NO

NO

NO

SUBCATEGORY_DESC NO        


Ver: 3.1