public.convsummarydata

public.convsummarydata

Description

Conversation Summary Data

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(100) false
conversationid varchar(50) true Conversation GUID
conversationstartdate timestamp without time zone false Conversation Start Date (UTC)
conversationenddate timestamp without time zone true Conversation End Date (UTC)
conversationstartdateltc timestamp without time zone true Conversation Start Date (LTC)
conversationenddateltc timestamp without time zone true Conversation End Date (LTC)
originaldirection varchar(50) true Conversation Original Direction
firstmediatype varchar(50) true Conversation First Media Type
lastmediatype varchar(50) true Conversation Final Media Type
peer varchar(50) true Conversation Peer GUID (for Voice Analysis)
ani varchar(400) true Conversation ANI
dnis varchar(400) true Conversation DNIS
firstagentid varchar(50) true Conversation First Agent GUID
lastagentid varchar(50) true Conversation Final Agent GUID
firstqueueid varchar(50) true Conversation First Queue GUID
lastqueueid varchar(50) true Conversation Final Queue GUID
ttalkcomplete numeric(20,2) true Conversation Talk Time (Seconds)
tqueuetime numeric(20,2) true Conversation Queue Time (Seconds)
tacw numeric(20,2) true Conversation ACW
tansweredcount integer true Conversation Total Answered Count
tanswered numeric(20,2) true Conversation Total Answer Time (Seconds)
tabandonedcount integer true Conversation Total Abandon Count
tresponsecount integer true Conversation Total Response Count
tresponse numeric(20,2) true Conversation Total Response Time (Seconds)
thandlecount integer true Conversation Total Hold Time (Seconds)
thandle numeric(20,2) true
firstwrapupcode varchar(255) true Conversation First Wrap Up GUID
lastwrapupcode varchar(255) true Conversation Final Wrap Up GUID
theldcompletecount integer true Conversation Total
theldcomplete numeric(20,2) true Conversation Total
nconsulttransferred integer true Conversation Consult Transfer Count
nblindtransferred integer true Conversation Blind Transfer Count
lastdisconnect varchar(50) true Conversation Last Disconnect Type
lastpurpose varchar(50) true Conversation Last Purpose
lastsegmenttime numeric(20,2) true Conversation Last Segment Total Time (Seconds)
divisionid varchar(50) true Conversation Division GUID
divisionid2 varchar(50) true Conversation Division GUID 2
divisionid3 varchar(50) true Conversation Division GUID 3
updated timestamp without time zone true Date Row Updated (UTC)

Constraints

Name Type Definition
convsummarynwdata_pkey PRIMARY KEY PRIMARY KEY (keyid, conversationstartdate)

Indexes

Name Definition
convsummarynwdata_pkey CREATE UNIQUE INDEX convsummarynwdata_pkey ON ONLY public.convsummarydata USING btree (keyid, conversationstartdate)
ConvSummaryDiscType CREATE INDEX “ConvSummaryDiscType” ON ONLY public.convsummarydata USING btree (lastdisconnect)
ConvSummaryDivision CREATE INDEX “ConvSummaryDivision” ON ONLY public.convsummarydata USING btree (divisionid)
ConvSummaryNwConvId CREATE INDEX “ConvSummaryNwConvId” ON ONLY public.convsummarydata USING btree (conversationid)
ConvSummaryNwEndDate CREATE INDEX “ConvSummaryNwEndDate” ON ONLY public.convsummarydata USING btree (conversationenddate)
ConvSummaryNwEndDateLTC CREATE INDEX “ConvSummaryNwEndDateLTC” ON ONLY public.convsummarydata USING btree (conversationenddateltc)
ConvSummaryNwStartDate CREATE INDEX “ConvSummaryNwStartDate” ON ONLY public.convsummarydata USING btree (conversationstartdate)
ConvSummaryNwStartDateLTC CREATE INDEX “ConvSummaryNwStartDateLTC” ON ONLY public.convsummarydata USING btree (conversationstartdateltc)
ConvSummaryUserId CREATE INDEX “ConvSummaryUserId” ON ONLY public.convsummarydata USING btree (lastagentid)
ConvSummaryWrap CREATE INDEX “ConvSummaryWrap” ON ONLY public.convsummarydata USING btree (lastwrapupcode)
convsummarydata_firstagentid_idx CREATE INDEX convsummarydata_firstagentid_idx ON ONLY public.convsummarydata USING btree (firstagentid)
convsummarydata_firstqueueid_idx CREATE INDEX convsummarydata_firstqueueid_idx ON ONLY public.convsummarydata USING btree (firstqueueid)
convsummarydata_lastqueueid_idx CREATE INDEX convsummarydata_lastqueueid_idx ON ONLY public.convsummarydata USING btree (lastqueueid)
convsummarydata_firstmedia_enddateltc_idx CREATE INDEX convsummarydata_firstmedia_enddateltc_idx ON ONLY public.convsummarydata USING btree (firstmediatype, conversationenddateltc)

    • Related Articles

    • public.vwevaluationquestiondata

      Description View for evaluation question data (converted from materialized view) Table Definition CREATE VIEW vwevaluationquestiondata AS ( SELECT DISTINCT eq.keyid, eq.evaluationid, eq.questionid, eq.answerid, eq.score, ed.questionanswervalue, ...

    • public.vwevalquestiondata

      Description See EvalQuestionData: View for evaluation question data with additional details Table Definition CREATE VIEW vwevalquestiondata AS ( SELECT DISTINCT eq.evaluationid, eq.questionid, eq.answerid, eq.score, ed.questionanswervalue, ...

    • public.vwflowoutcomedata

      Description Flow Outcome Data with conversation summary enrichment and outcome name Table Definition CREATE VIEW vwflowoutcomedata AS ( SELECT fod.keyid, fod.conversationid, fod.conversationstartdate, fod.conversationstartdateltc, ...

    • public.vwconvsummarydata

      Description See ConvSummaryData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwconvsummarydata AS ( SELECT cs.conversationid, cs.conversationstartdate, cs.conversationstartdateltc, cs.conversationenddate AS ...

    • public.vwconvvoicesentimentdetaildata

      Description View for conversation voice sentiment detail data combining sentiment analysis with conversation summary data Table Definition CREATE VIEW vwconvvoicesentimentdetaildata AS ( SELECT ct.keyid, ct.conversationid, ct.starttime, ...