Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
CURRENT_MEMBER_IND	Current member indicator.	NUMBER	LKP_IND_EXPRESSION	CURRENT_MEMBER_IND_EXPRESSION	NO	NO	MEMBERSHIP
ENTITY_KEY	System generated, unique, internal primary key for an entity.	NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	MEMBERSHIP
ENTITY_UID	System generated unique internal identification number assigned to this person or organization.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	MEMBERSHIP
EXPIRED_MEMBER_IND	Expired membership indicator	NUMBER	LKP_IND_EXPRESSION	EXPIRED_MEMBER_IND_EXPRESSION	NO	NO	MEMBERSHIP
LIFETIME_MEMBER_IND	Indicates lifetime membership categories.	NUMBER	LKP_IND_EXPRESSION	LIFETIME_MEMBER_IND_EXPRESSION	NO	NO	MEMBERSHIP
MEMBERSHIP_CLUB_GROUP_KEY		NUMBER	CONSTANT_0	0	NO	NO	MEMBERSHIP
MEMBERSHIP_COUNT	Count distinct program codes by Entity_UID	VARCHAR2(252)	EXPRESSION	MEMBERSHIP_COUNT_EXPRESSION	NO	NO	MEMBERSHIP
MEMBERSHIP_COUNT_KEY		NUMBER	EXPRESSION	MEMBERSHIP_COUNT_KEY_EXPRESSION	NO	NO	MEMBERSHIP
MEMBERSHIP_GROUP_KEY		NUMBER	EXPRESSION	MEMBERSHIP_GROUP_KEY_EXPRESSION	NO	NO	MEMBERSHIP
MEMBERSHIP_INTEREST_GROUP_KEY		NUMBER	EXPRESSION_0	MEMBERSHIP_INTEREST_GROUP_KEY_EXPRESSION	NO	NO	MEMBERSHIP
MEMBERSHIP_KEY		NUMBER	CLN_MEMBERSHIP	MEMBERSHIP_KEY	NO	NO	MEMBERSHIP
MEMBERSHIP_RECORD_COUNT		NUMBER	EXPRESSION	MEMBERSHIP_RECORD_COUNT_EXPRESSION	NO	NO	MEMBERSHIP
MEMBER_NUMBER	Internal system assigned unique number for each member within a membership	NUMBER	LKP_IND_EXPRESSION	MEMBER_NUMBER_EXPRESSION	NO	NO	MEMBERSHIP
MEMBER_START_DATE	Member start date	DATE	EXPRESSION_0	MEMBER_START_DATE_EXPRESSION	NO	NO	MEMBERSHIP
MEMBER_STOP_DATE	Member stop date, which will be null for life membership.	DATE	EXPRESSION_0	MEMBER_STOP_DATE_EXPRESSION	NO	NO	MEMBERSHIP
MEMB_PREV_NUMBER	Membership number from the last membership - for renewals - as a way of linking contiguous memberships together.	VARCHAR2(63)	CONSTANT_0	0	NO	NO	MEMBERSHIP
MULTI_SOURCE_KEY		NUMBER	CLN_MULTI_SOURCE	MULTI_SOURCE_KEY	NO	NO	MEMBERSHIP
NEW_MEMBER_IND	Indicates a new member.	NUMBER	CONSTANT_0	1	NO	NO	MEMBERSHIP
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	LOAD_PROCESS	'MEMBERSHIP_F1B'	NO	NO	MEMBERSHIP
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