Banner EDW Source: ATVDCNP

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
ATVDCNP_CODE	NO	DIMENSION TABLE	WDT_GIFT_SOCIETY	GIFT_SOCIETY_CATEGORY	GIFT SOCIETY, GIFT SOCIETY PREMIUM	NO
ATVDCNP_DCST_CODE	NO	REPORTING VIEW	GIFT_SOCIETY_SLOT GIFT_SOCIETY_SLOT GIFT_SOCIETY_SLOT GIFT_SOCIETY_SLOT GIFT_SOCIETY_SLOT GIFT_SOCIETY GIFT_SOCIETY_SLOT GIFT_SOCIETY_SLOT GIFT_SOCIETY_SLOT GIFT_SOCIETY_SLOT GIFT_SOCIETY_SLOT GIFT_SOCIETY_SLOT GIFT_SOCIETY_SLOT	GIFT_SOCIETY_CATEGORY1_2 GIFT_SOCIETY_CATEGORY2_1 GIFT_SOCIETY_CATEGORY1_1 GIFT_SOCIETY_CATEGORY1_3 GIFT_SOCIETY_CATEGORY2_2 GIFT_SOCIETY_CATEGORY GIFT_SOCIETY_CATEGORY2_4 GIFT_SOCIETY_CATEGORY1_4 GIFT_SOCIETY_CATEGORY1_6 GIFT_SOCIETY_CATEGORY2_5 GIFT_SOCIETY_CATEGORY1_5 GIFT_SOCIETY_CATEGORY2_3 GIFT_SOCIETY_CATEGORY2_6	NA NA NA NA NA NA NA NA NA NA NA NA NA	NO NO NO NO NO NO NO NO NO NO NO NO NO
ATVDCNP_DCYR_CODE	NO	REPORTING VIEW	GIFT_SOCIETY	GIFT_SOCIETY_END_YEAR	NA	NO
ATVDCNP_DELETE_IND	NO	REPORTING VIEW	GIFT_SOCIETY	MEMBER_DELETE_IND	NA	NO
ATVDCNP_DESC	NO	DIMENSION TABLE REPORTING VIEW	WDT_GIFT_SOCIETY WDT_GIFT_SOCIETY WDT_GIFT_SOCIETY WDT_GIFT_SOCIETY GIFT_SOCIETY GIFT_SOCIETY_SLOT GIFT_SOCIETY_SLOT GIFT_SOCIETY_SLOT ORGANIZATIONAL_CONSTITUENT GIFT_SOCIETY_SLOT GIFT_SOCIETY_SLOT GIFT_SOCIETY_SLOT GIFT_SOCIETY_SLOT GIFT_SOCIETY_SLOT GIFT_SOCIETY_SLOT GIFT_SOCIETY_SLOT GIFT_SOCIETY_SLOT GIFT_SOCIETY_SLOT	GIFT_SOCIETY_CATEGORY_LD GIFT_SOCIETY_LD GIFT_SOCIETY_SD GIFT_SOCIETY_CATEGORY_SD GIFT_SOCIETY_DESC GIFT_SOCIETY_DESC1_3 GIFT_SOCIETY_DESC1_1 GIFT_SOCIETY_DESC1_6 LIFE_GIFT_SOCIETY_DESC GIFT_SOCIETY_DESC2_4 GIFT_SOCIETY_DESC1_5 GIFT_SOCIETY_DESC2_3 GIFT_SOCIETY_DESC1_2 GIFT_SOCIETY_DESC1_4 GIFT_SOCIETY_DESC2_2 GIFT_SOCIETY_DESC2_5 GIFT_SOCIETY_DESC2_6 GIFT_SOCIETY_DESC2_1	GIFT SOCIETY, GIFT SOCIETY PREMIUM GIFT SOCIETY, GIFT SOCIETY PREMIUM GIFT SOCIETY, GIFT SOCIETY PREMIUM GIFT SOCIETY, GIFT SOCIETY PREMIUM NA NA NA NA NA NA NA NA NA NA NA NA NA NA	NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO
ATVDCNP_MANL_ENTRY_IND	NO	REPORTING VIEW	GIFT_SOCIETY	MANUAL_ENTRY_IND	NA	NO
ATVDCNP_PRIORITY_IND	NO	FACT TABLE REPORTING VIEW	WFT_GIFT_SOCIETY GIFT_SOCIETY	GIFT_SOCIETY_PRI_NUMBER GIFT_SOCIETY_PRIORITY	GIFT SOCIETY NA	NO NO

Ver: 9.0