Banner EDW Source: AMREXRT

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
AMREXRT_ACTIVITY_DATE	NO	REPORTING VIEW	ADVANCEMENT_RATING	RATING_DATE	NA	NO
AMREXRT_EXRS_CODE	NO	DIMENSION TABLE REPORTING VIEW	WDT_CONSTITUENT_PROFILE ADVANCEMENT_RATING ADVANCEMENT_RATING_SLOT ADVANCEMENT_RATING_SLOT ADVANCEMENT_RATING_SLOT	PROFILE_SOURCE RATING_TYPE RATING_TYPE2 RATING_TYPE1 RATING_TYPE3	CONSTITUENT PROFILE NA NA NA NA	NO NO NO NO NO
AMREXRT_EXT_LEVEL	NO	DIMENSION TABLE REPORTING VIEW	WDT_CONSTITUENT_PROFILE WDT_CONSTITUENT_PROFILE WDT_CONSTITUENT_PROFILE ADVANCEMENT_RATING ADVANCEMENT_RATING_SLOT ADVANCEMENT_RATING_SLOT ADVANCEMENT_RATING_SLOT	PROFILE_LEVEL_LD PROFILE_LEVEL_SD PROFILE_LEVEL RATING_LEVEL RATING_LEVEL2 RATING_LEVEL1 RATING_LEVEL3	CONSTITUENT PROFILE CONSTITUENT PROFILE CONSTITUENT PROFILE NA NA NA NA	NO NO NO NO NO NO NO
AMREXRT_EXT_SCORE	NO	DIMENSION TABLE REPORTING VIEW	WDT_CONSTITUENT_PROFILE_DETAIL ADVANCEMENT_RATING_SLOT ADVANCEMENT_RATING ADVANCEMENT_RATING_SLOT ADVANCEMENT_RATING_SLOT	RANK RATING_AMOUNT2 RATING_AMOUNT RATING_AMOUNT1 RATING_AMOUNT3	CONSTITUENT PROFILE NA NA NA NA	NO NO NO NO NO
AMREXRT_EXT_VALUE	NO	DIMENSION TABLE REPORTING VIEW	WDT_CONSTITUENT_PROFILE_DETAIL ADVANCEMENT_RATING ADVANCEMENT_RATING_SLOT ADVANCEMENT_RATING_SLOT ADVANCEMENT_RATING_SLOT	POTENTIAL RATING RATING3 RATING1 RATING2	CONSTITUENT PROFILE NA NA NA NA	NO NO NO NO NO
AMREXRT_PIDM	NO	REPORTING VIEW	ADVANCEMENT_RATING_SLOT ADVANCEMENT_RATING	ENTITY_UID ENTITY_UID	NA NA	NO NO

Ver: 9.0