RETURN TO BANNER EDW META DATA REPORTS LIST

SGHE Enterprise Data Warehouse Banner EDW Source: AGGREGATOR - NULL
Source Column Local Source Target Type Target Target Column Star Name Local Target
COUNT(TRANSACTION_COUNT) NO

DIMENSION TABLE

WDT_DONOR_SUMMARY

LIFETIME_GIFT_COUNT

 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
DONOR_ENTITY_KEY NO

AGGREGATE FACT TABLE

WAT_ANALYZE_FUNDRAISING

DONOR_ENTITY_KEY

 ANALYZE FUNDRAISING 

NO
ENTITY_KEY NO

AGGREGATE FACT TABLE

WAT_RQPP_YEARLY_INSTITUTION

ENTITY_KEY

 RQPP YEARLY INSTITUTION 

NO


Ver: 9.0