Banner EDW Source: GIFT

	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	ADVANCEMENT GIFT	NO
FISCAL_YEAR_DESC	NO	DIMENSION TABLE	WDT_TIME	FISCAL_YEAR	ADVANCEMENT GIFT	NO
FUNCTION	NO	DIMENSION TABLE	WDT_TIME	FISCAL_PERIOD	ADVANCEMENT GIFT	NO
GIFT_AMOUNT	NO	FACT TABLE	WFT_ADVANCEMENT_GIFT	GIFT_AMOUNT	ADVANCEMENT GIFT	NO
GIFT_AMOUNT- EDW_ADV_GIFT_EXTR.F_GET_ADVANCEMENT_GIFT :GIFT_AMOUNT EQUAL TO OR GREATER THAN MTVPARM EXTRACT PARAMETER [MAJOR_GIFT_AMOUNT]	NO	FACT TABLE	WFT_ADVANCEMENT_GIFT	MAJOR_GIFT_AMOUNT	ADVANCEMENT GIFT	NO
GIFT_DATE	NO	DIMENSION TABLE	WDT_TIME WDT_TIME	CALENDAR_YEAR CALENDAR_MONTH	ADVANCEMENT GIFT ADVANCEMENT GIFT	NO NO
GIFT_TYPE	NO	DIMENSION TABLE	WDT_GIFT	GIFT_TYPE	ADVANCEMENT GIFT	NO
GIFT_TYPE_DESC	NO	DIMENSION TABLE	WDT_GIFT WDT_GIFT	GIFT_TYPE_LD GIFT_TYPE_SD	ADVANCEMENT GIFT ADVANCEMENT GIFT	NO NO
MULTI_SOURCE	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	MULTI_SOURCE	ADVANCEMENT GIFT	NO
MULTI_SOURCE_DESC	NO	DIMENSION TABLE	WDT_MULTI_SOURCE WDT_MULTI_SOURCE	MULTI_SOURCE_LD MULTI_SOURCE_SD	ADVANCEMENT GIFT ADVANCEMENT GIFT	NO NO
PLEDGE_NUMBER	NO	FACT TABLE	WFT_ADVANCEMENT_GIFT	PLEDGE_NUMBER	ADVANCEMENT GIFT	NO
PROCESS_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	PROCESS_GROUP	ADVANCEMENT GIFT	NO

Ver: 9.0