Description: Monthly denormalized fact table of Genesys Cloud interactions containing conversation, participant, session and segment data.
Columns
Section titled “Columns”| 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. |

