Skip to content

conversation_uni_yyyy_mm

Description: Monthly denormalized fact table of Genesys Cloud interactions containing conversation, participant, session and segment data.

Column Type Description
id text Unique identifier of the record in Genesys Cloud.
conversation_id text Unique identifier of the conversation/interaction in Genesys Cloud.
session_id text Identifier of the interaction session.
conversation_start timestamp with time zone Conversation start date/time.
conversation_end timestamp with time zone Conversation end date/time.
segment_start timestamp with time zone Segment start date/time.
external_tag text External tag associated with the conversation.
segment_end timestamp with time zone Segment end date/time.
participant_id text Identifier of the conversation participant.
participant_name text Descriptive name of the related entity.
user_id text Identifier of the user/agent in Genesys Cloud.
purpose text Purpose of the participant in the interaction.
direction text Interaction direction (inbound, outbound, etc.).
media_type text Interaction media type.
disconnect_type text Type of disconnection that ended the interaction.
queue_id text Identifier of the ACD queue.
queue_name text Queue name.
wrap_up_code text Wrap-up code applied by the agent at the end of the interaction.
wrap_up_note text Additional notes associated with the wrap-up code.
flow_id text Identifier of the Architect flow.
flow_name text Name of the Architect flow associated with the interaction.
outbound_campaign_id text Identifier of a related entity in Genesys Cloud.
outbound_contact_id text Identifier of a related entity in Genesys Cloud.
outbound_contact_list_id text Identifier of a related entity in Genesys Cloud.
alert double precision Field alert extracted from Genesys Cloud.
callback double precision Field callback extracted from Genesys Cloud.
coaching double precision Field coaching extracted from Genesys Cloud.
contacting double precision Field contacting extracted from Genesys Cloud.
converting double precision Field converting extracted from Genesys Cloud.
delay double precision Field delay extracted from Genesys Cloud.
dialing double precision Field dialing extracted from Genesys Cloud.
hold double precision Field hold extracted from Genesys Cloud.
interact double precision Field interact extracted from Genesys Cloud.
ivr double precision Field ivr extracted from Genesys Cloud.
monitoring double precision Field monitoring extracted from Genesys Cloud.
scheduled double precision Field scheduled extracted from Genesys Cloud.
sharing double precision Field sharing extracted from Genesys Cloud.
system double precision Field system extracted from Genesys Cloud.
transmitting double precision Field transmitting extracted from Genesys Cloud.
unknown double precision Field unknown extracted from Genesys Cloud.
uploading double precision Field uploading extracted from Genesys Cloud.
voicemail double precision Field voicemail extracted from Genesys Cloud.
wrapup double precision Field wrapup extracted from Genesys Cloud.
total double precision Field total extracted from Genesys Cloud.
ani text Automatic Number Identification (ANI) representing the caller phone number.
dnis text Dialed Number Identification Service (DNIS) representing the number dialed by the caller.
sip_response_codes text Field sip_response_codes extracted from Genesys Cloud.
transfer_target_address text Field transfer_target_address extracted from Genesys Cloud.
exported boolean Indicates whether the record was marked as exported by the pipeline.
_sdc_received_at timestamp with time zone Timestamp when the record was received by the Singer/SDC pipeline.
_sdc_sequence bigint Technical ingestion sequence from the Singer/SDC pipeline.
_sdc_table_version bigint Technical table version in the Singer/SDC pipeline.
_sdc_batched_at timestamp with time zone Timestamp when the record was batch-written by the Singer/SDC pipeline.

Last updated: