Banner EDW Source: WFT_PLEDGE

RETURN TO BANNER EDW META DATA REPORTS LIST

**SGHE Enterprise Data Warehouse**
Source Column	Local Source	Target Type	Target	Target Column	Star Name	Local Target
ADVANCEMENT_APPEAL_KEY	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	ADVANCEMENT_APPEAL_KEY	ANALYZE FUNDRAISING	NO
ADVANCEMENT_PROGRAM_KEY	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	ADVANCEMENT_PROGRAM_KEY	ANALYZE FUNDRAISING	NO
ANTICIPATED_MATCH_AMOUNT	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	ANTICIPATED_MATCH_AMOUNT	ANALYZE FUNDRAISING	NO
CAMPAIGN_KEY	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	CAMPAIGN_KEY	ANALYZE FUNDRAISING	NO
CAMPAIGN_TRANSACTION_AMOUNT	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	CAMPAIGN_TRANSACTION_AMOUNT	ANALYZE FUNDRAISING	NO
CLASS_SCHOOL_KEY	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	CLASS_SCHOOL_KEY	ANALYZE FUNDRAISING	NO
CONSTITUENT_ENTITY_TYPE_KEY	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	CONSTITUENT_ENTITY_TYPE_KEY	ANALYZE FUNDRAISING	NO
DESIGNATION_KEY	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	DESIGNATION_KEY	ANALYZE FUNDRAISING	NO
DONOR_UID	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	DONOR_UID	ANALYZE FUNDRAISING	NO
FUNDRAISING_INITIATIVE_KEY	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	FUNDRAISING_INITIATIVE_KEY	ANALYZE FUNDRAISING	NO
GIFT_REPORTING_INDICATOR_KEY	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	GIFT_REPORTING_INDICATOR_KEY	ANALYZE FUNDRAISING	NO
GIVING_ATTRIBUTE_KEY	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	GIVING_ATTRIBUTE_KEY	ANALYZE FUNDRAISING	NO
HARD_CREDIT_AMOUNT	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING WAT_ANALYZE_FUNDRAISING WAT_ANALYZE_FUNDRAISING	TOTAL_COMMITTED_AMOUNT PLEDGE_AMOUNT HARD_CREDIT_AMOUNT	ANALYZE FUNDRAISING ANALYZE FUNDRAISING ANALYZE FUNDRAISING	NO NO NO
HARD_CREDIT_DONOR_COUNT	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	HARD_CREDIT_DONOR_COUNT	ANALYZE FUNDRAISING	NO
OVERALL_PLEDGE_BALANCE	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	OVERALL_PLEDGE_BALANCE	ANALYZE FUNDRAISING	NO
OVERALL_TRANSACTION_AMOUNT	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	OVERALL_TRANSACTION_AMOUNT	ANALYZE FUNDRAISING	NO
PLEDGE_AMOUNT_PAID	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	PLEDGE_AMOUNT_PAID	ANALYZE FUNDRAISING	NO
PLEDGE_BALANCE	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	PLEDGE_BALANCE	ANALYZE FUNDRAISING	NO
PLEDGE_CURRENCY_AMOUNT	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	CURRENCY_AMOUNT	ANALYZE FUNDRAISING	NO
PLEDGE_DATE_OF_RECORD	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	TRANSACTION_DATE_OF_RECORD	ANALYZE FUNDRAISING	NO
PLEDGE_DESIGNATION_COUNT	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	DESIGNATION_COUNT	ANALYZE FUNDRAISING	NO
PLEDGE_DETAIL_KEY	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	PLEDGE_DETAIL_KEY	ANALYZE FUNDRAISING	NO
PLEDGE_DONOR_COUNT	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	DONOR_COUNT	ANALYZE FUNDRAISING	NO
PLEDGE_KEY	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	PLEDGE_KEY	ANALYZE FUNDRAISING	NO
PLEDGE_PREMIUM_COUNT	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	PREMIUM_COUNT	ANALYZE FUNDRAISING	NO
PROPOSAL_KEY	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	PROPOSAL_KEY	ANALYZE FUNDRAISING	NO
REUNION_CAMPAIGN_KEY	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	REUNION_CAMPAIGN_KEY	ANALYZE FUNDRAISING	NO
SOFT_CREDIT_AMOUNT	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING WAT_ANALYZE_FUNDRAISING WAT_ANALYZE_FUNDRAISING	PLEDGE_SOFT_CREDIT_AMOUNT SOFT_CREDIT_AMOUNT NON_MATCHED_SOFT_CREDIT_AMOUNT	ANALYZE FUNDRAISING ANALYZE FUNDRAISING ANALYZE FUNDRAISING	NO NO NO
SOFT_CREDIT_DONOR_COUNT	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	SOFT_CREDIT_DONOR_COUNT	ANALYZE FUNDRAISING	NO
SOURCE_DONOR_ENTITY_KEY	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	SOURCE_DONOR_ENTITY_KEY	ANALYZE FUNDRAISING	NO
SOURCE_DONOR_UID	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	SOURCE_DONOR_UID	ANALYZE FUNDRAISING	NO
TOTAL_PLEDGE_PREMIUM_AMOUNT	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	TOTAL_PREMIUM_AMOUNT	ANALYZE FUNDRAISING	NO
TRANSACTION_COUNT	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	TRANSACTION_COUNT	ANALYZE FUNDRAISING	NO
YEAR_OF_GIVING_KEY	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	YEAR_OF_GIVING_KEY	ANALYZE FUNDRAISING	NO

Ver: 9.0