Banner EDW Source: ATVDSTA

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
ADBDESG_CFAE_CODE	NO	DIMENSION TABLE	WDT_DESIGNATION_DETAIL	CAE_PURPOSE	ADVANCEMENT GIFT	NO
ATVDSTA_ACTIVE_IND	NO	DIMENSION TABLE REPORTING VIEW	WDT_DESIGNATION_DETAIL CAMPAIGN_DESIGNATION	DESIGNATION_ACTIVE_IND ACTIVE_DESIGNATION_IND	ADVANCEMENT GIFT NA	NO NO
ATVDSTA_CODE	NO	DIMENSION TABLE	WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL	DESIGNATION_ACTIVE_IND_LD DESIGNATION_ACTIVE_IND_SD	ADVANCEMENT GIFT ADVANCEMENT GIFT	NO NO
ATVDSTA_DESC	NO	DIMENSION TABLE REPORTING VIEW	WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL GIFT PLEDGE PLEDGE_MATCHING	DESIGNATION_STATUS_LD DESIGNATION_STATUS_SD DESG_STATUS_DESC DESG_STATUS_DESC DESG_STATUS_DESC	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE NA NA NA	NO NO NO NO NO

Ver: 9.0