Banner EDW Source: GRANT_VIEW

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

**SGHE Enterprise Data Warehouse**
Source Column	Local Source	Target Type	Target	Target Column	Star Name	Local Target
ADMINISTRATIVE_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	ADMINISTRATIVE_GROUP	GRANT AND PROJECT	NO
CATEGORY	NO	DIMENSION TABLE	WDT_GRANT_TYPE WDT_GRANT_TYPE WDT_GRANT_TYPE	CATEGORY CATEGORY_LD CATEGORY_SD	GRANT AND PROJECT GRANT AND PROJECT GRANT AND PROJECT	NO NO NO
GRANT_TYPE	NO	DIMENSION TABLE	WDT_GRANT_TYPE	GRANT_TYPE	GRANT AND PROJECT	NO
GRANT_TYPE_DESC	NO	DIMENSION TABLE	WDT_GRANT_TYPE WDT_GRANT_TYPE	GRANT_TYPE_LD GRANT_TYPE_SD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
LOCATION	NO	DIMENSION TABLE	WDT_GRANT_TYPE	LOCATION	GRANT AND PROJECT	NO
LOCATION_DESC	NO	DIMENSION TABLE	WDT_GRANT_TYPE WDT_GRANT_TYPE	LOCATION_SD LOCATION_LD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
MULTI_SOURCE	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	MULTI_SOURCE	GRANT AND PROJECT	NO
MULTI_SOURCE_DESC	NO	DIMENSION TABLE	WDT_MULTI_SOURCE WDT_MULTI_SOURCE	MULTI_SOURCE_LD MULTI_SOURCE_SD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
ON_OFF_CAMPUS	NO	DIMENSION TABLE	WDT_GRANT_TYPE	ON_CAMPUS_IND	GRANT AND PROJECT	NO
PRINCIPAL_INVESTIGATOR_UID	NO	DIMENSION TABLE	WDT_GRANT_DEMOGRAPHIC	PRINCIPAL_INVESTIGATOR_NAME	GRANT AND PROJECT	NO
PROCESS_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	PROCESS_GROUP	GRANT AND PROJECT	NO
RESEARCH_PURPOSE	NO	DIMENSION TABLE	WDT_GRANT_TYPE	RESEARCH_PURPOSE	GRANT AND PROJECT	NO
RESPONSIBLE_ORGANIZATION_CODE	NO	DIMENSION TABLE	WDT_GRANT_DEMOGRAPHIC	RESPONSIBLE_ORGANIZATION	GRANT AND PROJECT	NO
RESPONSIBLE_ORGANIZATION_DESC	NO	DIMENSION TABLE	WDT_GRANT_DEMOGRAPHIC WDT_GRANT_DEMOGRAPHIC	RESPONSIBLE_ORGANIZATION_SD RESPONSIBLE_ORGANIZATION_LD	GRANT AND PROJECT GRANT AND PROJECT	NO NO
SUBCATEGORY	NO	DIMENSION TABLE	WDT_GRANT_TYPE WDT_GRANT_TYPE WDT_GRANT_TYPE	SUBCATEGORY_SD SUBCATEGORY SUBCATEGORY_LD	GRANT AND PROJECT GRANT AND PROJECT GRANT AND PROJECT	NO NO NO

Ver: 9.0