SGHE Enterprise Data Warehouse
Banner EDW Source: ATVCFAE - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| ATVCFAE_CODE |
NO |
DIMENSION TABLE |
WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL |
CAE_PURPOSE_LD CAE_PURPOSE_SD |
ADVANCEMENT GIFT ADVANCEMENT GIFT |
NO NO |
| ATVCFAE_DESC |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL DONOR_CATEGORY DESIGNATION_GIVING_HISTORY DONOR_CATEGORY PLEDGE_MATCHING GIFT PLEDGE CAMPAIGN_DESIGNATION |
CAE_PURPOSE_LD CAE_PURPOSE_SD VSE_DESC_1 DESG_VSE_DESC VSE_DESC_2 DESG_VSE_DESC DESG_VSE_DESC DESG_VSE_DESC DESG_VSE_DESC |
ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE NA NA NA NA NA NA NA |
NO NO NO NO NO NO NO NO NO |
| ATVCFAE_MG_PURPOSE |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_DESIGNATION_DETAIL CAMPAIGN_DESIGNATION |
CAE_MATCH_GIFT_PURPOSE MATCHING_GIFT_VSE_PURPOSE |
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE NA |
NO NO |
| ATVCFAE_TYPE |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_DESIGNATION_DETAIL DESIGNATION CAMPAIGN_DESIGNATION |
CAE_REPORT_LINE DESG_VSE_PURPOSE_TYPE DESG_VSE_PURPOSE_TYPE |
ADVANCEMENT GIFT NA NA |
NO NO NO |