RETURN TO BANNER EDW META DATA REPORTS LIST

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_MAIL_LIST_ATTRIBUTE

Description Mail list attribute dimension table provides information about the mailing lists to which constituents are assigned. 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
MAIL_LIST_ATTRIBUTE_KEY   NUMBER       NO
MAIL_LIST_SOURCE_CODE Mail list source (athletic news, holiday cards, etc.). VARCHAR2(63)       NO
MAIL_LIST_SOURCE_CODE_LD Mail list source long description. VARCHAR2(255)       NO
MAIL_LIST_SOURCE_CODE_SD Mail list source short description. VARCHAR2(255)       NO
MAIL_LIST_STATUS_CODE Identifies the current status of the mail list (active, past, archived, etc.) for the constituent. VARCHAR2(63)       NO
MAIL_LIST_STATUS_CODE_LD Mail list status long description. VARCHAR2(255)       NO
MAIL_LIST_STATUS_CODE_SD Mail list status short description. VARCHAR2(255)       NO
MAIL_LIST_TYPE Type of mailing associated with this mail list code. VARCHAR2(63)       NO
MAIL_LIST_TYPE_LD Mail list type long description. VARCHAR2(255)       NO
MAIL_LIST_TYPE_SD Mail list type short description. VARCHAR2(255)       NO
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)       NO
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE       NO
USER_ATTRIBUTE_01   VARCHAR2(63)       NO
USER_ATTRIBUTE_01_LD   VARCHAR2(255)       NO
USER_ATTRIBUTE_01_SD   VARCHAR2(255)       NO
USER_ATTRIBUTE_02   VARCHAR2(63)       NO
USER_ATTRIBUTE_02_LD   VARCHAR2(255)       NO
USER_ATTRIBUTE_02_SD   VARCHAR2(255)       NO
USER_ATTRIBUTE_03   VARCHAR2(63)       NO
USER_ATTRIBUTE_03_LD   VARCHAR2(255)       NO
USER_ATTRIBUTE_03_SD   VARCHAR2(255)       NO
USER_ATTRIBUTE_04   VARCHAR2(63)       NO
USER_ATTRIBUTE_04_LD   VARCHAR2(255)       NO
USER_ATTRIBUTE_04_SD   VARCHAR2(255)       NO
USER_ATTRIBUTE_05   VARCHAR2(63)       NO
USER_ATTRIBUTE_05_LD   VARCHAR2(255)       NO
USER_ATTRIBUTE_05_SD   VARCHAR2(255)       NO


Ver: 9.0