RETURN TO BANNER EDW META DATA REPORTS LIST
Email Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_EMAIL_ATTRIBUTE

Description Email attribute dimension table provides information about email addresses. 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
EMAIL_ADDRESS_STATUS Status that indicates active or inactive for the email address. VARCHAR2(63)

GOREMAL

GOREMAL_STATUS_IND

NO

NO EMAIL
EMAIL_ADDRESS_STATUS_LD Email address status long description. VARCHAR2(255)

EXPRESSION_0

EMAIL_ADDRESS_STATUS_LD_EXPRESSION

NO

NO EMAIL
EMAIL_ADDRESS_STATUS_SD Email address status short description. VARCHAR2(255)

EXPRESSION_0

EMAIL_ADDRESS_STATUS_SD_EXPRESSION

NO

NO EMAIL
EMAIL_ATTRIBUTE Site-specific value associated with the email address record. VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
EMAIL_ATTRIBUTE_KEY System generated, unique, internal primary key for an email attribute. NUMBER       NO
EMAIL_ATTRIBUTE_LD Email address attribute long description. VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
EMAIL_ATTRIBUTE_SD Email address attribute short description. VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

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

SYSTEM_LOAD_PROCESS

'EMAIL_ATTRIBUTE_D1B'

NO

NO EMAIL
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