Banner EDW Source: AMRINFO

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
AMRINFO_ACTIVITY_DATE	NO	REPORTING VIEW	PROSPECT_INFO	ACTIVITY_DATE	NA	NO
AMRINFO_PIDM	NO	REPORTING VIEW	PROSPECT_INFO	ENTITY_UID	NA	NO
AMRINFO_PROSP_RATE	NO	REPORTING VIEW	PROSPECT_INFO	PROSPECT_AMOUNT	NA	NO
AMRINFO_RATE_ENTRY_DATE	NO	REPORTING VIEW	PROSPECT_INFO	PROSPECT_AMOUNT_ENTRY_DATE	NA	NO
AMRINFO_REFERENCE	NO	REPORTING VIEW	PROSPECT_INFO	REFERENCE_COMMENT	NA	NO
AMRINFO_REFR_CODE	NO	DIMENSION TABLE REPORTING VIEW	WDT_PROSPECT_ATTRIBUTE PROSPECT_INFO	PROSPECT_REFERRAL REFERENCE	MANAGE PROSPECT PIPELINE, PROSPECT NA	NO NO
AMRINFO_STATUS	NO	DIMENSION TABLE REPORTING VIEW	WDT_PROSPECT_ATTRIBUTE PROSPECT_INFO	PROSPECT_STATUS PROSPECT_STATUS	MANAGE PROSPECT PIPELINE, PROSPECT NA	NO NO
AMRINFO_SYS_IND	NO	REPORTING VIEW	PROSPECT_INFO	PROSPECT_AMOUNT_METHOD	NA	NO
AMRINFO_TARGET_ASK_DATE	NO	REPORTING VIEW	PROSPECT_INFO	TARGET_ASK_DATE	NA	NO

Ver: 9.0