Banner EDW Source: APRMAIL

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
APRMAIL_ATYP_CODE	NO	REPORTING VIEW	MAIL_SLOT MAIL MAIL_SLOT MAIL_SLOT MAIL_SLOT	MAIL_ADDRESS_TYPE3 ADDRESS_TYPE MAIL_ADDRESS_TYPE2 MAIL_ADDRESS_TYPE1 MAIL_ADDRESS_TYPE4	NA NA NA NA NA	NO NO NO NO NO
APRMAIL_DATE	NO	REPORTING VIEW	MAIL_SLOT MAIL MAIL_SLOT MAIL_SLOT MAIL_SLOT	MAIL_DATE4 MAIL_DATE MAIL_DATE3 MAIL_DATE2 MAIL_DATE1	NA NA NA NA NA	NO NO NO NO NO
APRMAIL_MAIL_CODE	NO	DIMENSION TABLE REPORTING VIEW	WDT_MAIL_CODE MAIL_SLOT MAIL_SLOT MAIL MAIL_SLOT MAIL_SLOT	MAIL_CODE MAIL_CODE2 MAIL_CODE3 MAIL MAIL_CODE1 MAIL_CODE4	MAIL TRACKING, MAILING LIST NA NA NA NA NA	NO NO NO NO NO NO
APRMAIL_PIDM	NO	REPORTING VIEW	MAIL MAIL_SLOT	ENTITY_UID ENTITY_UID	NA NA	NO NO

Ver: 9.0