SGHE Enterprise Data Warehouse
Banner EDW Source: GIFT_AGGREGATOR - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| DONOR_UID |
NO |
DIMENSION TABLE |
WDT_DONOR_SUMMARY |
DONOR_UID |
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 |
| SUM(HARD_CREDIT_AMOUNT) |
NO |
DIMENSION TABLE |
WDT_DONOR_SUMMARY |
LIFETIME_HARD_CREDIT |
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 |
| SUM(MATCH_GIFT_AMOUNT) |
NO |
DIMENSION TABLE |
WDT_DONOR_SUMMARY |
LIFETIME_TOTAL_MATCH |
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 |
| SUM(SOFT_CREDIT_AMOUNT) |
NO |
DIMENSION TABLE |
WDT_DONOR_SUMMARY |
LIFETIME_SOFT_CREDIT |
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 |