Banner EDW Source: NO SOURCE

RETURN TO BANNER EDW META DATA REPORTS LIST

**SGHE Enterprise Data Warehouse**
Source Column	Local Source	Target Type	Target	Target Column	Star Name	Local Target
NO SOURCE	NO	DIMENSION TABLE	WDT_FISCAL_DATE WDT_FISCAL_DATE WDT_FISCAL_DATE WDT_FISCAL_DATE WDT_FISCAL_DATE WDT_FISCAL_DATE WDT_FISCAL_DATE WDT_FISCAL_DATE WDT_FISCAL_DATE WDT_FISCAL_DATE WDT_FISCAL_DATE WDT_FISCAL_DATE WDT_FISCAL_DATE WDT_FISCAL_DATE WDT_FISCAL_DATE	USER_ATTRIBUTE_04_SD USER_ATTRIBUTE_01_LD USER_ATTRIBUTE_03_SD USER_ATTRIBUTE_05 USER_ATTRIBUTE_01 USER_ATTRIBUTE_02_LD USER_ATTRIBUTE_04_LD USER_ATTRIBUTE_05_LD USER_ATTRIBUTE_03 USER_ATTRIBUTE_04 USER_ATTRIBUTE_02 USER_ATTRIBUTE_03_LD USER_ATTRIBUTE_02_SD USER_ATTRIBUTE_01_SD USER_ATTRIBUTE_05_SD	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION	NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO
NO SOURCE	NO	DIMENSION TABLE	WDT_DESIGNATION WDT_DESIGNATION WDT_GIFT WDT_GIFT WDT_PLEDGE WDT_DESIGNATION WDT_GIFT WDT_DESIGNATION WDT_DESIGNATION WDT_GIFT WDT_GIFT WDT_PLEDGE WDT_DESIGNATION WDT_DESIGNATION WDT_DESIGNATION WDT_GIFT WDT_GIFT WDT_DESIGNATION WDT_GIFT WDT_GIFT WDT_PLEDGE WDT_DESIGNATION WDT_DESIGNATION WDT_GIFT WDT_GIFT WDT_DESIGNATION WDT_GIFT	DESIGNATION_FUND_NAME_SD DESIGNATION_SUB_DEPARTMENT_LD GIFT_PAYMENT_TENDER GIFT_PAYMENT_TENDER_SD PLEDGE_EFT_TYPE_SD DESIGNATION_CAMPUS_LD GIFT_PAYMENT_TYPE DESIGNATION_CAMPUS DESIGNATION_DIVISION_LD GIFT_PAYMENT_EFT_TYPE GIFT_PAYMENT_EFT_TYPE_SD PLEDGE_EFT_TYPE_LD DESIGNATION_DIVISION DESIGNATION_DIVISION_SD DESIGNATION_SUB_DEPARTMENT GIFT_PAYMENT_CAE_TYPE GIFT_PAYMENT_TENDER_LD DESIGNATION_FUND_NAME_LD GIFT_PAYMENT_CAE_TYPE_LD GIFT_PAYMENT_EFT_TYPE_LD PLEDGE_EFT_TYPE DESIGNATION_CAMPUS_SD DESIGNATION_SUB_DEPARTMENT_SD GIFT_PAYMENT_TYPE_LD GIFT_PAYMENT_TYPE_SD DESIGNATION_FUND_NAME GIFT_PAYMENT_CAE_TYPE_SD	ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT	NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO

Ver: 9.0