| Table Name: | communication |
| Table Number: | 5208 |
| Group: | Mixed Media |
| Description: | Records an instance of a communication on a channel; e.g., a specific email |
| Flags: | CACHEOBJIDS |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| auto_exec_ind | LONG | tinyint | 0 | DIRECT | Indicates if the communication was generated and sent without review; i.e., 0=no, suggested only, 1=yes, sent automatically, default=0. Derives from cl_action.auto_exec_ind at time of rule execution | Search (2) | ||
| creation_time | CLK_TIME | datetime | 1 | Date and time the communication was created | Search (2) | |||
| delivery_status | LONG | tinyint | 0 | DIRECT | The delivery status of the communication; i.e., 0=draft, 1=pending, 2=sent, 3=received, 4=failed, 5=bounced, default=0 | Search (3) | ||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | Search (1) | |
| direction | LONG | tinyint | 0 | DIRECT | The direction of the communication; i.e., 0=unknown, 1=inbound, 2=outbound, 3=both, default=0 | Search (3) | ||
| from_address | CHAR | varchar | 255 | For email, contains the email address of the sender | Search (3) | |||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (3) | ||
| priority | LONG | int | 3 | DIRECT | Priority of the email; 1=urgent; 3=normal; 5=low; default=3 | Search (1) | ||
| text | CHAR | text | 23 | ALLOW_NULL | Text of the communication after conversion from any medium-specific data format | Search (2) | ||
| title | CHAR | varchar | 2 | 255 | Title or subject of the communication | Search (3) | ||
| to_list | CHAR | varchar | 255 | Contains the list of the TO addresses | Search (3) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views | Set Name | Type ID Stored in | Objid Stored In |
|---|---|---|---|---|---|---|---|---|---|---|
| Exclusive Set Relations | ||||||||||
| communication2channel | MTO | channel | channel2communication | Channel on which the communication occurred | Search (1) | |||||
| cmcn2channel_inst | OTOF | channel_inst | ch_inst2communication | A channel instance related to communication | ||||||
| cmcn2cmcn_email | OTOF | cmcn_email | cmcn_email2communication | Details of an e-mail communication | ||||||
| communication2dialogue | MTO | dialogue | dialogue2communication | Dialogue in which the communication occurred | Search (2) | |||||
| cmcn2doc_inst | OTM | doc_inst | doc_inst2communication | Attachments to the communication | ||||||
| cmcn2edr_com_role | OTM | edr_com_role | edr_role2communication | Electronic address roles for the communication | ||||||
| cmcn_respons2gbst_elm | MTO | gbst_elm | resp2communication | Requested response type of the communication | ||||||
| cmcn2intrxncmcn | OTM | intrxncmcn | intrxn2communication | Interaction for a communication | ||||||
| cmcn2r_rqst | OTM | r_rqst | r_rqst2communication | Routing requests for the communication | route_for | source_type | source_lowid | |||
| cmcn2template | MTO | template | tmplt2communication | For communications generated from a template, the template generated from | ||||||
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_communication2dialogue | communication2dialogue | nonclustered located on PRIMARY |
| ind_creation_time | creation_time | nonclustered located on PRIMARY |
| ind_from_address | from_address | nonclustered located on PRIMARY |
| ind_title | title | nonclustered located on PRIMARY |
| ind_to_list | to_list | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5377 | dlg_cmcn | channel, communication, dialogue, medium |
| 5449 | eaddr_cmcn | communication, dialogue, e_addr, edr_com_role |
| 5862 | communication_list | communication, intrxn, intrxncmcn |
| communication | |||