public.convvoiceoverviewdata
Description
Voice Analysis Overview Data
Columns
keyid |
varchar(50) |
|
false |
|
|
Primary Key |
conversationid |
varchar(50) |
|
true |
|
|
Conversation GUID |
sentimentscore |
numeric(20,2) |
|
true |
|
|
Convesation Sentiment Score |
sentimenttrend |
numeric(20,2) |
|
true |
|
|
Convesation Sentiment Trend |
agentdurationpercentage |
numeric(20,2) |
|
true |
|
|
Conversation Agent Percentage Talk |
customerdurationpercentage |
numeric(20,2) |
|
true |
|
|
Conversation Agent Percentage Talk |
silencedurationpercentage |
numeric(20,2) |
|
true |
|
|
Conversation Silence Percentage |
ivrdurationpercentage |
numeric(20,2) |
|
true |
|
|
Conversation IVR Percentage Talk |
acddurationpercentage |
numeric(20,2) |
|
true |
|
|
Conversation Queue Percentage Time (Seconds) |
otherdurationpercentage |
numeric(20,2) |
|
true |
|
|
Conversation Other Percentage Time (Seconds) |
overtalkdurationpercentage |
numeric(20,2) |
|
true |
|
|
Conversation Agent Overtalk Percentage Time (Seconds) |
overtalkcount |
integer |
|
true |
|
|
Conversation Agent Overtalk Count |
sentimenttrendclass |
varchar(50) |
|
true |
|
|
Conversation Sentiment Trend |
phrasecount |
bigint |
|
true |
|
|
Conversation Total Phrase Count |
peerid |
varchar(50) |
|
true |
|
|
Conversation Peer GUID (for Voice Analysis) |
gettransscript |
varchar(5) |
|
true |
|
|
Admin - has the transcript been analysed? |
transcript_processed |
boolean |
|
true |
|
|
Flag indicating if transcript has been processed for ingestion to Knowledge Quest service |
transcript_processed_date |
timestamp without time zone |
|
true |
|
|
Date when transcript was processed for ingestion to Knowledge Quest service (UTC) |
transcript_processed_notes |
varchar(255) |
|
true |
|
|
Notes about transcript processing for ingestion to Knowledge Quest service |
updated |
timestamp without time zone |
|
true |
|
|
Date Row Updated (UTC) |
Constraints
convvoiceoverviewdata_pkey |
PRIMARY KEY |
PRIMARY KEY (keyid) |
Indexes
convvoiceoverviewdata_pkey |
CREATE UNIQUE INDEX convvoiceoverviewdata_pkey ON public.convvoiceoverviewdata USING btree (keyid) |
Related Articles
public.mvwconvvoiceoverviewdata
Description Columns Name Type Default Nullable Children Parents Comment conversationid varchar(50) false sentimentscore numeric(20,2) true sentimenttrend numeric(20,2) true agentdurationpercentage numeric(20,2) true customerdurationpercentage ...
public.mvwconvvoicesentimentdetaildata
Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) true starttime timestamp without time zone true starttimeltc timestamp without time zone true duration numeric(20,2) true ...
public.vwteammemberdata
Description Team Member Data View Table Definition CREATE VIEW vwteammemberdata AS ( SELECT tm.userid, ud.name AS "Agent Name", td.name AS "Team Name" FROM ((teammemberdata tm LEFT JOIN vwuserdetail ud ON (((tm.userid)::text = (ud.id)::text))) LEFT ...
public.jobminimumdefinition
Description Columns Name Type Default Nullable Children Parents Comment jobid integer nextval(‘jobminimumdefinition_jobid_seq’::regclass) false jobname varchar(255) true maxsyncspan varchar(50) true lookbackspan varchar(50) true Constraints Name Type ...
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 ...