| View Name: | contact_interaction |
| View Number: | 5846 |
| Group: | CIM |
| Description: | View for interactions related to contact. Used in interaction_home_html_2_contact_tab.jsp JSP page |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| channel_inst_objid | channel_inst | objid | Channel inst internal record number | 3 (UNIQUE) |
| contact_objid | contact | objid | contact internal record number | |
| interaction_objid | intrxn | objid | Interaction internal record number | |
| create_on | intrxn | start_time | Date and time the interaction was started | |
| title | intrxn | title | Summary of what took place | |
| type | medium | title | Common name of the medium | |
| direction | intrxn | direction | The direction of the interaction; i.e 0=unknown, 1=inbound, 2=outbound |
| Join From | Join To |
|---|---|
| (intrxn).intrxn2contact | (contact).contact2intrxn |
| (channel_inst).channel_inst2intrxn | (intrxn).intrxn2channel_inst |
| (channel_inst).channel_inst2channel | (channel).channel2channel_inst |
| (channel).channel2medium | (medium).medium2channel |
| contact_interaction | |||