RETURN TO BANNER EDW META DATA REPORTS LIST
Constituent Evaluation Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_CONSTITUENT_EVAL_DETAIL

Description Constituent evaluation detail dimension table provides detail information for each evaluation. 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
CONSTITUENT_EVAL_DETAIL_KEY   NUMBER       NO
EVALUATION_CATEGORY Warehouse attribute that identifies evaluation association. For Advance; values are Constituent, Prospect, or Program Prospect. For Banner; will always be Prospect. VARCHAR2(63)

CONSTANT

'PROSPECT'

NO

NO
EVALUATION_CATEGORY_LD Evaluation category long description VARCHAR2(255)

CONSTANT

'PROSPECT'

NO

NO
EVALUATION_CATEGORY_SD Evaluation category short description VARCHAR2(255)

CONSTANT

'PROSPECT'

NO

NO
EVALUATION_COMMENT Evaluation comment. May contain additional information about this evaluation for the constituent, prospect or program prospect. VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
EVALUATION_ID This is a generated unique number for this record. VARCHAR2(255)

EXPRESSION

EVALUATION_ID_EXPRESSION

NO

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

SYSTEM_LOAD_PROCESS

'CONSTITUENT_EVAL_DETAIL_D1B'

NO

NO CONSTITUENT EVALUATION
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