public.detailedinteractiondata

public.detailedinteractiondata

Description

Conversation Detailed Data

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(255) false
conversationid varchar(50) true Conversation GUID
conversationstartdate timestamp without time zone false Conversation Start Date (UTC)
conversationstartdateltc timestamp without time zone true Conversation Start Date (LTC)
conversationenddate timestamp without time zone true Conversation End Date (UTC)
conversationenddateltc timestamp without time zone true Conversation End Date (LTC)
conversationminmos numeric(20,2) true Conversation Min MOS
conversationminrfactor numeric(20,2) true Conversation Min RFactor
externaltag varchar(50) true Conversation Segment Division GUID
originaldirection varchar(50) true Conversation Original Direction
participantid varchar(50) true Conversation Participant GUID
participantname varchar(255) true Conversation Participant Name
purpose varchar(50) true Conversation Segment Purpose
mediatype varchar(50) true Conversation Segment Media Type
ani varchar(400) true Conversation Segment ANI
dnis varchar(400) true Conversation Segment DNIS
sessiondnis varchar(400) true Conversation Segment Session DNIS
edgeid varchar(50) true Conversation Segment Edge GUID
gencode varchar(20) true Conversation Segment (Admin Code - Internal Use Only)
remotedisplayable varchar(255) true Conversation Segment Remote Displayable
segmentstartdate timestamp without time zone true Conversation Segment Start Date (UTC)
segmentstartdateltc timestamp without time zone true Conversation Segment Start Date (LTC)
segmentenddate timestamp without time zone true
segmentenddateltc timestamp without time zone true
segmenttime numeric(20,2) true Conversation Segment Total Time Sec(s)
convtosegmentstarttime numeric(20,2) true Conversation Segment Time From Start of Conversation to Start of Segment
convtosegmentendtime numeric(20,2) true Conversation Segment Time From Start of Conversation to End of Segment
segmenttype varchar(50) true Conversation Segment Type
conference bit(1) true Conversation Segment Conference (True/False)
disconnectiontype varchar(50) true Conversation Segment Disconnection Type
wrapupcode varchar(255) true Conversation Segment Wrapup Code GUID
wrapupnote text true
recordingexists bit(1) true Conversation Segment Recording Exists (True/False)
sessionprovider varchar(50) true Conversation Segment Session Source
flowid varchar(50) true Conversation Segment Flow GUID
flowname varchar(255) true Conversation Segment Flow Name
flowversion numeric(20,2) true Conversation Segment Flow Version
flowtype varchar(50) true Conversation Segment Flow Type
exitreason varchar(100) true Conversation Segment Exit Reason
entryreason varchar(500) true Conversation Segment Entry Reason
entrytype varchar(50) true Conversation Segment Entry Type
transfertype varchar(50) true Conversation Segment Division GUID
transfertargetname varchar(255) true Conversation Segment Transfer Target Name
queueid varchar(50) true Conversation Segment Queue GUID
userid varchar(50) true Conversation Segment Queue GUID
issuedcallback bit(1) true Conversation Segment Callback Requested ?
nflow integer true Conversation Count of Flows
tivr numeric(20,2) true Conversation Total IVR Time (Seconds)
tflow numeric(20,2) true Conversation Total Flow Time (Seconds)
tflowdisconnect numeric(20,2) true Conversation Total Flow Time before Disconnection
tflowexit numeric(20,2) true Conversation Total Flow Time before exit
tflowout numeric(20,2) true Conversation Total Flow Out Time (Seconds)
tacd numeric(20,2) true Conversation Total Queing Time (Seconds)
tacw numeric(20,2) true Conversation Total ACW Time (Seconds)
talert numeric(20,2) true Conversation Total Agent Alerting Time (Seconds)
tanswered numeric(20,2) true Conversation Total Answer Time (Seconds)
tconnected numeric(20,2) true Total Connected
ttalk numeric(20,2) true Conversation Total Talk Time (Seconds)
ttalkcomplete numeric(20,2) true Conversation Total Talk Time (Seconds)
thandle numeric(20,2) true Conversation Total Handle Time (Seconds)
tcontacting numeric(20,2) true Conversation Total Contacting Time (Seconds)
tdialing numeric(20,2) true Conversation Total Dialing Time (Seconds)
tnotresponding numeric(20,2) true Conversation Total Not Responding Time (Seconds)
tabandon numeric(20,2) true Conversation Total Abandon Time (Seconds)
theld numeric(20,2) true Conversation Total Held Time (Seconds)
theldcomplete numeric(20,2) true Conversation Total Held Time (Seconds)
tvoicemail numeric(20,2) true Conversation Total Voice Mail Time (Seconds)
tmonitoring numeric(20,2) true Conversation Total Monitoring Time (Seconds)
tmonitoringcomplete numeric(20,2) true
tshortabandon numeric(20,2) true Conversation Total Short Abandoned Time (Seconds)
tagentresponsetime numeric(20,2) true Conversation Total Agent Response Time (Seconds)
tactivecallback numeric(20,2) true
tactivecallbackcomplete numeric(20,2) true
noffered integer true Conversation Total Offered Count
nconnected integer true Conversation Total Connected Count
nconsult integer true Conversation Total Consults Count
nconsulttransferred integer true Conversation Total Consult Transferred Count
ntransferred integer true Conversation Total Transferred Count
nblindtransferred integer true Conversation Total Blind Transferred Count
nerror integer true Conversation Total Error Count
noutbound integer true Conversation Total OutBound Count
nstatetransitionerror integer true Conversation Total Trans Error Count
noversla integer true Conversation Total Count Answered Over SLA Time (Seconds)
noutboundattempted integer true Conversation Segment Division GUI
noutboundconnected integer true Conversation Segment Division GUI
sessiondirection varchar(50) true Conversation Segment Session Direction
segdestinationconversationid varchar(50) true Conversation Segment Destination Conversation GUID
tfirstdial numeric(20,2) true
tfirstconnect numeric(20,2) true
tuserresponsetime numeric(20,2) true
nflowoutcome integer true Conversation Total Flow Outcome Count
tflowoutcome numeric(20,2) true Conversation Total Flow Outcome Time (Seconds)
nflowoutcomefailed integer true Conversation Total Flow Outcome Failed Count
nbotinteractions integer true Conversation Total Bot Interaction Count
tpark numeric(20,2) true
tparkcomplete numeric(20,2) true
omessagecount integer true Conversation Total Message Count
omessagesegmentcount integer true Conversation Total Message Segment Count
omessageturn integer true Conversation Total Message Turn Count
peer varchar(100) true Conversation Segment Peer GUID (For Voice Transcription)
divisionid varchar(100) false Conversation Segment Division GUID
divisionid2 varchar(100) true Conversation Total Outbound Attempted Count
divisionid3 varchar(100) true Date Row Updated (UTC)
updated timestamp without time zone true Conversation Segment
ncobrowsesessions integer true
noutboundabandoned integer true
sessionid varchar(50) true Conversation Session GUID
protocolcallid varchar(100) true Conversation Session Protocol Call ID
remotenamedisplayable varchar(255) true Conversation Session Remote Name Displayable
callbackusername varchar(255) true Conversation Session Callback User Name
callbacknumbers text true Conversation Session Callback Numbers (JSON Array)
scriptid varchar(50) true Conversation Session Script GUID
skipenabled bit(1) true Conversation Session Skip Enabled (True/False)
timeoutseconds integer true Conversation Session Timeout Seconds
flowouttype varchar(50) true Conversation Session Flow Out Type
roomid varchar(50) true Conversation Session Room GUID
callbackscheduledtime timestamp without time zone true Conversation Session Callback Scheduled Time (UTC)
transfertargetaddress varchar(255) true Conversation Flow Transfer Target Address
startinglanguage varchar(50) true Conversation Flow Starting Language
endinglanguage varchar(50) true Conversation Flow Ending Language
requestedroutingskillids text true Conversation Segment Requested Routing Skill IDs (JSON Array)
sipresponsecodes text true Conversation Segment SIP Response Codes (JSON Array)
q850responsecodes text true Conversation Segment Q850 Response Codes (JSON Array)
errorcode varchar(100) true Conversation Segment Error Code
requestedlanguageid varchar(50) true Conversation Segment Requested Language GUID
externalcontactid varchar(50) true Conversation Participant External Contact GUID
externalorganizationid varchar(50) true Conversation Participant External Organization GUID
codecs text true Conversation Session Media Codecs (JSON Array)
tcoaching numeric(20,2) true
tcoachingcomplete numeric(20,2) true
minmos numeric(10,4) true Conversation Session Media Min MOS Score
minrfactor numeric(10,4) true Conversation Session Media Min R-Factor
maxlatencyms integer true Conversation Session Media Max Latency (Milliseconds)
receivedpackets integer true Conversation Session Media Received Packets Count
discardedpackets integer true Conversation Session Media Discarded Packets Count
overrunpackets integer true Conversation Session Media Overrun Packets Count
invalidpackets integer true Conversation Session Media Invalid Packets Count
duplicatepackets integer true Conversation Session Media Duplicate Packets Count

