Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACTIVE_EXCLUSION_COUNT	Number of distinct active exclusions assigned to this constituent.	NUMBER	EXPRESSION_0	ACTIVE_EXCLUSION_COUNT_EXPRESSION	NO	NO	EXCLUSION
ACTIVE_EXCLUSION_IND	Active exclusion indicator.	NUMBER	EXPRESSION	ACTIVE_EXCLUSION_IND_EXPRESSION	NO	NO	EXCLUSION
ENTITY_KEY	System generated, unique, internal primary key for a constituent entity.	NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	EXCLUSION
ENTITY_UID	System generated unique internal identification number assigned to this constituent.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	EXCLUSION
EXCLUDE_MAIL_IND	Indicates whether the exclusion is to exclude mail solicitations or not.	NUMBER	EXPRESSION	EXCLUDE_MAIL_IND_EXPRESSION	NO	NO	EXCLUSION
EXCLUDE_PHONE_IND	Indicates whether the exclusion is to exclude phone solicitations or not.	NUMBER	EXPRESSION	EXCLUDE_PHONE_IND_EXPRESSION	NO	NO	EXCLUSION
EXCLUSION_COMMENT_KEY	System generated, unique, internal primary key for an exclusion comment.	NUMBER	CLN_EXCLUSION_COMMENT	EXCLUSION_COMMENT_KEY	NO	NO	EXCLUSION
EXCLUSION_COUNT	Number of distinct exclusions for the constituent whether active, inactive or pending.	NUMBER	EXPRESSION_0	EXCLUSION_COUNT_EXPRESSION	NO	NO	EXCLUSION
EXCLUSION_GROUP_KEY	Exclusion Group KEY.	NUMBER	GROUP_COUNT_EXPRESSIONS	EXCLUSION_GROUP_KEY_EXPRESSION	NO	NO	EXCLUSION
EXCLUSION_KEY	System generated, unique, internal primary key for the exclusion.	NUMBER	CLN_EXCLUSION	EXCLUSION_KEY	NO	NO	EXCLUSION
EXCLUSION_RECORD_COUNT		NUMBER	EXPRESSION_0	EXCLUSION_RECORD_COUNT_EXPRESSION	NO	NO	EXCLUSION
EXCLUSION_START_DATE	Exclusion start date.	DATE	APREXCL	APREXCL_DATE	NO	NO	EXCLUSION
EXCLUSION_STOP_DATE	Exclusion stop date.	DATE	EXPRESSION	EXCLUSION_STOP_DATE_EXPRESSION	NO	NO	EXCLUSION
INACTIVE_EXCLUSION_IND	Inactive exclusion indicator.	NUMBER	EXPRESSION_0	INACTIVE_EXCLUSION_IND_EXPRESSION	NO	NO	EXCLUSION
MULTI_SOURCE_KEY	System generated, unique, internal primary key for the multi-institution facility.	NUMBER	CLN_MULTI_SOURCE	MULTI_SOURCE_KEY	NO	NO	EXCLUSION
PENDING_EXCLUSION_IND	Pending exclusion indicator.	NUMBER	EXPRESSION	PENDING_EXCLUSION_IND_EXPRESSION	NO	NO	EXCLUSION
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	SYSTEM_LOAD_PROCESS	'EXCLUSION_F1B'	NO	NO	EXCLUSION
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