Banner EDW Source: ATVXREF

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
ATVXREF_CODE	NO	DIMENSION TABLE	WDT_RELATIONSHIP	RELATIONSHIP	CONSTITUENT EMPLOYMENT, RELATIONSHIP	NO
ATVXREF_DESC	NO	DIMENSION TABLE REPORTING VIEW	WDT_RELATIONSHIP WDT_RELATIONSHIP RELATIONSHIP RELATIONSHIP	RELATIONSHIP_LD RELATIONSHIP_SD RELATED_REFERENCE_DESC REVERSE_REFERENCE_DESC	CONSTITUENT EMPLOYMENT, RELATIONSHIP CONSTITUENT EMPLOYMENT, RELATIONSHIP NA NA	NO NO NO NO
ATVXREF_HOUSEHOLD_IND	NO
ATVXREF_MATCH_GIFT_IND	NO	REPORTING VIEW	RELATIONSHIP	MATCHING_GIFT_IND	NA	NO
ATVXREF_REVERSE_XREF	NO	DIMENSION TABLE REPORTING VIEW	WDT_RELATIONSHIP RELATIONSHIP	CONVERSE_RELATION REVERSE_CROSS_REFERENCE	CONSTITUENT EMPLOYMENT, RELATIONSHIP NA	NO NO
ATVXREF_SPOUSE_IND	NO	REPORTING VIEW	RELATIONSHIP	SPOUSE_IND	NA	NO

Ver: 9.0