RETURN TO BANNER EDW META DATA REPORTS LIST
Geographic Region Star  

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_GEOGRAPHIC_REGION

Description Geographic region fact table provides keys to associate each geo-region associated with a constituent's address and a distinct count of geo region associations for the constituent.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ADDRESS_GEO_GROUP_KEY   NUMBER

EXP_KEYS

ADDRESS_GEO_GROUP_KEY_EXPRESSION

NO

NO GEOGRAPHIC REGION
ADDRESS_SEQ Part of key structure for isolating unique constituent addresses. For Banner: sequence used to identify different addresses within the same address type. For Advance: sequence is used to isolate a single address, regardless of address type. NUMBER

EXPRESSION_LKP

ADDRESS_SEQ_EXPRESSION

NO

NO GEOGRAPHIC REGION
ADDRESS_TYPE_KEY   NUMBER

CLN_ADDRESS_TYPE

ADDRESS_TYPE_KEY

NO

NO GEOGRAPHIC REGION
ENTITY_KEY System generated, unique, internal primary key for an entity. NUMBER

CLN_ENTITY

ENTITY_KEY

NO

NO GEOGRAPHIC REGION
ENTITY_UID System generated unique internal identification number assigned to this person or organization. NUMBER

WDT_WAREHOUSE_ENTITY

WAREHOUSE_ENTITY_UID

NO

NO GEOGRAPHIC REGION
GEOGRAPHIC_REGION_KEY   NUMBER

CLN_GEOGRAPHIC_REGION

GEOGRAPHIC_REGION_KEY

NO

NO GEOGRAPHIC REGION
GEO_REGION_COUNT Count of unique division-region combinations associated with the entity's addresses. NUMBER

EXP_KEYS

GEO_REGION_COUNT_EXPRESSION

NO

NO GEOGRAPHIC REGION
MULTI_SOURCE_KEY   NUMBER

CLN_MULTI_SOURCE

MULTI_SOURCE_KEY

NO

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

LOAD_PROCESS

'GEOGRAPHIC_REGION_F1B'

NO

NO GEOGRAPHIC REGION
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


Ver: 9.0