public.convvoicesummarydata

public.convvoicesummarydata

Description

AI-generated summaries for voice conversations from Genesys Cloud Speech and Text Analytics

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(150) false Primary key composed of conversation ID, summary type, and summary ID
conversationid varchar(50) false Unique identifier for the conversation
communicationid varchar(50) true Communication (session) ID the summary belongs to; set from the conversations summaries endpoint
summarytype varchar(50) true Type of summary: Conversation, Communication, or Agent
summaryid varchar(50) true Unique identifier for the summary from Genesys Cloud
summarytext text true Plain text content of the AI-generated summary
summarylanguage varchar(20) true Language code of the summary (e.g., en-US, en-AU)
summarymediatype varchar(25) true Media type of the conversation (e.g., voice, chat, email)
summaryresolution varchar(50) true Resolution insight value (e.g., resolved, unresolved)
summaryreason text true Reason insight description extracted from the insights array
summaryactionitem text true Action item insight description extracted from the insights array
summaryinsights text true Additional insights that do not fit standard categories (JSON format)
summaryrawjson text true Original JSON response from Genesys Cloud API for the summary
summarystatus varchar(50) true Status of the summary generation
summarygenerated boolean true Flag indicating whether the summary was generated
summarycreated timestamp without time zone true Timestamp when the summary was created
updated timestamp without time zone CURRENT_TIMESTAMP true Timestamp when the record was last updated
summarysource varchar(30) true conversations when the conversations summaries endpoint contributed to the row, otherwise speechandtextanalytics
sourceid varchar(50) true Source ID from the summary entity
predictedwrapupcode varchar(50) true AI-predicted wrap-up code
editedsummary text true Agent-edited version of the summary; NULL when the agent did not edit it, empty when the agent deleted the text
summarymodified timestamp without time zone true Timestamp when the agent edited the summary
participantid varchar(50) true Participant ID associated with the summary
userid varchar(50) true User ID (agent) associated with the summary
externalcontactid varchar(50) true External contact ID
queueid varchar(50) true Queue ID associated with the summary
divisionid varchar(50) true Division ID
programid varchar(50) true Program ID
triggertype varchar(30) true How the summary was triggered: OnDemand (requested by the agent) or AfterDisconnect; set from the conversations summaries endpoint

Constraints

Name Type Definition
convvoicesummarydata_pkey PRIMARY KEY PRIMARY KEY (keyid)

Indexes

Name Definition
convvoicesummarydata_pkey CREATE UNIQUE INDEX convvoicesummarydata_pkey ON public.convvoicesummarydata USING btree (keyid)
convvoicesummarydata_conversationid_idx CREATE INDEX convvoicesummarydata_conversationid_idx ON public.convvoicesummarydata USING btree (conversationid)
convvoicesummarydata_updated_idx CREATE INDEX convvoicesummarydata_updated_idx ON public.convvoicesummarydata USING btree (updated)
convvoicesummarydata_summarytype_idx CREATE INDEX convvoicesummarydata_summarytype_idx ON public.convvoicesummarydata USING btree (summarytype)
convvoicesummarydata_summaryid_idx CREATE INDEX convvoicesummarydata_summaryid_idx ON public.convvoicesummarydata USING btree (summaryid)