public.z_vwcallabandonedsummary

public.z_vwcallabandonedsummary

Description

See CallAbandonedSummary: Summary of abandoned calls with relevant details

Table Definition 
CREATE VIEW z_vwcallabandonedsummary AS (
 SELECT det.conversationid,
    det.conversationstartdate,
    (det.conversationstartdate AT TIME ZONE 'Australia/Sydney'::text) AS conversationstartdateltc,
    det.conversationenddate,
    (det.conversationenddate AT TIME ZONE 'Australia/Sydney'::text) AS conversationenddateltc,
    det.segmentstartdate,
    (det.segmentstartdate AT TIME ZONE 'Australia/Sydney'::text) AS segmentstartdateltc,
    det.segmentenddate,
    (det.segmentenddate AT TIME ZONE 'Australia/Sydney'::text) AS segmentenddateltc,
    det.convtosegmentendtime AS totalcalltime,
    det.segmenttime AS queuetime,
    det.ani,
    det.dnis,
    det.queueid,
    que.name AS queuename,
    det.purpose,
    det.segmenttype,
    det.disconnectiontype
   FROM (detailedinteractiondata det
     LEFT JOIN queuedetails que ON (((det.queueid)::text = (que.id)::text)))
  WHERE (((det.segmenttype)::text = ANY ((ARRAY['delay'::character varying, 'Interact'::character varying, 'alert'::character varying, 'ivr'::character varying])::text[])) AND ((det.purpose)::text = ANY ((ARRAY['acd'::character varying, 'ivr'::character varying])::text[])) AND ((det.disconnectiontype)::text = 'peer'::text) AND (det.conversationenddate = det.segmentenddate))
)

Columns

Name Type Default Nullable Children Parents Comment
conversationid varchar(50) true Conversation GUID
conversationstartdate timestamp without time zone true Conversation Start Date (UTC)
conversationstartdateltc timestamp with time zone true Conversation Start Date (LTC)
conversationenddate timestamp without time zone true Conversation End Date (UTC)
conversationenddateltc timestamp with time zone true Conversation End Date (LTC)
segmentstartdate timestamp without time zone true Segment Start Date (UTC)
segmentstartdateltc timestamp with time zone true Segment Start Date (LTC)
segmentenddate timestamp without time zone true Segment End Date (UTC)
segmentenddateltc timestamp with time zone true Segment End Date (LTC)
totalcalltime numeric(20,2) true Total Call Time (Seconds)
queuetime numeric(20,2) true Queue Time (Seconds)
ani varchar(400) true ANI (Automatic Number Identification)
dnis varchar(400) true DNIS (Dialed Number Identification Service)
queueid varchar(50) true Queue ID
queuename varchar(255) true Queue Name
purpose varchar(50) true Purpose
segmenttype varchar(50) true Segment Type
disconnectiontype varchar(50) true Disconnection Type

Referenced Tables

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

    • Related Articles

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

      Description See WFMScheduleData: Data combining schedule and time off information Table Definition CREATE VIEW z_wfmscheduledata AS ( SELECT sc.userid, sc.shiftstartdate, sc.shiftlengthtime, sc.activitystartdate, sc.activitystartdateltc, ...

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

    • public.convvoicetopicdetaildata

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) true starttime timestamp without time zone false starttimeltc timestamp without time zone true participant varchar(50) true ...