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

SGHE Enterprise Data Warehouse Banner EDW Source: DESIGNATION_GIVING_HISTORY - NULL

Source Column Local Source Target Type Target Target Column Star Name Local Target
DESG_COLLEGE NO

DIMENSION TABLE

WDT_DESIGNATION

DESIGNATION_COLLEGE

ADVANCEMENT GIFT 

NO

DESG_COLLEGE_DESC NO

DIMENSION TABLE

WDT_DESIGNATION

WDT_DESIGNATION

DESIGNATION_COLLEGE_SD

DESIGNATION_COLLEGE_LD

ADVANCEMENT GIFT 

ADVANCEMENT GIFT 

NO

NO

DESG_VSE NO

DIMENSION TABLE

WDT_DESIGNATION

DESIGNATION_PURPOSE

ADVANCEMENT GIFT 

NO

DESG_VSE_DESC NO

DIMENSION TABLE

WDT_DESIGNATION

WDT_DESIGNATION

DESIGNATION_PURPOSE_LD

DESIGNATION_PURPOSE_SD

ADVANCEMENT GIFT 

ADVANCEMENT GIFT 

NO

NO



Ver: 9.0