Target Column	Business Definition	Database Data Type	Source Name	Source Column
AUTHORATATIVE_SOURCE_KEY	System generated, unique, internal primary key to content this interaction row to the authoratative source database table.	NUMBER	REL_INTERACTIONLOG	AUTH_SOURCE_REFKEY
AUTHORATATIVE_SOURCE_TYPE	Source type identified through the system entry for this interaction.	VARCHAR2(255)	REL_INTERACTIONLOG	AUTH_SOURCE_TYPE
CREATOR_KEY	The Creator dimension table provides the name of the creator of various records in the relationship product.	NUMBER	REL_USER	PRIMARY_KEY
FIRST_INTERACTION_KEY	Identifies this interaction as the first interaction of any type, category and source for the person.	NUMBER	REL_INTERACTIONLOG	PRIMARY_KEY
INTERACTION_CATEGORY	Identifies the category associated with the interaction.	VARCHAR2(63)	REL_INTERACTIONLOG	CATEGORY_KEY
INTERACTION_CATEGORY_LD	Long description for the category of the interaction.	VARCHAR2(255)	REL_INTERACTIONCATEGORY	NAME
INTERACTION_CATEGORY_SD	Short description for the category of the interaction.	VARCHAR2(255)	REL_INTERACTIONCATEGORY	NVL(INTERNAL_CODE,NAME)
INTERACTION_DATE	Date the interaction was recorded.	DATE	REL_INTERACTIONLOG	INTERACTION_TIME
INTERACTION_SOURCE	Identifies the source of the interaction.	VARCHAR2(63)	REL_CODE	PRIMARY_KEY
INTERACTION_SOURCE_LD	Long description for the sourced of the interaction.	VARCHAR2(255)	REL_INTERACTIONLOG	NAME
INTERACTION_SOURCE_SD	Short description for the source of the interaction.	VARCHAR2(255)	REL_INTERACTIONLOG	SOURCE
INTERACTION_TIME	Time the interaction was recorded.	DATE	REL_INTERACTIONLOG	INTERACTION_TIME
INTERACTION_TYPE	Identifies the type of interaction.	VARCHAR2(63)	REL_INTERACTIONLOG	TYPE_KEY
INTERACTION_TYPE_LD	Long description for the type of the interaction.	VARCHAR2(255)	REL_INTERACTIONTYPE	NAME
INTERACTION_TYPE_SD	Short description for the type of the interaction.	VARCHAR2(255)	REL_INTERACTIONTYPE	NVL(INTERNAL_CODE,NAME)
LAST_INTERACTION_KEY	Identifies this interaction as the last interaction of any type, category and source for the person.	NUMBER	REL_INTERACTIONLOG	PRIMARY_KEY
PERSON_INTERACTION_KEY	System generated, unique, internal primary key for the person interaction combination.	NUMBER	REL_INTERACTIONLOG	PARTY_KEY
SUBJECT_LINE	Text line recorded by the system for system maintained for communication, campaign and PSP creation but entered by the user for the manual interaction.	VARCHAR2(150)	REL_INTERACTIONLOG	SUBJECT_LINE

Ver: