Table Type: Historical Data
This table contains the conversation segment data. Each session belongs to a conversation participant, and there will be multiple segments for that session.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| segment_type | string | Primary Key | One of: Alert, Barging, Callback, Coaching, Contacting, Converting, Delay, Dialing, Hold, Interact, Ivr, Monitoring, Parked, Scheduled, Sharing, System, Transmitting, Unknown, Uploading, Voicemail or Wrapup |
| session_id | string | Primary Key | The session ID that this segment belongs to. |
| segment_start | datetime | Primary Key | The datetime the segment started in UTC. |
| db_last_updated | datetime | When this record was last updated in UTC. | |
| db_when_created | datetime | When this record was created in UTC. | |
| conversation_id | string | Primary Key | The conversation ID that this segment session and participant belongs to. |
| participant_id | string | Primary Key | The participant ID within the conversation that this segment is for. |
| disconnect_type | string | One of: Client, ConferenceTransfer, ConsultTransfer, DndEndpoint, DndTransfer, Endpoint, Error, ForwardTransfer, NoAnswerTransfer, NotAvailableTransfer, Other, Peer, Spam, System, Timeout, Transfer, TransportFailure or Uncallable | |
| audio_muted | boolean | Whether the audio was muted during this segment. | |
| conference | boolean | Whether the segment was part of a conference. | |
| destination_conversation_id | string | The destination conversation ID when the segment type is a transfer. | |
| destination_session_id | string | The destination session ID when the segment type is a transfer. | |
| error_code | string | The error code associated with this segment if any. | |
| group_id | string | The group ID | |
| queue_id | string | The queue ID when the participant purpose is 'Acd' | |
| requested_language_id | string | The requested language ID associated with this segment if any. | |
| segment_end | datetime | The datetime the segment ended in UTC. | |
| source_conversation_id | string | The source conversation ID when the segment type is a transfer. | |
| source_session_id | string | The source session ID when the segment type is a transfer. | |
| subject | string | The subject associated with this segment if any. | |
| video_muted | boolean | Whether the video was muted during this segment. | |
| wrap_up_code | string | The wrap-up code ID associated with this segment if the segment type is 'Wrapup' | |
| wrap_up_note | string | The wrap-up note associated with this segment if the segment type is 'Wrapup' |