View Name:call_center_interact
View Number:5864
Group:CIM
Description:used for migrating old table_interact to new tables in CIM
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
interact_objidinteractobjidobjid from interact table 3 (UNIQUE)
interact_idinteractinteract_idUnique, system-managed, interaction identifier 
create_dateinteractcreate_dateThe create date and time of the interact object 
inserted_byinteractinserted_byProcess which created the interact object 
external_idinteractexternal_idTracking ID from an external system 
directioninteractdirectionThe direction of the interaction; e.g., inbound, outbound, etc. From user-defined popup list with default name Interaction Direction 
typeinteracttypeThe type of interaction; e.g., call, email, letter, fax, etc. From user-defined popup list with default name Interaction Type 
origininteractoriginActual source of interaction. This is from a user-defined popup with default name Interaction Origin 
productinteractproductInformal product identification. This is from a user-defined popup with default name Interaction Product 
reason_1interactreason_1Categorization of the reason for the interaction. From user-defined popup list with default name Interaction Reason_1 
reason_2interactreason_2Categorization of the reason for the interaction. From user-defined popup list with default name Interaction Reason_2 
reason_3interactreason_3Categorization of the reason for the interaction. From user-defined popup list with default name Interaction Reason_3 
resultinteractresultStandard result code. From user-defined popup list with default name Interaction Result Code 
done_in_oneinteractdone_in_oneCompleted during the interaction; i.e., 0=no, 1=yes, default=0 
fee_basedinteractfee_basedIndicates whether the interaction has a fee; i.e., 0=no 1=yes, default=0 
wait_timeinteractwait_timeLength of time in seconds the customer spent waiting for service 
system_timeinteractsystem_timeComputed length of the interaction. End_date minus start_date in seconds 
entered_timeinteractentered_timeManually entered length of the interaction in seconds. Allows agent to override computed time. Defaults to system_time 
pay_optioninteractpay_optionType 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 
titleinteracttitleSummary of what took place 
start_dateinteractstart_dateThe start date and time of the interaction 
end_dateinteractend_dateThe finish date and time of the interaction 
last_nameinteractlast_nameRespondent last name 
first_nameinteractfirst_nameRespondent first name 
phoneinteractphoneRespondent primary phone number which includes area code, number, and extension. Defaulted from contact phone 
fax_numberinteractfax_numberRespondent fax number which includes area code, number, and extension. Defaulted from contact.fax_number 
emailinteractemailRespondent e-mail address. Defaults from contact.e_mail 
zipcodeinteractzipcodeRespondent zipcode defaulted from contact/site/address zipcode 
arch_indinteractarch_indWhen set to 1, indicates the object is ready for purge/archive 
agentinteractagentClarify user login name or external agent name 2
devinteractdevRow version number for mobile distribution purposes 151
serial_nointeractserial_noInstalled part's serial number 
mobile_phoneinteractmobile_phoneContact's mobile phone number which includes area code, number, and extension 
notesinteract_txtnotesNotes describing additional information about an interaction 23
interact2useruserobjidUser who administered the interaction 
interact2contactcontactobjidRelated contact if respondent was a contact 
interact2casecaseobjidCase that was covered in the interaction 
interact2opportunityopportunityobjidOpportunity that was covered in the interaction 

Joins:

Join FromJoin To
(interact).interact2user(user).user2interact
(interact).interact2contact(contact).contact2interact
(interact).interact2caseOUTER (case).case2interact
(interact).interact2opportunityOUTER (opportunity).opp2interact
OUTER (interact_txt).interact_txt2interact(interact).interact2interact_txt
My Recent Objects
call_center_interact