public.mvwinteractionlegdata

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 Default Nullable Children Parents Comment
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)

    • Related Articles

    • README

      Logo Genesys Adapter Data Dictionary Tables Name Columns Comment Type public.tabledefinitions 5 Subscription Detailed Data BASE TABLE public.activeqmembersdata 9 Historical Active Membership of Queues BASE TABLE public.activitycodedetails 11 Activity ...

    • public.evalquestiondata

      Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false evaluationid varchar(50) false evaluationformid varchar(50) false questiongroupid varchar(50) true questionid varchar(50) true answerid varchar(50) true score ...

    • public.participantattributesdynamic

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

    • public.hoursblockdata

      Columns Name Type Default Nullable Children Parents Comment keyid varchar(200) false userid varchar(50) true startdate timestamp without time zone true startdateltc timestamp without time zone true enddate timestamp without time zone true enddateltc ...

    • public.userpresencedetaileddata

      Description User Presence Detailed Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false Primary Key userid varchar(50) true Agent GUID starttime timestamp without time zone false Start Time (UTC) starttimeltc ...