Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
CONSTITUENT_INTEREST_COUNT_KEY		NUMBER	GROUP_COUNT_EXPRESSIONS	CONSTITUENT_INTEREST_COUNT_KEY_EXPRESSION	NO	NO	CONSTITUENT INTEREST
CONSTITUENT_INTEREST_GROUP_KEY		NUMBER	GROUP_COUNT_EXPRESSIONS	CONSTITUENT_INTEREST_GROUP_KEY_EXPRESSION	NO	NO	CONSTITUENT INTEREST
CONSTITUENT_INTEREST_KEY		NUMBER	CLN_CONSTITUENT_INTEREST	CONSTITUENT_INTEREST_KEY	NO	NO	CONSTITUENT INTEREST
ENTITY_KEY	System generated, unique, internal primary key for an entity.	NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	CONSTITUENT INTEREST
ENTITY_UID	System generated unique internal identification number assigned to this person or organization.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	CONSTITUENT INTEREST
INTEREST_SEQNO	Sequence used to identify interests for a constituent.	NUMBER				NO
INTEREST_START_DATE_PARTIAL	Optional start date for constituent interest.	VARCHAR2(255)				NO
INTEREST_STOP_DATE_PARTIAL	Optional stop date for constituent interest.	VARCHAR2(255)				NO
MULTI_SOURCE_KEY		NUMBER	CLN_MULTI_SOURCE	MULTI_SOURCE_KEY	NO	NO	CONSTITUENT INTEREST
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	LOAD_PROCESS	'CONSTITUENT_INTEREST_F1B'	NO	NO	CONSTITUENT INTEREST
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