| View Name: | search_intrxn |
| View Number: | 5955 |
| Group: | CIM |
| Description: | Used for interaction search jsp page interaction_list.jsp |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| con_objid | contact | objid | contact internal record number | |
| interaction_objid | intrxn | objid | Interaction internal record number | |
| bus_org_objid | bus_org | objid | Interaction internal record number | |
| org_name | bus_org | name | Interaction internal record number | |
| topic_objid | topic | objid | Interaction internal record number | 3 (UNIQUE) |
| 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 | |
| reason_1 | topic | reason_1 | Reason_1 of the Topic | |
| first_name | contact | first_name | Contact first name | 15 |
| last_name | contact | last_name | Contact last name | 14 |
| Join From | Join To |
|---|---|
| (intrxn).intrxn2contact | (contact).contact2intrxn |
| (intrxn).intrxn2bus_org | OUTER (bus_org).bus_org2intrxn |
| (channel_inst).channel_inst2intrxn | (intrxn).intrxn2channel_inst |
| (channel_inst).channel_inst2channel | (channel).channel2channel_inst |
| (channel).channel2medium | (medium).medium2channel |
| (topic).topic2intrxn | (intrxn).intrxn2topic |
| search_intrxn | |||