RETURN TO BANNER EDW META DATA REPORTS LIST
Membership Club Star
SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_MEMBERSHIP_CLUB
Description
Membership club dimension table identifies the membership club and description. 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_CLUB_KEY
NUMBER
NO
MEMBER_CLUB
Member club code
VARCHAR2(63)
NO SOURCE
NO SOURCE
NO
NO
MEMBER_CLUB_LD
Member club long description
VARCHAR2(255)
NO SOURCE
NO SOURCE
NO
NO
MEMBER_CLUB_SD
Member club short description
VARCHAR2(255)
NO SOURCE
NO SOURCE
NO
NO
SYSTEM_LOAD_PROCESS
Name of the transformation that created the row during the load activity process.
VARCHAR2(30)
SYSTEM_LOAD_PROCESS
'MEMBERSHIP_CLUB_D1B'
NO
NO
MEMBERSHIP CLUB
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