Table Type: Realtime Data
This table stores real-time data about a conversation in a queue, or being handled after going through a queue.
As soon as a conversation is connected to a queue, a record is created in this table. The record is updated as the conversation progresses through the queue, and is never deleted.
(see the delete_queue_conversation_detail stored procedure to delete records from this table).
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| conversation_id | string | Primary Key | The unique identifier of the conversation |
| participant_id | string | Primary Key | The unique identifier of the participant |
| session_id | string | Primary Key | The unique identifier of the session |
| media_type | string | The media type of the session - one of: Voice, Email, Callback, Chat, Message | |
| db_last_updated | datetime | The last time this record was updated in the database | |
| db_when_created | datetime | The time this record was created in the database | |
| state | string | The state of the session - one of: Alerting, Dialing, Contacting, Converting, Offering, Connected, Disconnected, None, Terminated, Transmitting, Parked, Scheduled, Uploading | |
| initial_state | string | The initial state of the session - one of: Alerting, Dialing, Contacting, Converting, Offering, Connected, Disconnected, None, Terminated, Transmitting, Parked, Scheduled, Uploading | |
| disconnect_type | string | The type of disconnect for the session - one of: Endpoint, Endpointdnd, Client, System, Timeout, Transfer, Transferconference, Transferconsult, Transferforward, Transfernoanswer, Transfernotavailable, Transferdnd, Transportfailure, Error, Peer, Other, Spam, Uncallable | |
| direction | string | The direction of the session - one of: Inbound, Outbound | |
| connected_time | datetime | The datetime the session was connected | |
| disconnected_time | datetime | The datetime the session was disconnected | |
| uui_data | string | User to User Information (UUI) data managed by SIP session application. | |
| acw_state | string | The state of the after-call work - one of: Unknown, Skipped, Pending, Complete, Notapplicable | |
| acw_start_time | datetime | The start datetime of the after-call work | |
| acw_end_time | datetime | The end datetime of the after-call work |