Banner EDW Source: CONSTANTS

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
'PROSPECT_ENTITY_F1B'	NO	FACT TABLE	WFT_PROSPECT_ENTITY	SYSTEM_LOAD_PROCESS	PROSPECT ENTITY	NO
0	NO	AGGREGATE FACT TABLE DIMENSION TABLE	WAT_ANALYZE_FUNDRAISING WAT_ANALYZE_FUNDRAISING WAT_ANALYZE_FUNDRAISING WAT_ANALYZE_FUNDRAISING WAT_ANALYZE_FUNDRAISING WAT_ANALYZE_FUNDRAISING WAT_ANALYZE_FUNDRAISING WAT_ANALYZE_FUNDRAISING WAT_ANALYZE_FUNDRAISING WAT_ANALYZE_FUNDRAISING WAT_ANALYZE_FUNDRAISING WAT_ANALYZE_FUNDRAISING WAT_ANALYZE_FUNDRAISING WAT_ANALYZE_FUNDRAISING WAT_ANALYZE_FUNDRAISING WDT_GIVING_ATTRIBUTE WDT_GIVING_ATTRIBUTE WDT_GIVING_ATTRIBUTE	MATCHING_CLAIM_DETAIL_KEY OUTRIGHT_GIFT_SOFT_CREDIT_AMT PLEDGE_PAYMENT_AMOUNT THIRD_PARTY_PAYMENT_AMOUNT GIFT_CREDIT2_AMOUNT MATCHING_CLAIM_KEY MATCH_GIFT_AMOUNT MATCH_CLAIM_AMOUNT MATCH_GIFT_SOFT_CREDIT_AMOUNT NET_PRESENT_VALUE_AMOUNT PLEDGE_PAYMENT_SOFT_CREDIT_AMT TOTAL_RECEIVED_AMOUNT GIFT_DETAIL_KEY GIFT_KEY OUTRIGHT_GIFT_AMOUNT MATCHING_CLAIM_IND MATCHING_GIFT_IND PLEDGE_IND	ANALYZE FUNDRAISING ANALYZE FUNDRAISING ANALYZE FUNDRAISING ANALYZE FUNDRAISING ANALYZE FUNDRAISING ANALYZE FUNDRAISING ANALYZE FUNDRAISING ANALYZE FUNDRAISING ANALYZE FUNDRAISING ANALYZE FUNDRAISING ANALYZE FUNDRAISING ANALYZE FUNDRAISING ANALYZE FUNDRAISING ANALYZE FUNDRAISING ANALYZE FUNDRAISING ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE	NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO
1	NO	FACT TABLE	WFT_PROSPECT_ENTITY	PRIMARY_IND	PROSPECT ENTITY	NO
NULL	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING WAT_ANALYZE_FUNDRAISING WAT_ANALYZE_FUNDRAISING WAT_ANALYZE_FUNDRAISING WAT_ANALYZE_FUNDRAISING	MATCHING_CLAIM_COUNT MATCH_CREDIT_RECIPIENT_COUNT ACTIVE_MATCHING_CLAIM_COUNT MATCH_GIFT_DONOR_COUNT MATCH_GIFT_COUNT	ANALYZE FUNDRAISING ANALYZE FUNDRAISING ANALYZE FUNDRAISING ANALYZE FUNDRAISING ANALYZE FUNDRAISING	NO NO NO NO NO
TO_DATE('31-DEC-2099', 'DD-MON-YYYY')	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING WAT_ANALYZE_FUNDRAISING	MATCH_CLAIM_FORM_RECEIVED_DATE MATCH_CLAIM_STATUS_DATE	ANALYZE FUNDRAISING ANALYZE FUNDRAISING	NO NO

Ver: 9.0