Banner EDW Source: ATVCFAE

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
ATVCFAE_CODE	NO	DIMENSION TABLE	WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL	CAE_PURPOSE_LD CAE_PURPOSE_SD	ADVANCEMENT GIFT ADVANCEMENT GIFT	NO NO
ATVCFAE_DESC	NO	REPORTING VIEW	GIFT CAMPAIGN_DESIGNATION DONOR_CATEGORY DONOR_CATEGORY DESIGNATION_GIVING_HISTORY PLEDGE PLEDGE_MATCHING	DESG_VSE_DESC DESG_VSE_DESC VSE_DESC_1 VSE_DESC_2 DESG_VSE_DESC DESG_VSE_DESC DESG_VSE_DESC	NA NA NA NA NA NA NA	NO NO NO NO NO NO NO
ATVCFAE_MG_PURPOSE	NO	DIMENSION TABLE REPORTING VIEW	WDT_DESIGNATION_DETAIL DESIGNATION CAMPAIGN_DESIGNATION	CAE_MATCH_GIFT_PURPOSE MATCHING_GIFT_VSE_PURPOSE MATCHING_GIFT_VSE_PURPOSE	ADVANCEMENT GIFT NA NA	NO NO NO
ATVCFAE_TYPE	NO	DIMENSION TABLE REPORTING VIEW	WDT_DESIGNATION_DETAIL CAMPAIGN_DESIGNATION	CAE_REPORT_LINE DESG_VSE_PURPOSE_TYPE	ADVANCEMENT GIFT NA	NO NO

Ver: 8.4.3