RETURN TO BANNER EDW META DATA REPORTS LIST

SGHE Enterprise Data Warehouse Banner EDW Source: COMBINED_EXPRESSIONS - NULL

Source Column Local Source Target Type Target Target Column Star Name Local Target
CAMPAIGN_TRANSACTION_AMOUNT_EXPRESSION NO

FACT TABLE

WFT_GIFT

CAMPAIGN_TRANSACTION_AMOUNT

GIFT 

NO

GIFT_DATE_OF_RECORD_EXPRESSION NO

FACT TABLE

WFT_GIFT

GIFT_DATE_OF_RECORD

GIFT 

NO

GIFT_PREMIUM_COUNT_EXPRESSION NO

FACT TABLE

WFT_GIFT

GIFT_PREMIUM_COUNT

GIFT 

NO

GIFT_RECEIPT_DATE_EXPRESSION NO

FACT TABLE

WFT_GIFT

GIFT_RECEIPT_DATE

GIFT 

NO

HARD_CREDIT_AMOUNT_EXPRESSION NO

FACT TABLE

WFT_GIFT

HARD_CREDIT_AMOUNT

GIFT 

NO

MATCH_GIFT_AMOUNT_EXPRESSION NO

FACT TABLE

WFT_GIFT

MATCH_GIFT_AMOUNT

GIFT 

NO

MATCH_GIFT_COUNT_EXPRESSION NO

FACT TABLE

WFT_GIFT

MATCH_GIFT_COUNT

GIFT 

NO

MATCH_GIFT_SOFT_CREDIT_AMOUNT_EXPRESSION NO

FACT TABLE

WFT_GIFT

MATCH_GIFT_SOFT_CREDIT_AMOUNT

GIFT 

NO

NON_MATCHED_SOFT_CREDIT_AMOUNT_EXPRESSIO N NO

FACT TABLE

WFT_GIFT

NON_MATCHED_SOFT_CREDIT_AMOUNT

GIFT 

NO

OVERALL_TRANSACTION_AMOUNT_EXPRESSION NO

FACT TABLE

WFT_GIFT

OVERALL_TRANSACTION_AMOUNT

GIFT 

NO

PLEDGE_GROUP_IDENTIFIER_EXPRESSION NO

FACT TABLE

WFT_GIFT

PLEDGE_GROUP_IDENTIFIER

GIFT 

NO

SOFT_CREDIT_AMOUNT_EXPRESSION NO

FACT TABLE

WFT_GIFT

SOFT_CREDIT_AMOUNT

GIFT 

NO

THIRD_PARTY_PAYMENT_AMOUNT_EXPRESSION NO

FACT TABLE

WFT_GIFT

THIRD_PARTY_PAYMENT_AMOUNT

GIFT 

NO

TRANSACTION_COUNT_EXPRESSION NO

FACT TABLE

WFT_GIFT

TRANSACTION_COUNT

GIFT 

NO



Ver: 9.0