RETURN TO BANNER EDW META DATA REPORTS LIST
Email Star
SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_EMAIL_COMMENT
Description
Email comment dimension table provides comments about a constiutent's email address. 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_COMMENT
Free form comments related to this email address.
VARCHAR2(4000)
GOREMAL
GOREMAL_COMMENT
NO
NO
EMAIL
EMAIL_COMMENT_KEY
System generated, unique, internal primary key for an email comment.
NUMBER
NO
SYSTEM_LOAD_PROCESS
Name of the transformation that created the row during the load activity process.
VARCHAR2(30)
SYSTEM_LOAD_PROCESS
'EMAIL_COMMENT_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