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

SGHE Enterprise Data Warehouse EDW Source: GIFT

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

DIMENSION TABLE

WDT_MULTI_SOURCE

ADMINISTRATIVE_GROUP

NO

CALENDAR_YEAR NO        
FISCAL_YEAR_DESC NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

FISCAL_YEAR

FISCAL_YEAR_SD

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

NO

NO

NO

NO

GIFT_AMOUNT NO        
GIFT_DATE NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

CALENDAR_MONTH

CALENDAR_YEAR

NO

NO

GIFT_TYPE NO

DIMENSION TABLE

WDT_GIFT

GIFT_TYPE

NO

GIFT_TYPE_DESC NO

DIMENSION TABLE

WDT_GIFT

WDT_GIFT

GIFT_TYPE_SD

GIFT_TYPE_LD

NO

NO

GIFT_VEHICLE NO

DIMENSION TABLE

WDT_GIFT

GIFT_VEHICLE

NO

GIFT_VEHICLE_DESC NO

DIMENSION TABLE

WDT_GIFT

WDT_GIFT

GIFT_VEHICLE_LD

GIFT_VEHICLE_SD

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

PLEDGE_NUMBER NO        
PROCESS_GROUP NO

DIMENSION TABLE

WDT_MULTI_SOURCE

PROCESS_GROUP

NO



Ver: 3.1