Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
CONTACTED_NAME	Contacted prospect name.	VARCHAR2(255)	CONSTANT	'NOT APPLICABLE'	NO	NO
CONTACTED_SORT_NAME	Contact name used for sorting purposes.	VARCHAR2(255)	CONSTANT	'NOT APPLICABLE'	NO	NO
CONTACT_ACTION_COMMENT	This field specifies the message.	VARCHAR2(255)	AMRCONT	AMRCONT_TICKLER	NO	NO	CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE
CONTACT_ACTION_STATUS	Specifies the contact action status. Values are P (pending), C (complete), N (No Status). If no next action, null (No Data Avail).	VARCHAR2(63)	AMRCONT	AMRCONT_TICK_STATUS	NO	NO	CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE
CONTACT_ACTION_STATUS_LD	Long description of the contact action status.	VARCHAR2(255)	EXPRESSION	CONTACT_ACTION_STATUS_LD_EXPRESSION	NO	NO	CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE
CONTACT_ACTION_STATUS_SD	Short description of the contact action status.	VARCHAR2(255)	EXPRESSION	CONTACT_ACTION_STATUS_SD_EXPRESSION	NO	NO	CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE
CONTACT_DESCRIPTION	Contact brief description.	VARCHAR2(4000)	AMRCONT	AMRCONT_CONTACT	NO	NO	CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE
CONTACT_REPORT_DETAIL	Detailed call report summary.	VARCHAR2(4000)	NO SOURCE	NO SOURCE	NO	NO
CONTACT_REPORT_ID	System generated unique number for the report id.	NUMBER	EXPRESSION	CONTACT_REPORT_ID_EXPRESSION	NO	NO	CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE
CONTACT_REPORT_KEY		NUMBER				NO
CONTACT_STRATEGY	Strategy plan associated with this contact.	VARCHAR2(63)	AMRCONT	AMRCONT_STGY_PLAN	NO	NO	CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE
CONTACT_STRATEGY_LD	Long description of the contact strategy plan.	VARCHAR2(255)	AMRCONT	AMRCONT_STGY_PLAN	NO	NO	CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE
CONTACT_STRATEGY_SD	Short description of the contact strategy plan.	VARCHAR2(255)	AMRCONT	AMRCONT_STGY_PLAN	NO	NO	CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE
JOINT_CONTACT_REPORT_IND	Indicates whether both husband and wife were contacted.	NUMBER	CONSTANT	0	NO	NO	CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE
REPRESENTATIVE_NAME	Representative name.	VARCHAR2(255)	CONSTANT	'NOT APPLICABLE'	NO	NO
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	SYSTEM_LOAD_PROCESS	'CONTACT_REPORT_D1B'	NO	NO	CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_01		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_01_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_01_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_02		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_02_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_02_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_03		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_03_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_03_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_04		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_04_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_04_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_05		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_05_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_05_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO

Ver: 9.0