RETURN TO BANNER EDW META DATA REPORTS LIST
Variable Purpose Star  

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_VARIABLE_PURPOSE

Description Variable purpose fact table provides measures for each variable purpose associated with a constituent.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ENTITY_KEY System generated, unique, internal primary key for an entity. NUMBER

CLN_ENTITY

ENTITY_KEY

NO

NO VARIABLE PURPOSE
ENTITY_UID   NUMBER

WDT_WAREHOUSE_ENTITY

WAREHOUSE_ENTITY_UID

NO

NO VARIABLE PURPOSE
MULTI_SOURCE_KEY   NUMBER

CLN_MULTI_SOURCE

MULTI_SOURCE_KEY

NO

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

SYSTEM_LOAD_PROCESS

'VARIABLE_PURPOSE_F1B'

NO

NO VARIABLE PURPOSE
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

NO SOURCE

NO SOURCE

NO

NO
USER_MEASURE_01   NUMBER

NO SOURCE

NO SOURCE

NO

NO
USER_MEASURE_02   NUMBER

NO SOURCE

NO SOURCE

NO

NO
USER_MEASURE_03   NUMBER

NO SOURCE

NO SOURCE

NO

NO
USER_MEASURE_04   NUMBER

NO SOURCE

NO SOURCE

NO

NO
USER_MEASURE_05   NUMBER

NO SOURCE

NO SOURCE

NO

NO
VARIABLE_PURPOSE_COUNT   NUMBER

GROUP_COUNT_EXPRESSIONS

VARIABLE_PURPOSE_COUNT_EXPRESSION

NO

NO VARIABLE PURPOSE
VARIABLE_PURPOSE_GROUP_KEY   NUMBER

GROUP_COUNT_EXPRESSIONS

VARIABLE_PURPOSE_GROUP_KEY_EXPRESSION

NO

NO VARIABLE PURPOSE
VARIABLE_PURPOSE_KEY   NUMBER

CLN_VARIABLE_PURPOSE

VARIABLE_PURPOSE_KEY

NO

NO VARIABLE PURPOSE


Ver: 9.0