RETURN TO BANNER EDW META DATA REPORTS LIST
Mailing History Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_MAILING_ATTRIBUTE

Description Mailing attribute dimension table provides information about mailings sent to a constituent. It uses the cleansing rules in the EDW for the short and long descriptions.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
MAILING_ATTRIBUTE_KEY Mailing Attribute KEY. NUMBER       NO
MAIL_LETTER_CODE Mail letter code associated with the communication. VARCHAR2(63)

GURMAIL

GURMAIL_LETR_CODE

NO

NO MAILING HISTORY
MAIL_LETTER_CODE_LD Mail letter code long description. VARCHAR2(255)

GTVLETR

GTVLETR_DESC

NO

NO MAILING HISTORY
MAIL_LETTER_CODE_SD Mail letter code short description. VARCHAR2(255)

GTVLETR

GTVLETR_DESC

NO

NO MAILING HISTORY
MAIL_SYSTEM Identifies the Banner source module from which the mailing originated. VARCHAR2(63)

GURMAIL

GURMAIL_SYSTEM_IND

NO

NO MAILING HISTORY
MAIL_SYSTEM_LD Mail system long description. VARCHAR2(255)

GTVSYSI

GTVSYSI_DESC

NO

NO MAILING HISTORY
MAIL_SYSTEM_SD Mail system short description. VARCHAR2(255)

GTVSYSI

GTVSYSI_DESC

NO

NO MAILING HISTORY
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

SYSTEM_LOAD_PROCESS

'MAILING_ATTRIBUTE_D1B'

NO

NO MAILING HISTORY
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_01   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_01_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_01_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_02   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_02_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_02_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_03   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_03_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_03_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_04   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_04_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_04_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_05   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_05_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_05_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO


Ver: 9.0