RETURN TO BANNER EDW META DATA REPORTS LIST
Membership Interest Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_MEMBERSHIP_INTEREST

Description Membership interest dimension table identifies the member interest and corresponding interest type, group and college. 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
MEMBERSHIP_INTEREST_KEY   NUMBER       NO
MEMBER_INTEREST Interest code. VARCHAR2(63)

AABMINT

AABMINT_INTEREST

NO

NO MEMBERSHIP INTEREST
MEMBER_INTEREST_COLLEGE Members interest college code VARCHAR2(63)

AABMINT

AABMINT_COLL_CODE

NO

NO MEMBERSHIP INTEREST
MEMBER_INTEREST_COLLEGE_LD Member Interest college associated membership VARCHAR2(255)

STVCOLL

STVCOLL_DESC

NO

NO MEMBERSHIP INTEREST
MEMBER_INTEREST_COLLEGE_SD Member interest college short description VARCHAR2(255)

STVCOLL

STVCOLL_DESC

NO

NO MEMBERSHIP INTEREST
MEMBER_INTEREST_GROUP Interest group code. VARCHAR2(63)

AABMINT

AABMINT_AMGP_CODE

NO

NO MEMBERSHIP INTEREST
MEMBER_INTEREST_GROUP_LD Interest group code long description VARCHAR2(255)

ATVAMGP

ATVAMGP_DESC

NO

NO MEMBERSHIP INTEREST
MEMBER_INTEREST_GROUP_SD Interest group code short description VARCHAR2(255)

ATVAMGP

ATVAMGP_DESC

NO

NO MEMBERSHIP INTEREST
MEMBER_INTEREST_LD Interest long description VARCHAR2(255)

AABMINT

AABMINT_NAME

NO

NO MEMBERSHIP INTEREST
MEMBER_INTEREST_SD Interest short description VARCHAR2(255)

AABMINT

AABMINT_NAME

NO

NO MEMBERSHIP INTEREST
MEMBER_INTEREST_TYPE Interest type code. VARCHAR2(63)

AABMINT

AABMINT_AMIN_CODE

NO

NO MEMBERSHIP INTEREST
MEMBER_INTEREST_TYPE_LD Interest type long description VARCHAR2(255)

ATVAMIN

ATVAMIN_DESC

NO

NO MEMBERSHIP INTEREST
MEMBER_INTEREST_TYPE_SD Interest type short description VARCHAR2(255)

ATVAMIN

ATVAMIN_DESC

NO

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

SYSTEM_LOAD_PROCESS

'MEMBERSHIP_INTEREST_D1B'

NO

NO MEMBERSHIP INTEREST
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