Table Type: Historical Data
This table contains the conversation sessions. Each session is a single interaction between a participant and the system using a single media type.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| session_id | string | Primary Key | The unique identifier of the session |
| 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 | |
| conversation_id | string | Primary Key | The ID of the conversation to which this session belongs |
| participant_id | string | Primary Key | The ID of the participant to which this session belongs |
| delivery_status | string | The delivery status of the session. One of: DeliveryFailed, DeliverySuccess, Failed, Published, Queued, Read, Received or Sent | |
| direction | string | The direction of the session. One of: Inbound, Outbound | |
| media_type | string | The media type of the session. One of: Callback, Chat, Cobrowse, Email, Message, Screenshare, Unknown, Video or Voice | |
| routing_rule_type | string | The routing rule type of the session. One of: Bullseye, Conditional, Predictive, Preferred | |
| used_routing | string | The routing rule used for the session. One of: Bullseye, Conditional, Direct, Last, Manual, Predictive, Preferred, Standard or Vip | |
| acw_skipped | boolean | Whether the after-call work was skipped | |
| address_from | string | The address that initiated an action | |
| address_other | string | The email address for the participant on the other side of the email conversation. | |
| address_self | string | The email address for the participant on this side of the email conversation. | |
| address_to | string | The address that received an action | |
| agent_assistant_id | string | The ID of the active virtual agent assistant associated with the session | |
| agent_bullseye_ring | int32 | The bullseye ring of the targetted agent | |
| agent_owned | boolean | Flag indicating an agent-owned callback. | |
| ani | string | The Automatic Number Identification (ANI) of the session. Also known as the caller's telephone number or Caller Line ID (CLI) | |
| assigner_id | string | The ID of the user who manually assigned the conversation | |
| authenticated | boolean | Flag that indicates that the identity of the customer has been asserted as verified by the provider. | |
| barged_participant_id | string | For barge-in sessions, the participant ID of the participant who was barged into. If present, this would correspond to one of the other participantIds present in the conversation). | |
| callback_scheduled_time | datetime | For callback sessions, the scheduled time for the callback | |
| callback_user_name | string | For callback sessions, the name of the user who requested the callback | |
| cleared | boolean | Flag that indicates that the conversation has been cleared by the customer. | |
| coached_participant_id | string | ||
| cobrowse_role | string | ||
| cobrowse_room_id | string | ||
| delivery_status_change_date | datetime | Date and time of the most recent delivery status change. | |
| detected_speech_end | datetime | ||
| detected_speech_start | datetime | ||
| disposition_analyzer | string | ||
| dispostion_name | string | ||
| dnis | string | The Dialed Number Identification Service (DNIS) of the session. Also known as the called party's telephone number - ie. the number called. | |
| edge_id | string | ||
| extended_delivery_status | string | ||
| flow_in_type | string | ||
| flow_out_type | string | ||
| journey_action_id | string | ||
| journey_action_map_id | string | ||
| journey_action_map_version | int32 | ||
| journey_customer_id | string | ||
| journey_customer_id_type | string | ||
| journey_customer_session_id | string | ||
| journey_customer_session_id_type | string | ||
| media_bridge_id | string | ||
| media_count | int32 | ||
| message_type | string | For messages, the message type, for example, sms, facebook, twitter, line | |
| monitored_participant_id | string | ||
| outbound_campaign_id | string | The ID of the outbound campaign associated with the session | |
| outbound_contact_id | string | The ID of the outbound contact associated with the session | |
| outbound_contact_list_id | string | The ID of the outbound contact list associated with the session | |
| peer_id | string | ||
| protocol_call_id | string | ||
| provider | string | The source provider for the communicaton | |
| recording | boolean | Whether the session was recorded | |
| remote | string | Name, phone number, or email address of the remote party. | |
| remote_name_displayable | string | Unique identifier for the remote party. | |
| room_id | string | ||
| routing_ring | int32 | ||
| routing_rule | string | ||
| screen_share_address_self | string | ||
| screen_share_room_id | string | ||
| script_id | string | ||
| selected_agent_id | string | ||
| selected_agent_rank | int32 | ||
| session_dnis | string | Dialed number for the current session; this can be different from dnis, e.g. if the call was transferred. | |
| sharing_screen | boolean | ||
| skip_enabled | boolean | (Dialer) Whether the agent can skip the dialer contact. | |
| timeout_seconds | int32 | The number of seconds before Genesys Cloud begins the call for a call back (0 disables automatic calling). | |
| video_address_self | string | ||
| video_room_id | string | ||
| flow_entry_type | string | One of: agent, direct, dnis, flow or outbound | |
| flow_flow_type | string | One of: BOT, COMMONMODULE, DIGITALBOT, INBOUNDCALL, INBOUNDCHAT, INBOUNDEMAIL, INBOUNDSHORTMESSAGE, INQUEUECALL, INQUEUEEMAIL, INQUEUESHORTMESSAGE, OUTBOUNDCALL, SECURECALL, SPEECH, SURVEYINVITE, VOICE, VOICEMAIL, VOICESURVEY, WORKFLOW or WORKITEM | |
| flow_ending_language | string | The language used at the end of the flow | |
| flow_entry_reason | string | ||
| flow_exit_reason | string | ||
| flow_flow_id | string | ||
| flow_flow_name | string | ||
| flow_flow_version | string | ||
| flow_issued_callback | boolean | ||
| flow_recognition_failure_reason | string | ||
| flow_starting_language | string | ||
| flow_transfer_target_address | string | ||
| flow_transfer_target_name | string | ||
| flow_transfer_type | string |
Related Tables
- analytics_conversation
- analytics_participant
- campaign
- external_contact
- contact_list
- analytics_session_metric
- analytics_conversation_segment
- recording_info
- queue_conversation
- voice_transcript
- article_feedback
- analytics_session_flow_outcome
