public.mvwinteractionlegdata

Description

Table Definition

CREATE MATERIALIZED VIEW mvwinteractionlegdata AS (
 SELECT vwinteractionlegdata.conversationid,
    vwinteractionlegdata.interactionid,
    vwinteractionlegdata.conversationstartdateltc,
    vwinteractionlegdata.conversationenddateltc,
    vwinteractionlegdata.direction,
    vwinteractionlegdata.mediatype,
    vwinteractionlegdata.conversationleg,
    vwinteractionlegdata.interactionstartdateltc,
    vwinteractionlegdata.queuename,
    vwinteractionlegdata.agentname,
    vwinteractionlegdata.ivr_time,
    vwinteractionlegdata.queue_time,
    vwinteractionlegdata.talk_time,
    vwinteractionlegdata.hold_time,
    vwinteractionlegdata.wrap_up_time,
    vwinteractionlegdata.transferred_flag,
    vwinteractionlegdata.transferred_to_queue,
    vwinteractionlegdata.transferred_from_queue,
    vwinteractionlegdata.ani,
    vwinteractionlegdata.dnis,
    vwinteractionlegdata.alert_time,
    vwinteractionlegdata.handle_time,
    vwinteractionlegdata.wrapupcode,
    vwinteractionlegdata.wrapupname,
    vwinteractionlegdata.disconnectiontype,
    vwinteractionlegdata.ttalkcomplete,
    vwinteractionlegdata.theldcomplete,
    vwinteractionlegdata.tacw,
    vwinteractionlegdata.tagentresponsetime,
    vwinteractionlegdata.nconsulttransferred,
    vwinteractionlegdata.nblindtransferred,
    vwinteractionlegdata.queueid,
    vwinteractionlegdata.userid,
    vwinteractionlegdata.divisionid,
    vwinteractionlegdata.remotedisplayable,
    vwinteractionlegdata.externaltag,
    vwinteractionlegdata.recordingexists,
    vwinteractionlegdata.tanswered,
    vwinteractionlegdata.tuserresponsetime,
    vwinteractionlegdata.nconsult,
    vwinteractionlegdata.ntransferred,
    vwinteractionlegdata.tactivecallback,
    vwinteractionlegdata.tactivecallbackcomplete
   FROM vwinteractionlegdata
)

Columns

Name	Type	Nullable
conversationid	varchar(50)	true
interactionid	text	true
conversationstartdateltc	timestamp without time zone	true
conversationenddateltc	timestamp without time zone	true
direction	text	true
mediatype	text	true
conversationleg	bigint	true
interactionstartdateltc	timestamp without time zone	true
queuename	text	true
agentname	text	true
ivr_time	numeric	true
queue_time	numeric	true
talk_time	numeric	true
hold_time	numeric	true
wrap_up_time	numeric	true
transferred_flag	integer	true
transferred_to_queue	text	true
transferred_from_queue	text	true
ani	text	true
dnis	text	true
alert_time	numeric	true
handle_time	numeric	true
wrapupcode	text	true
wrapupname	text	true
disconnectiontype	text	true
ttalkcomplete	numeric	true
theldcomplete	numeric	true
tacw	numeric	true
tagentresponsetime	numeric	true
nconsulttransferred	bigint	true
nblindtransferred	bigint	true
queueid	text	true
userid	text	true
divisionid	text	true
remotedisplayable	text	true
externaltag	text	true
recordingexists	integer	true
tanswered	numeric	true
tuserresponsetime	numeric	true
nconsult	bigint	true
ntransferred	bigint	true
tactivecallback	numeric	true
tactivecallbackcomplete	numeric	true

Referenced Tables

Name	Columns	Comment	Type
public.vwinteractionlegdata	43	One row per answered interaction leg (queue plus agent handling pair) with rolled-up IVR/queue/talk/hold/wrap times, transfer chain, and per-leg wrap-up/disconnect/Genesys metrics. Abandoned interactions (queued, never handled) produce no row.	VIEW

Indexes

Name	Definition
mvwinteractionlegdata_interactionid	CREATE UNIQUE INDEX mvwinteractionlegdata_interactionid ON public.mvwinteractionlegdata USING btree (interactionid)
mvwinteractionlegdata_conv	CREATE INDEX mvwinteractionlegdata_conv ON public.mvwinteractionlegdata USING btree (conversationid)
mvwinteractionlegdata_convstartltc	CREATE INDEX mvwinteractionlegdata_convstartltc ON public.mvwinteractionlegdata USING btree (conversationstartdateltc)