Table Name:	interact
Table Number:	5225
Group:	Customer Mgr
Description:	Records interactions with prospects or contacts. Used by forms Interactions (11500) and Select Interacts (11511)
Flags:	CACHEOBJIDS
Baseline/Custom:	Baseline

select * from table_interact

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
agent	CHAR	varchar	2	30			Clarify user login name or external agent name	Search (2)
arch_ind	LONG	int				DIRECT, ALLOW_NULL	When set to 1, indicates the object is ready for purge/archive	Search (1)
create_date	CLK_TIME	datetime					The create date and time of the interact object	Search (1)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes	Search (1)
direction	CHAR	varchar		40			The direction of the interaction; e.g., inbound, outbound, etc. From user-defined popup list with default name Interaction Direction	Search (2)
done_in_one	LONG	tinyint			0	DIRECT	Completed during the interaction; i.e., 0=no, 1=yes, default=0	Search (2)
email	CHAR	varchar		80			Respondent e-mail address. Defaults from contact.e_mail	Search (1)
end_date	CLK_TIME	datetime					The finish date and time of the interaction	Search (1)
entered_time	LONG	int				DIRECT	Manually entered length of the interaction in seconds. Allows agent to override computed time. Defaults to system_time	Search (1)
external_id	CHAR	varchar		40			Tracking ID from an external system	Search (1)
fax_number	CHAR	varchar		20			Respondent fax number which includes area code, number, and extension. Defaulted from contact.fax_number	Search (1)
fee_based	LONG	tinyint			0	DIRECT	Indicates whether the interaction has a fee; i.e., 0=no 1=yes, default=0	Search (1)
first_name	CHAR	varchar		30			Respondent first name	Search (1)
inserted_by	CHAR	varchar		40			Process which created the interact object	Search (1)
interact_id	CHAR	varchar		40			Unique, system-managed, interaction identifier	Search (2)
last_name	CHAR	varchar		30			Respondent last name	Search (1)
mobile_phone	CHAR	varchar		20		ALLOW_NULL	Contact's mobile phone number which includes area code, number, and extension	Search (1)
objid	LONG	int	3			DIRECT	Internal record number	Search (2)
origin	CHAR	varchar		40			Actual source of interaction. This is from a user-defined popup with default name Interaction Origin	Search (1)
pay_option	CHAR	varchar		40			Type of payment for the interaction; e.g., contract, incident, pay-per-call, etc. From user defined pop up list with default name Interaction Pay Option	Search (1)
phone	CHAR	varchar		20			Respondent primary phone number which includes area code, number, and extension. Defaulted from contact phone	Search (1)
product	CHAR	varchar		80			Informal product identification. This is from a user-defined popup with default name Interaction Product	Search (2)
reason_1	CHAR	varchar		40			Categorization of the reason for the interaction. From user-defined popup list with default name Interaction Reason_1	Search (2)
reason_2	CHAR	varchar		40			Categorization of the reason for the interaction. From user-defined popup list with default name Interaction Reason_2	Search (2)
reason_3	CHAR	varchar		20			Categorization of the reason for the interaction. From user-defined popup list with default name Interaction Reason_3	Search (1)
result	CHAR	varchar		40			Standard result code. From user-defined popup list with default name Interaction Result Code	Search (2)
serial_no	CHAR	varchar		30		ALLOW_NULL	Installed part's serial number	Search (1)
start_date	CLK_TIME	datetime					The start date and time of the interaction	Search (2)
system_time	LONG	int			0	DIRECT	Computed length of the interaction. End_date minus start_date in seconds	Search (1)
title	CHAR	varchar		255			Summary of what took place	Search (2)
type	CHAR	varchar		40			The type of interaction; e.g., call, email, letter, fax, etc. From user-defined popup list with default name Interaction Type	Search (2)
wait_time	LONG	int			0	DIRECT	Length of time in seconds the customer spent waiting for service	Search (1)
zipcode	CHAR	varchar		20			Respondent zipcode defaulted from contact/site/address zipcode	Search (1)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	Used in Views
interact2blg_argmnt	MTO	blg_argmnt	blg_argmnt2interact	Billing arrangement used by an interaction
interact2case	MTO	case	case2interact	Case that was covered in the interaction		Search (1)
interact2contact	MTO	contact	contact2interact	Related contact if respondent was a contact		Search (2)
interact2doc_inst	OTM	doc_inst	doc_inst2interact	Related attachments
interact2fin_accnt	MTO	fin_accnt	fin_accnt2interact	Financial account used by an interaction
first2interact	OTM	interact	member2interact	The remaining interactions which took place during a call
member2interact	MTO	interact	first2interact	The first interaction that took place during a call
interact2interact_txt	OTM	interact_txt	interact_txt2interact	Extended description of the interaction
interact2lead_source	MTO	lead_source	source2interact	Related lead source
interact2mod_level	MTO	mod_level	part_info2interact	Product revision that was covered in the interaction
interact2notes_log	OTM	notes_log	notes_log2interact	Note Logs for the interaction	USER_DEFINED
interact2opportunity	MTO	opportunity	opp2interact	Opportunity that was covered in the interaction		Search (1)
interact2pay_channel	MTO	pay_channel	pay_channel2interact	Pay channel used by an interaction
interact2scr_run	OTM	scr_run	scr_run2interact	Scripts that were run during the interaction
interact2site	MTO	site	site2interact	Interactions for this site	USER_DEFINED	Search (1)
interact2site_part	MTO	site_part	site_part2interact	Related installed_part
interact2user	MTO	user	user2interact	User who administered the interaction		Search (1)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
inderact_id_ind	interact_id	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_interact_agent	agent	nonclustered located on PRIMARY
ind_interact_email	email	nonclustered located on PRIMARY
ind_interact_last_name	last_name, first_name, phone	nonclustered located on PRIMARY
ind_interact_phone	phone	nonclustered located on PRIMARY
ind_interact_product	product	nonclustered located on PRIMARY
ind_interact2contact	interact2contact	nonclustered located on PRIMARY
ind_reason_1	reason_1, reason_2, reason_3	nonclustered located on PRIMARY
ind_start_date	start_date	nonclustered located on PRIMARY
ind_title	title	nonclustered located on PRIMARY
ind_type	type	nonclustered located on PRIMARY
inderact_id_ind	interact_id	nonclustered, unique located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
4608	interact_site	contact, interact, site
5864	call_center_interact	case, contact, interact, interact_txt, opportunity, user

My Recent Objects

interact

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user

alt-s	Execute SQL
alt-t	Execute SQL, getting latest 10 rows
?	Bring up this help dialog