RETURN TO BANNER EDW META DATA REPORTS LIST
Interest Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_INTEREST

Description Interest dimension table provides all data related to interests tracked for persons.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
INTEREST Type of outside interest associated with the prospect. VARCHAR2(63)

INTEREST

INTEREST

NO

NO INTEREST
INTEREST_KEY Key for the interest dimension. NUMBER

ETL GENERATED

NA

NO

NO INTEREST
INTEREST_LD Long description for the type of interest. VARCHAR2(255)

INTEREST

INTEREST_DESC

NO

NO INTEREST
INTEREST_SD Short description for the type of interest. VARCHAR2(255)

INTEREST

INTEREST_DESC

NO

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

ETL GENERATED

NA

NO

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

ETL GENERATED

NA

NO

NO INTEREST


Ver: 9.0