RETURN TO BANNER EDW META DATA REPORTS LIST
Constituent Profile Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_CONSTITUENT_PROFILE_DETAIL

Description Constituent profile detail dimension table provides detail information for each profile. 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
AFFLUENCE This column identifies the affluence category assigned to this entity. VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
CONSTITUENT_PROFILE_DETAIL_KEY   NUMBER       NO
LIFESTYLE This column identifies the socioeconomic lifestyle category assigned to the entity. VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
POTENTIAL Potential ADVANCE: This identities the ranking priority for investigating this entity. Value BANNER: This specifies the value provided by the external rating source. VARCHAR2(63)

AMREXRT

AMREXRT_EXT_VALUE

NO

NO CONSTITUENT PROFILE
PROFILE_COMMENT Profile comment. General comments for this demographic profile. VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
PROFILE_ID System generated, unique, identifier for a constituent profile. VARCHAR2(255)

EXPRESSION

PROFILE_ID_EXPRESSION

NO

NO CONSTITUENT PROFILE
RANK For Advance (Rank): This value is the rank order defined for the entity. For Banner (Score): This field specifies the score of external rating. VARCHAR2(63)

AMREXRT

AMREXRT_EXT_SCORE

NO

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

SYSTEM_LOAD_PROCESS

'CONSTITUENT_PROFILE_DETAIL_D1B'

NO

NO CONSTITUENT PROFILE
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
WEIGHT This column identifies a comprehensive weighted score based upon evaluation of multiple factors. VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO


Ver: 9.0