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 |
| 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 | |
| screen_recording_state | string | The screen recording state of the conversation | |
| connected_time | datetime | The datetime the conversation was connected | |
| end_time | datetime | The datetime the conversation ended | |
| user_id | string | The ID of the user handling the conversation | |
| external_contact_id | string | The ID of the external contact | |
| external_organization_id | string | The ID of the external organization | |
| name | string | The name of the participant | |
| queue_id | string | The ID of the queue | |
| group_id | string | The ID of the group | |
| team_id | string | The ID of the team | |
| purpose | string | The purpose of the participant | |
| address | string | The address of the participant | |
| wrapup_required | boolean | Whether the participant must wrap up or not | |
| wrapup_expected | boolean | Whether the participant is expected to wrap up or not | |
| wrapup_prompt | string | The prompt for the wrapup | |
| wrapup_timeout_ms | int64 | The timeout for the wrapup in milliseconds | |
| wrapup_code | string | The code for the wrapup | |
| wrapup_notes | string | The notes for the wrapup | |
| wrapup_tags | string | The tags for the wrapup | |
| wrapup_duration_seconds | int64 | The duration of the wrapup in seconds | |
| wrapup_end_time | datetime | The end datetime of the wrapup | |
| start_acw_time | datetime | The start datetime of the after-call work | |
| end_acw_time | datetime | The end datetime of the after-call work | |
| alerting_timeout_ms | int64 | The timeout for alerting in milliseconds |