SGHE Enterprise Data Warehouse
Banner EDW Source: AFBCAMP - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| AFBCAMP_ACTIVITY_DATE |
NO |
REPORTING VIEW |
CAMPAIGN |
ACTIVITY_DATE |
NA |
NO |
| AFBCAMP_CAMPAIGN |
NO |
DIMENSION TABLE |
WDT_CAMPAIGN |
CAMPAIGN |
ANALYZE FUNDRAISING, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, PROPOSAL, PROSPECT |
NO |
| AFBCAMP_CMTP_CODE |
NO |
REPORTING VIEW |
CAMPAIGN_GIVING_HISTORY GIFT_MULTIPLE PLEDGE PLEDGE_MATCHING SOLICITOR_ASSIGNMENT_RESULT GIFT_MATCHING CAMPAIGN_DESIGNATION CAMPAIGN_SOLICITATION CAMPAIGN_MAIL SOLICITOR_ASSIGNMENT CAMPAIGN_FUNDRAISER CAMPAIGN_EXPENSE GIFT_MEMO CAMPAIGN CAMPAIGN_COMMENT GIFT |
CAMPAIGN_TYPE CAMPAIGN_TYPE CAMPAIGN_TYPE CAMPAIGN_TYPE CAMPAIGN_TYPE CAMPAIGN_TYPE CAMPAIGN_TYPE CAMPAIGN_TYPE CAMPAIGN_TYPE CAMPAIGN_TYPE CAMPAIGN_TYPE CAMPAIGN_TYPE CAMPAIGN_TYPE CAMPAIGN_TYPE CAMPAIGN_TYPE CAMPAIGN_TYPE |
NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
| AFBCAMP_DEFAULT_DESG |
NO |
REPORTING VIEW |
CAMPAIGN |
DEFAULT_DESIGNATION |
NA |
NO |
| AFBCAMP_END_DATE |
NO |
REPORTING VIEW |
CAMPAIGN |
CAMPAIGN_END_DATE |
NA |
NO |
| AFBCAMP_EST_DATE |
NO |
REPORTING VIEW |
CAMPAIGN |
CAMPAIGN_START_DATE |
NA |
NO |
| AFBCAMP_GOAL |
NO |
REPORTING VIEW |
CAMPAIGN |
CAMPAIGN_GOAL |
NA |
NO |
| AFBCAMP_NAME |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_CAMPAIGN WDT_CAMPAIGN PROSPECT_PROPOSAL_RESULT
GIFT PLEDGE CAMPAIGN_FUNDRAISER
CAMPAIGN_SOLICITATION SOLICITOR_ASSIGNMENT_RESULT
GIFT_MEMO PLEDGE_MATCHING CAMPAIGN_DESIGNATION
CAMPAIGN_MAIL CAMPAIGN_COMMENT CAMPAIGN_GIVING_HISTORY
GIFT_MULTIPLE SOLICITOR_ASSIGNMENT GIFT_MATCHING
CAMPAIGN CAMPAIGN_EXPENSE
|
CAMPAIGN_LD CAMPAIGN_SD PROPOSAL_RESULT_CAMPAIGN_NAME
CAMPAIGN_NAME CAMPAIGN_NAME CAMPAIGN_NAME
CAMPAIGN_NAME CAMPAIGN_NAME
CAMPAIGN_NAME CAMPAIGN_NAME
CAMPAIGN_NAME CAMPAIGN_NAME
CAMPAIGN_NAME CAMPAIGN_NAME
CAMPAIGN_NAME CAMPAIGN_NAME
CAMPAIGN_NAME CAMPAIGN_NAME
CAMPAIGN_NAME
|
ANALYZE FUNDRAISING, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, PROPOSAL, PROSPECT ANALYZE FUNDRAISING, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, PROPOSAL, PROSPECT NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO |