Banner EDW Source: GURMAIL

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
GURMAIL_ACTIVITY_DATE	NO	REPORTING VIEW	COMMUNICATION	ACTIVITY_DATE	NA	NO
GURMAIL_ADMIN_IDENTIFIER	NO	REPORTING VIEW	COMMUNICATION	APPLICATION_NUMBER	NA	NO
GURMAIL_AIDY_CODE	NO	REPORTING VIEW	COMMUNICATION	AID_YEAR	NA	NO
GURMAIL_CPLN_CODE	NO	REPORTING VIEW	COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION COMMUNICATION_SLOT	COMMUNICATION_PLAN1 COMMUNICATION_PLAN2 COMMUNICATION_PLAN4 COMMUNICATION_PLAN3 COMMUNICATION_PLAN COMMUNICATION_PLAN5	NA NA NA NA NA NA	NO NO NO NO NO NO
GURMAIL_DATE_INIT	NO	REPORTING VIEW	COMMUNICATION_SLOT COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT	DATE_INITIATED4 DATE_INITIATED DATE_INITIATED1 DATE_INITIATED2 DATE_INITIATED3 DATE_INITIATED5	NA NA NA NA NA NA	NO NO NO NO NO NO
GURMAIL_DATE_PRINTED	NO	REPORTING VIEW	COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT	DATE_PRINTED4 DATE_PRINTED2 DATE_PRINTED DATE_PRINTED1 DATE_PRINTED3 DATE_PRINTED5	NA NA NA NA NA NA	NO NO NO NO NO NO
GURMAIL_LETR_CODE	NO	DIMENSION TABLE REPORTING VIEW DIMENSION TABLE REPORTING VIEW	WDT_MAILING_ATTRIBUTE COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT WDT_MAILING_ATTRIBUTE COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT	MAIL_LETTER_CODE COMMUNICATION COMMUNICATION4 COMMUNICATION1 COMMUNICATION2 COMMUNICATION3 COMMUNICATION5 MAIL_LETTER_CODE COMMUNICATION COMMUNICATION4 COMMUNICATION1 COMMUNICATION2 COMMUNICATION3 COMMUNICATION5	MAILING HISTORY NA NA NA NA NA NA MAILING HISTORY NA NA NA NA NA NA	NO NO NO NO NO NO NO NO NO NO NO NO NO NO
GURMAIL_MATL_CODE_MOD	NO	REPORTING VIEW	COMMUNICATION_SLOT COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT	MATERIAL1 MATERIAL MATERIAL2 MATERIAL4 MATERIAL5 MATERIAL3	NA NA NA NA NA NA	NO NO NO NO NO NO
GURMAIL_MODULE_CODE	NO	REPORTING VIEW	COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT	COMMUNICATION_SOURCE5 COMMUNICATION_SOURCE4 COMMUNICATION_SOURCE COMMUNICATION_SOURCE2 COMMUNICATION_SOURCE3 COMMUNICATION_SOURCE1	NA NA NA NA NA NA	NO NO NO NO NO NO
GURMAIL_PIDM	NO	REPORTING VIEW	COMMUNICATION_SLOT COMMUNICATION	PERSON_UID PERSON_UID	NA NA	NO NO
GURMAIL_PUB_GEN	NO	REPORTING VIEW	COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT	COMMUNICATION_TYPE3 COMMUNICATION_TYPE5 COMMUNICATION_TYPE COMMUNICATION_TYPE2 COMMUNICATION_TYPE4 COMMUNICATION_TYPE1	NA NA NA NA NA NA	NO NO NO NO NO NO
GURMAIL_QTY	NO	REPORTING VIEW	COMMUNICATION	QUANTITY	NA	NO
GURMAIL_SYSTEM_IND	NO	DIMENSION TABLE REPORTING VIEW DIMENSION TABLE REPORTING VIEW	WDT_MAILING_ATTRIBUTE COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION WDT_MAILING_ATTRIBUTE COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION	MAIL_SYSTEM SYSTEM1 SYSTEM3 SYSTEM2 SYSTEM4 SYSTEM5 SYSTEM MAIL_SYSTEM SYSTEM1 SYSTEM3 SYSTEM2 SYSTEM4 SYSTEM5 SYSTEM	MAILING HISTORY NA NA NA NA NA NA MAILING HISTORY NA NA NA NA NA NA	NO NO NO NO NO NO NO NO NO NO NO NO NO NO
GURMAIL_TERM_CODE	NO	REPORTING VIEW	COMMUNICATION	ACADEMIC_PERIOD	NA	NO

Ver: 9.0