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_DESIGNATION CAMPAIGN_GIVING_HISTORY CAMPAIGN_MAIL CAMPAIGN_SOLICITATION PLEDGE GIFT_MATCHING GIFT_MEMO GIFT_MULTIPLE PLEDGE_MATCHING CAMPAIGN_COMMENT CAMPAIGN_FUNDRAISER GIFT CAMPAIGN CAMPAIGN_EXPENSE SOLICITOR_ASSIGNMENT SOLICITOR_ASSIGNMENT_RESULT |
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 CAMPAIGN_DESIGNATION
GIFT_MULTIPLE PLEDGE_MATCHING SOLICITOR_ASSIGNMENT_RESULT
SOLICITOR_ASSIGNMENT CAMPAIGN_COMMENT GIFT_MEMO
CAMPAIGN_FUNDRAISER CAMPAIGN_GIVING_HISTORY
GIFT_MATCHING PLEDGE GIFT
PROSPECT_PROPOSAL_RESULT CAMPAIGN CAMPAIGN_EXPENSE
CAMPAIGN_MAIL CAMPAIGN_SOLICITATION
|
CAMPAIGN_LD CAMPAIGN_SD CAMPAIGN_NAME
CAMPAIGN_NAME CAMPAIGN_NAME
CAMPAIGN_NAME CAMPAIGN_NAME
CAMPAIGN_NAME CAMPAIGN_NAME
CAMPAIGN_NAME CAMPAIGN_NAME
CAMPAIGN_NAME CAMPAIGN_NAME CAMPAIGN_NAME
PROPOSAL_RESULT_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 |