Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACTIVE_PHONE_IND	Indicates the phone number is active or inactive.	NUMBER	GROUP_COUNT_EXPRESSIONS	ACTIVE_PHONE_IND_EXPRESSION	NO	NO	PHONE
ENTITY_KEY	System generated, unique, internal primary key for a constituent entity.	NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	PHONE
ENTITY_UID	System generated unique internal identification number assigned to this constituent.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	PHONE
MULTI_SOURCE_KEY	System generated, unique, internal primary key for the multi-institution facility.	NUMBER	CLN_MULTI_SOURCE	MULTI_SOURCE_KEY	NO	NO	PHONE
PHONE_ADDRESS_SEQNO		NUMBER	SPRTELE	SPRTELE_ADDR_SEQNO	NO	NO	PHONE
PHONE_ADDRESS_TYPE_KEY	Type of address associated to this telephone record. For example, address types of mailing, temporary summer, billing and permanent.	NUMBER	CLN_ADDRESS_TYPE	ADDRESS_TYPE_KEY	NO	NO	PHONE
PHONE_COMMENT_KEY	Free form comments related to this phone number.	NUMBER	CLN_PHONE_COMMENT	PHONE_COMMENT_KEY	NO	NO	PHONE
PHONE_COUNT	Measure for total number of phone numbers for the entity_uid.	NUMBER	GROUP_COUNT_EXPRESSIONS	PHONE_COUNT_EXPRESSION	NO	NO	PHONE
PHONE_CURRENT_GROUP_KEY	Current Phone Group KEY.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
PHONE_GROUP_KEY	Phone Group KEY.	NUMBER	GROUP_COUNT_EXPRESSIONS	PHONE_GROUP_KEY_EXPRESSION	NO	NO	PHONE
PHONE_KEY	System generated, unique, internal primary key for a phone.	NUMBER	CLN_PHONE	PHONE_KEY	NO	NO	PHONE
PHONE_SEQ_NUMBER	Unique one-up sequence number assigned to each telphone identified for this constituent.	NUMBER	SPRTELE	SPRTELE_SEQNO	NO	NO	PHONE
PHONE_START_DATE_PARTIAL	Start date for this telephone.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
PHONE_STOP_DATE_PARTIAL	Stop date for this telephone.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
PHONE_TYPE_KEY	System generated, unique, internal primary key for a phone type.	NUMBER	CLN_PHONE_TYPE	PHONE_TYPE_KEY	NO	NO	PHONE
PHONE_UNLISTED_IND	Indicates whether this telephone number is unlisted.	NUMBER	GROUP_COUNT_EXPRESSIONS	PHONE_UNLISTED_IND_EXPRESSION	NO	NO	PHONE
PRIMARY_PHONE_IND	Indicator to denote primary telephone numbers.	NUMBER	GROUP_COUNT_EXPRESSIONS	PRIMARY_PHONE_IND_EXPRESSION	NO	NO	PHONE
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	SYSTEM_LOAD_PROCESS	'PHONE_F1B'	NO	NO	PHONE
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