RETURN TO BANNER EDW META DATA REPORTS LIST
Exclusion Star
SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_EXCLUSION
Description
Exclusion dimension table provides information about exclusions. 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
EXCLUSION
Type of solicitation's from which the constituent should be excluded.
VARCHAR2(63)
ATVEXCL
ATVEXCL_CODE
NO
NO
EXCLUSION
EXCLUSION_KEY
System generated, unique, internal primary key for the exclusion.
NUMBER
NO
EXCLUSION_LD
Exclusion long description.
VARCHAR2(255)
ATVEXCL
ATVEXCL_DESC
NO
NO
EXCLUSION
EXCLUSION_SD
Exclusion short description.
VARCHAR2(255)
ATVEXCL
ATVEXCL_DESC
NO
NO
EXCLUSION
SYSTEM_LOAD_PROCESS
Name of the transformation that created the row during the load activity process.
VARCHAR2(30)
SYSTEM_LOAD_PROCESS
'EXCLUSION_D1B'
NO
NO
EXCLUSION
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