public.vwcallsummary

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 "Date.ConversationStartDate",
    di.conversationenddate AS "Date.ConversationEndDate",
    di.ani AS "Fact.ANI",
    di.dnis AS "Fact.DNIS",
    di.originaldirection AS "Fact.OriginalDirection",
    sum(di.ttalkcomplete) AS "Raw.Talk",
    sum(di.tacw) AS "Raw.ACW",
    sum(di.theldcomplete) AS "Raw.Hold",
    sum(di.tvoicemail) AS "Raw.Voicemail",
    sum(di.ntransferred) AS "Count.Transferred",
    sum(di.tabandon) AS "Raw.Abandon",
    (sum(di.ttalkcomplete) / 86400.00) AS "Raw.TalkDay",
    (sum(di.tacw) / 86400.00) AS "Raw.ACWDay",
    (sum(di.theldcomplete) / 86400.00) AS "Raw.HoldDay",
    (sum(di.tvoicemail) / 86400.00) AS "Raw.VoicemailDay",
    ((sum(di.ntransferred))::numeric / 86400.00) AS "Count.TransferredDay",
    (sum(di.tabandon) / 86400.00) AS "Raw.AbandonDay"
   FROM (detailedinteractiondata di
     LEFT JOIN queuedetails qd ON (((qd.id)::text = (di.queueid)::text)))
  GROUP BY di.conversationid, qd.name, di.conversationstartdate, di.conversationenddate, di.ani, di.dnis, di.originaldirection
)

Columns

Name Type Default Nullable Children Parents Comment
Fact.ConversationId varchar(50) true Fact: Conversation GUID
Fact.QueueName varchar(255) true Fact: Queue Name
Date.ConversationStartDate timestamp without time zone true Date: Conversation Start Date
Date.ConversationEndDate timestamp without time zone true Date: Conversation End Date
Fact.ANI varchar(400) true Fact: ANI
Fact.DNIS varchar(400) true Fact: DNIS
Fact.OriginalDirection varchar(50) true Fact: Original Direction
Raw.Talk numeric true Raw: Talk Time
Raw.ACW numeric true Raw: After Call Work Time
Raw.Hold numeric true Raw: Hold Time
Raw.Voicemail numeric true Raw: Voicemail Time
Count.Transferred bigint true Count: Transferred
Raw.Abandon numeric true Raw: Abandon Time
Raw.TalkDay numeric true Raw: Talk Time per Day
Raw.ACWDay numeric true Raw: After Call Work Time per Day
Raw.HoldDay numeric true Raw: Hold Time per Day
Raw.VoicemailDay numeric true Raw: Voicemail Time per Day
Count.TransferredDay numeric true Count: Transferred per Day
Raw.AbandonDay numeric true Raw: Abandon Time per Day

Referenced Tables

Name Columns Comment Type
public.detailedinteractiondata 138 Conversation Detailed Data BASE TABLE
public.queuedetails 17 Queue Lookup data BASE TABLE

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