Constraints

Name Type Definition
detailedinteractiondata_pkey PRIMARY KEY PRIMARY KEY (keyid, divisionid, conversationstartdate)

Indexes

Name Definition
detailedinteractiondata_pkey CREATE UNIQUE INDEX detailedinteractiondata_pkey ON ONLY public.detailedinteractiondata USING btree (keyid, divisionid, conversationstartdate)
DetailedintegereractionConvEndLTC CREATE INDEX “DetailedintegereractionConvEndLTC” ON ONLY public.detailedinteractiondata USING btree (conversationenddateltc)
Detailedintegereractionconvend CREATE INDEX “Detailedintegereractionconvend” ON ONLY public.detailedinteractiondata USING btree (conversationenddate)
detailedintereractionconv CREATE INDEX detailedintereractionconv ON ONLY public.detailedinteractiondata USING btree (conversationid)
detailedintereractionconvstartltcuser CREATE INDEX detailedintereractionconvstartltcuser ON ONLY public.detailedinteractiondata USING btree (conversationstartdateltc, userid)
detailedintereractionconvstartuser CREATE INDEX detailedintereractionconvstartuser ON ONLY public.detailedinteractiondata USING btree (conversationstartdate, userid)
detailedintereractionconvuser CREATE INDEX detailedintereractionconvuser ON ONLY public.detailedinteractiondata USING btree (userid)
detailedintereractionoriginaldir CREATE INDEX detailedintereractionoriginaldir ON ONLY public.detailedinteractiondata USING btree (originaldirection)
detailedintereractionpurposetype CREATE INDEX detailedintereractionpurposetype ON ONLY public.detailedinteractiondata USING btree (purpose, segmenttype)
detailedintereractionsegend CREATE INDEX detailedintereractionsegend ON ONLY public.detailedinteractiondata USING btree (segmentenddate)
detailedintereractionsegendltc CREATE INDEX detailedintereractionsegendltc ON ONLY public.detailedinteractiondata USING btree (segmentenddateltc)
detailedintereractionsegstart CREATE INDEX detailedintereractionsegstart ON ONLY public.detailedinteractiondata USING btree (segmentstartdate)
detailedintereractionsegstartltc CREATE INDEX detailedintereractionsegstartltc ON ONLY public.detailedinteractiondata USING btree (segmentstartdateltc)
detailedintereractionuserdirection CREATE INDEX detailedintereractionuserdirection ON ONLY public.detailedinteractiondata USING btree (userid, sessiondirection)

    • Related Articles

    • public.vwcalldetail

      Description See DetailedInteractionData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwcalldetail AS ( SELECT di.conversationid, di.originaldirection, di.mediatype, di.ani, di.dnis, di.purpose, di.sessiondirection, ...

    • public.vwcallabandonedsummary

      Description Shows the details for abandoned calls in the detailed interaction data – Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwcallabandonedsummary AS ( SELECT det.conversationid, det.conversationstartdate, ...

    • public.vwcallnotrespondingdetails

      Description Shows the details of agents missing calls (Not Responding) from the DetailedInteractionData table - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwcallnotrespondingdetails AS ( SELECT det.conversationid, ...

    • public.vwcallsummary

      Description See Callummary : View for call summary data with aggregated metrics Table Definition CREATE VIEW vwcallsummary AS ( SELECT di.conversationid AS "Fact.ConversationId", qd.name AS "Fact.QueueName", di.conversationstartdate AS ...

    • public.vwdetailedinteractiondata

      Description See DetailedInteractionData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwdetailedinteractiondata AS ( SELECT di.keyid, di.conversationid, di.conversationstartdate, di.conversationstartdateltc, ...