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
CALENDAR_YEAR	NO
FISCAL_YEAR_DESC	NO	DIMENSION TABLE	WDT_TIME WDT_TIME	FISCAL_YEAR FISCAL_YEAR_SD	ADVANCEMENT GIFT ADVANCEMENT GIFT	NO NO
FUNCTION	NO	DIMENSION TABLE	WDT_GIFT WDT_GIFT WDT_GIFT WDT_TIME	GIVING_TOWARD_GOAL_IND MATCH_IND PLEDGE_PAYMENT_IND FISCAL_PERIOD	ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT	NO NO NO NO
GIFT_AMOUNT	NO	FACT TABLE	WFT_ADVANCEMENT_GIFT	GIFT_AMOUNT	ADVANCEMENT GIFT	NO
GIFT_DATE	NO	DIMENSION TABLE	WDT_TIME WDT_TIME	CALENDAR_MONTH CALENDAR_YEAR	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
GIFT_VEHICLE	NO	DIMENSION TABLE	WDT_GIFT	GIFT_VEHICLE	ADVANCEMENT GIFT	NO
GIFT_VEHICLE_DESC	NO	DIMENSION TABLE	WDT_GIFT WDT_GIFT	GIFT_VEHICLE_LD GIFT_VEHICLE_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: 8.1