RETURN TO BANNER EDW META DATA REPORTS LIST
Phone Star
SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_PHONE_COMMENT
Description
Phone comment dimension table provides comments about a constiutent's phone number. 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
PHONE_COMMENT
Free form comments related to this phone number.
VARCHAR2(4000)
EXPRESSION_0
PHONE_COMMENT_EXPRESSION
NO
NO
PHONE
PHONE_COMMENT_KEY
Phone Comment KEY.
NUMBER
NO
SYSTEM_LOAD_PROCESS
Name of the transformation that created the row during the load activity process.
VARCHAR2(30)
SYSTEM_LOAD_PROCESS
'PHONE_COMMENT_D1B'
NO
NO
PHONE
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