Banner EDW Source: EXPRESSION

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
(CAMPAIGN_SOLICITOR_GOAL / CAMPAIGN_GOAL * 100)	NO	REPORTING VIEW	CAMPAIGN_FUNDRAISER	SOLICITOR_PCT_OF_CAMPAIGN_GOAL	NA	NO
CAMPAIGN_ACTIVE_IND_EXPRESSION	NO	DIMENSION TABLE	WDT_CAMPAIGN	CAMPAIGN_ACTIVE_IND	ADVANCEMENT GIFT	NO
CAMPAIGN_ACTIVE_IND_LD_EXPRESSION	NO	DIMENSION TABLE	WDT_CAMPAIGN	CAMPAIGN_ACTIVE_IND_LD	ADVANCEMENT GIFT	NO
CAMPAIGN_ACTIVE_IND_SD_EXPRESSION	NO	DIMENSION TABLE	WDT_CAMPAIGN	CAMPAIGN_ACTIVE_IND_SD	ADVANCEMENT GIFT	NO
CAMP_INCLUDE_IN_GIVING_IND_EXPRESSION	NO	DIMENSION TABLE	WDT_CAMPAIGN	CAMP_INCLUDE_IN_GIVING_IND	ADVANCEMENT GIFT	NO
CAMP_INCLUDE_IN_GIVING_IND_LD_EXPRESSION	NO	DIMENSION TABLE	WDT_CAMPAIGN	CAMP_INCLUDE_IN_GIVING_IND_LD	ADVANCEMENT GIFT	NO
CAMP_INCLUDE_IN_GIVING_IND_SD_EXPRESSION	NO	DIMENSION TABLE	WDT_CAMPAIGN	CAMP_INCLUDE_IN_GIVING_IND_SD	ADVANCEMENT GIFT	NO
CAPITAL_CAMPAIGN_IND_EXPRESSION	NO	DIMENSION TABLE	WDT_CAMPAIGN	CAPITAL_CAMPAIGN_IND	ADVANCEMENT GIFT	NO
CAPITAL_CAMPAIGN_IND_LD_EXPRESSION	NO	DIMENSION TABLE	WDT_CAMPAIGN	CAPITAL_CAMPAIGN_IND_LD	ADVANCEMENT GIFT	NO
CAPITAL_CAMPAIGN_IND_SD_EXPRESSION	NO	DIMENSION TABLE	WDT_CAMPAIGN	CAPITAL_CAMPAIGN_IND_SD	ADVANCEMENT GIFT	NO
CASE WHEN (CAMPAIGN_GOAL > 0	NO	REPORTING VIEW	CAMPAIGN_FUNDRAISER	PCT_SOLC_PROGRESS_CAMP_GOAL	NA	NO
CREDIT_CARD_PAYMENT_IND_EXPRESSION	NO	DIMENSION TABLE	WDT_GIFT	CREDIT_CARD_PAYMENT_IND	ADVANCEMENT GIFT	NO
CREDIT_CARD_PAYMENT_IND_LD_EXPRESSION	NO	DIMENSION TABLE	WDT_GIFT	CREDIT_CARD_PAYMENT_IND_LD	ADVANCEMENT GIFT	NO
CREDIT_CARD_PAYMENT_IND_SD_EXPRESSION	NO	DIMENSION TABLE	WDT_GIFT	CREDIT_CARD_PAYMENT_IND_SD	ADVANCEMENT GIFT	NO
DECODE (APRIGRP_DISP_WEB_IND, 'Y', 'Y', 'N')	NO	REPORTING VIEW	INTEREST	DISPLAY_WEB_IND	NA	NO
GIFT_ACKNOWLEDGED_IND_EXPRESSION	NO	DIMENSION TABLE	WDT_GIFT	GIFT_ACKNOWLEDGED_IND	ADVANCEMENT GIFT	NO
GIFT_ACKNOWLEDGED_IND_LD_EXPRESSION	NO	DIMENSION TABLE	WDT_GIFT	GIFT_ACKNOWLEDGED_IND_LD	ADVANCEMENT GIFT	NO
GIFT_ACKNOWLEDGED_IND_SD_EXPRESSION	NO	DIMENSION TABLE	WDT_GIFT	GIFT_ACKNOWLEDGED_IND_SD	ADVANCEMENT GIFT	NO
GIFT_ADJUSTED_IND_EXPRESSION	NO	DIMENSION TABLE	WDT_GIFT	GIFT_ADJUSTED_IND	ADVANCEMENT GIFT	NO
GIFT_ADJUSTED_IND_LD_EXPRESSION	NO	DIMENSION TABLE	WDT_GIFT	GIFT_ADJUSTED_IND_LD	ADVANCEMENT GIFT	NO
GIFT_ADJUSTED_IND_SD_EXPRESSION	NO	DIMENSION TABLE	WDT_GIFT	GIFT_ADJUSTED_IND_SD	ADVANCEMENT GIFT	NO
GIFT_ANONYMOUS_IND_EXPRESSION	NO	DIMENSION TABLE	WDT_GIFT	GIFT_ANONYMOUS_IND	ADVANCEMENT GIFT	NO
GIFT_ANONYMOUS_IND_LD_EXPRESSION	NO	DIMENSION TABLE	WDT_GIFT	GIFT_ANONYMOUS_IND_LD	ADVANCEMENT GIFT	NO
GIFT_ANONYMOUS_IND_SD_EXPRESSION	NO	DIMENSION TABLE	WDT_GIFT	GIFT_ANONYMOUS_IND_SD	ADVANCEMENT GIFT	NO
GIFT_CAE_TYPE_LD_EXPRESSION	NO	DIMENSION TABLE	WDT_GIFT	GIFT_CAE_TYPE_LD	ADVANCEMENT GIFT	NO
GIFT_CAE_TYPE_SD_EXPRESSION	NO	DIMENSION TABLE	WDT_GIFT	GIFT_CAE_TYPE_SD	ADVANCEMENT GIFT	NO
MATCH_CLAIM_EXISTS_IND_EXPRESSION	NO	DIMENSION TABLE	WDT_GIFT	MATCH_CLAIM_EXISTS_IND	ADVANCEMENT GIFT	NO
MATCH_CLAIM_EXISTS_IND_LD_EXPRESSION	NO	DIMENSION TABLE	WDT_GIFT	MATCH_CLAIM_EXISTS_IND_LD	ADVANCEMENT GIFT	NO
MATCH_CLAIM_EXISTS_IND_SD_EXPRESSION	NO	DIMENSION TABLE	WDT_GIFT	MATCH_CLAIM_EXISTS_IND_SD	ADVANCEMENT GIFT	NO
MATCH_GIFT_EXISTS_IND_EXPRESSION	NO	DIMENSION TABLE	WDT_GIFT	MATCH_GIFT_EXISTS_IND	ADVANCEMENT GIFT	NO
MATCH_GIFT_EXISTS_IND_LD_EXPRESSION	NO	DIMENSION TABLE	WDT_GIFT	MATCH_GIFT_EXISTS_IND_LD	ADVANCEMENT GIFT	NO
MATCH_GIFT_EXISTS_IND_SD_EXPRESSION	NO	DIMENSION TABLE	WDT_GIFT	MATCH_GIFT_EXISTS_IND_SD	ADVANCEMENT GIFT	NO
NVL(CASE WHEN(CAMPAIGN_SOLICITOR_GOAL > 0	NO	REPORTING VIEW	CAMPAIGN_FUNDRAISER	PCT_PROGRESS_SOLICITOR_GOAL	NA	NO
PLDG_INCLUDE_IN_GIVING_IND_EXPRESSION	NO	DIMENSION TABLE	WDT_PLEDGE	PLDG_INCLUDE_IN_GIVING_IND	ADVANCEMENT GIFT	NO
PLDG_INCLUDE_IN_GIVING_IND_LD_EXPRESSION	NO	DIMENSION TABLE	WDT_PLEDGE	PLDG_INCLUDE_IN_GIVING_IND_LD	ADVANCEMENT GIFT	NO
PLDG_INCLUDE_IN_GIVING_IND_SD_EXPRESSION	NO	DIMENSION TABLE	WDT_PLEDGE	PLDG_INCLUDE_IN_GIVING_IND_SD	ADVANCEMENT GIFT	NO
PLEDGE_ACTIVE_IND_EXPRESSION	NO	DIMENSION TABLE	WDT_PLEDGE	PLEDGE_ACTIVE_IND	ADVANCEMENT GIFT	NO
PLEDGE_ACTIVE_IND_LD_EXPRESSION	NO	DIMENSION TABLE	WDT_PLEDGE	PLEDGE_ACTIVE_IND_LD	ADVANCEMENT GIFT	NO
PLEDGE_ACTIVE_IND_SD_EXPRESSION	NO	DIMENSION TABLE	WDT_PLEDGE	PLEDGE_ACTIVE_IND_SD	ADVANCEMENT GIFT	NO
PLEDGE_ADJUSTED_IND_EXPRESSION	NO	DIMENSION TABLE	WDT_PLEDGE	PLEDGE_ADJUSTED_IND	ADVANCEMENT GIFT	NO
PLEDGE_ADJUSTED_IND_LD_EXPRESSION	NO	DIMENSION TABLE	WDT_PLEDGE	PLEDGE_ADJUSTED_IND_LD	ADVANCEMENT GIFT	NO
PLEDGE_ADJUSTED_IND_SD_EXPRESSION	NO	DIMENSION TABLE	WDT_PLEDGE	PLEDGE_ADJUSTED_IND_SD	ADVANCEMENT GIFT	NO
PLEDGE_ANONYMOUS_IND_EXPRESSION	NO	DIMENSION TABLE	WDT_PLEDGE	PLEDGE_ANONYMOUS_IND	ADVANCEMENT GIFT	NO
PLEDGE_ANONYMOUS_IND_LD_EXPRESSION	NO	DIMENSION TABLE	WDT_PLEDGE	PLEDGE_ANONYMOUS_IND_LD	ADVANCEMENT GIFT	NO
PLEDGE_ANONYMOUS_IND_SD_EXPRESSION	NO	DIMENSION TABLE	WDT_PLEDGE	PLEDGE_ANONYMOUS_IND_SD	ADVANCEMENT GIFT	NO
PLEDGE_CAE_TYPE_LD_EXPRESSION	NO	DIMENSION TABLE	WDT_PLEDGE	PLEDGE_CAE_TYPE_LD	ADVANCEMENT GIFT	NO
PLEDGE_CAE_TYPE_SD_EXPRESSION	NO	DIMENSION TABLE	WDT_PLEDGE	PLEDGE_CAE_TYPE_SD	ADVANCEMENT GIFT	NO
PLEDGE_CONDITIONAL_IND_EXPRESSION	NO	DIMENSION TABLE	WDT_PLEDGE	PLEDGE_CONDITIONAL_IND	ADVANCEMENT GIFT	NO
PLEDGE_CONDITIONAL_IND_LD_EXPRESSION	NO	DIMENSION TABLE	WDT_PLEDGE	PLEDGE_CONDITIONAL_IND_LD	ADVANCEMENT GIFT	NO
PLEDGE_CONDITIONAL_IND_SD_EXPRESSION	NO	DIMENSION TABLE	WDT_PLEDGE	PLEDGE_CONDITIONAL_IND_SD	ADVANCEMENT GIFT	NO
PLEDGE_PAID_STATUS_EXPRESSION	NO	DIMENSION TABLE	WDT_PLEDGE	PLEDGE_PAID_STATUS	ADVANCEMENT GIFT	NO
PLEDGE_PAID_STATUS_LD_EXPRESSION	NO	DIMENSION TABLE	WDT_PLEDGE	PLEDGE_PAID_STATUS_LD	ADVANCEMENT GIFT	NO
PLEDGE_PAID_STATUS_SD_EXPRESSION	NO	DIMENSION TABLE	WDT_PLEDGE	PLEDGE_PAID_STATUS_SD	ADVANCEMENT GIFT	NO
RECEIPT_REQUIRED_IND_EXPRESSION	NO	DIMENSION TABLE	WDT_GIFT	RECEIPT_REQUIRED_IND	ADVANCEMENT GIFT	NO
RECEIPT_REQUIRED_IND_LD_EXPRESSION	NO	DIMENSION TABLE	WDT_GIFT	RECEIPT_REQUIRED_IND_LD	ADVANCEMENT GIFT	NO
RECEIPT_REQUIRED_IND_SD_EXPRESSION	NO	DIMENSION TABLE	WDT_GIFT	RECEIPT_REQUIRED_IND_SD	ADVANCEMENT GIFT	NO

Ver: 9.0