| Table Name: | intrxn |
| Table Number: | 5830 |
| Group: | CIM |
| Description: | Records interactions with prospects or contacts |
| Flags: | CACHEOBJIDS |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| direction | LONG | tinyint | 1 | DIRECT | The direction of the interaction; i.e 0=unknown, 1=inbound, 2=outbound, 3=both | Search (3) | ||
| end_time | CLK_TIME | datetime | Date and time the interaction was ended | Search (1) | ||||
| notes | CHAR | text | ALLOW_NULL | Notes describing additional information about an interaction | Search (1) | |||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (6) | ||
| pay_option | CHAR | varchar | 40 | Type of payment for the interaction; e.g. non-billable, contract, incident, pay-per-call, etc. From user defined pop up list with default name Interaction Pay Option | Search (1) | |||
| start_time | CLK_TIME | datetime | Date and time the interaction was started | Search (4) | ||||
| title | CHAR | varchar | 255 | Summary of what took place | Search (4) | |||
| type | CHAR | varchar | 40 | The type of interaction. Eg: complaint, schedule pick-up, Literature Request, product interest, etc. | Search (1) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| intrxn2bus_org | MTO | bus_org | bus_org2intrxn | The customer (bus_org) for which the interaction is created | Search (3) | ||
| intrxn2channel_inst | OTM | channel_inst | channel_inst2intrxn | Channel on which the interaction occurred | |||
| intrxn2contact | MTO | contact | contact2intrxn | Contact for an interaction | Search (4) | ||
| intrxn2intrxncmcn | OTM | intrxncmcn | cmcn2intrxn | Communication for a interaction | |||
| intrxn2proc_inst | OTM | proc_inst | proc_inst2intrxn | Process/script run created interaction | |||
| intrxn2session | OTM | session | session2intrxn | Sessions related to interaction | |||
| intrxn2topic | OTM | topic | topic2intrxn | Topics covered in an interaction |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| i2bo5830 | intrxn2bus_org | nonclustered located on PRIMARY |
| i2c5830 | intrxn2contact | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5846 | contact_interaction | channel_inst, contact, intrxn, medium |
| 5849 | account_interaction | bus_org, channel_inst, contact, intrxn, medium |
| 5859 | interaction_overview | bus_org, channel, contact, intrxn, medium |
| 5860 | agent_list | employee, intrxn, session, user |
| 5862 | communication_list | communication, intrxn, intrxncmcn |
| 5955 | search_intrxn | bus_org, contact, intrxn, medium, topic |
| intrxn | |||