Banner EDW Source: GRANT

	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
CATEGORY_DESC	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_TITLE	NO	DIMENSION TABLE	WDT_GRANT_TYPE WDT_GRANT_TYPE	LOCATION_LD LOCATION_SD	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
ORGANIZATION_CODE	NO	DIMENSION TABLE	WDT_GRANT_DEMOGRAPHIC	RESPONSIBLE_ORGANIZATION	GRANT AND PROJECT	NO
ORGANIZATION_DESC	NO	DIMENSION TABLE	WDT_GRANT_DEMOGRAPHIC WDT_GRANT_DEMOGRAPHIC	RESPONSIBLE_ORGANIZATION_LD RESPONSIBLE_ORGANIZATION_SD	GRANT AND PROJECT GRANT AND PROJECT	NO 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
SUBCATEGORY	NO	DIMENSION TABLE	WDT_GRANT_TYPE WDT_GRANT_TYPE WDT_GRANT_TYPE	SUBCATEGORY SUBCATEGORY_LD SUBCATEGORY_SD	GRANT AND PROJECT GRANT AND PROJECT GRANT AND PROJECT	NO NO NO
SUBCATEGORY_DESC	NO

Ver: 8.1