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_SD CAE_PURPOSE_LD |
ADVANCEMENT GIFT ADVANCEMENT GIFT |
NO NO |
| ATVCFAE_DESC |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL DESIGNATION GIFT PLEDGE_MATCHING DONOR_CATEGORY CAMPAIGN_DESIGNATION DONOR_CATEGORY DESIGNATION_GIVING_HISTORY PLEDGE |
CAE_PURPOSE_SD CAE_PURPOSE_LD DESG_VSE_DESC DESG_VSE_DESC DESG_VSE_DESC VSE_DESC_1 DESG_VSE_DESC VSE_DESC_2 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 NA |
NO 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 CAMPAIGN_DESIGNATION |
CAE_REPORT_LINE DESG_VSE_PURPOSE_TYPE |
ADVANCEMENT GIFT NA |
NO NO |