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 ID associated with the summary
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 Source of summary data: conversations (NRT) or speechandtextanalytics (STT/historical)
sourceid varchar(50) true Source ID from the summary entity
predictedwrapupcode varchar(50) true AI-predicted wrap-up code
editedsummary text true User-edited version of the summary
summarymodified timestamp without time zone true Timestamp when summary was last modified
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

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)

    • Related Articles

    • public.vwassistantenabledinteractions

      Description Detailed interaction data for queues with AI assistant enabled, including AI-generated summaries Table Definition CREATE VIEW vwassistantenabledinteractions AS ( SELECT d.conversationid, d.participantid, d.participantname, ...

    • public.vwassistantqueuesummary

      Description Summary statistics for queues with AI assistant enabled, including interaction counts and summary generation metrics Table Definition CREATE VIEW vwassistantqueuesummary AS ( SELECT q.id AS queueid, q.name AS queuename, q.description AS ...

    • public.vwcopilotsummaryinsights

      Description Comprehensive view combining conversation summaries, AI-generated voice summaries, and copilot usage analytics for insights into summary effectiveness and usage patterns Table Definition CREATE VIEW vwcopilotsummaryinsights AS ( SELECT ...

    • public.evalquestiondata

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false evaluationid varchar(50) false evaluationformid varchar(50) false questiongroupid varchar(50) true questionid varchar(50) true answerid varchar(50) true ...

    • public.participantattributesdynamic

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false conversationid varchar(50) false conversationstartdate timestamp without time zone false conversationstartdateltc timestamp without time zone true ...