public.convvoicesummarydata
Description
AI-generated summaries for voice conversations from Genesys Cloud
Speech and Text Analytics
Columns
| 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 |
Constraints
| convvoicesummarydata_pkey |
PRIMARY KEY |
PRIMARY KEY (keyid) |
Indexes
| 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 ...
README
Logo Genesys Adapter Data Dictionary Tables Name Columns Comment Type public.tabledefinitions 5 Subscription Detailed Data BASE TABLE public.activeqmembersdata 9 Historical Active Membership of Queues BASE TABLE public.activitycodedetails 11 Activity ...
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 ...