Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ENTITY_KEY	System generated, unique, internal primary key for a constituent entity.	NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	SPECIAL PURPOSE
ENTITY_UID	System generated unique internal identification number assigned to this constituent.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	SPECIAL PURPOSE
MULTI_SOURCE_KEY	System generated, unique, internal primary key for the multi-institution facility.	NUMBER	CLN_MULTI_SOURCE	MULTI_SOURCE_KEY	NO	NO	SPECIAL PURPOSE
SPECIAL_PURPOSE_COMMENT_KEY	System generated, unique, internal primary key for a special purpose comment.	NUMBER	CLN_SPECIAL_PURPOSE_COMMENT	SPECIAL_PURPOSE_COMMENT_KEY	NO	NO	SPECIAL PURPOSE
SPECIAL_PURPOSE_COUNT	Count of distinct special purposes associated to the constituent.	NUMBER	GROUP_COUNT_EXPRESSIONS	SPECIAL_PURPOSE_COUNT_EXPRESSION	NO	NO	SPECIAL PURPOSE
SPECIAL_PURPOSE_DATE	Special purpose date.	DATE	EXPRESSION	SPECIAL_PURPOSE_DATE_EXPRESSION	NO	NO	SPECIAL PURPOSE
SPECIAL_PURPOSE_GROUP_KEY	Special Purpose Group KEY.	NUMBER	GROUP_COUNT_EXPRESSIONS	SPECIAL_PURPOSE_GROUP_KEY_EXPRESSION	NO	NO	SPECIAL PURPOSE
SPECIAL_PURPOSE_KEY	System generated, unique, internal primary key for a special purpose.	NUMBER	CLN_SPECIAL_PURPOSE	SPECIAL_PURPOSE_KEY	NO	NO	SPECIAL PURPOSE
SPECIAL_PURPOSE_RECORD_COUNT	Count of special purpose records associated to the constituent.	NUMBER	GROUP_COUNT_EXPRESSIONS	SPECIAL_PURPOSE_RECORD_COUNT_EXPRESSION	NO	NO	SPECIAL PURPOSE
SPECIAL_PURPOSE_TYPE_COUNT	Count of distinct special purpose types associated to the constituent.	NUMBER	GROUP_COUNT_EXPRESSIONS	SPECIAL_PURPOSE_TYPE_COUNT_EXPRESSION	NO	NO	SPECIAL PURPOSE
SPECIAL_PURPOSE_TYPE_KEY	System generated, unique, internal primary key for a special purpose type.	NUMBER	CLN_SPECIAL_PURPOSE_TYPE	SPECIAL_PURPOSE_TYPE_KEY	NO	NO	SPECIAL PURPOSE
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	SYSTEM_LOAD_PROCESS	'SPECIAL_PURPOSE_F1B'	NO	NO	SPECIAL PURPOSE
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