| 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 |