public.vwuserinteractiondata

public.vwuserinteractiondata

Description

See UserInteractionData - Expands all the GUIDs with their lookups

Table Definition

CREATE VIEW vwuserinteractiondata AS (
 SELECT userinteractiondata.keyid,
    userinteractiondata.startdate AS startdateutc,
    userinteractiondata.startdateltc,
    userinteractiondata.userid,
    userdetail.name AS agentname,
    userdetail.managerid,
    userdetail.managername,
    userdetail.divisionid AS agentdivisionid,
    userdetail.divisionname AS agentdivisionname,
    userinteractiondata.direction,
    userinteractiondata.queueid,
    queuedetail.name AS queuename,
    queuedetail.divisionid,
    queuedetail.divisionname,
    userinteractiondata.mediatype,
    userinteractiondata.wrapupcode,
    wrapupdetails.name AS wrapupdesc,
    userinteractiondata.talertcount,
    userinteractiondata.talerttimesum,
    (userinteractiondata.talerttimesum / 86400.00) AS talerttimesumday,
    userinteractiondata.talerttimemax,
    (userinteractiondata.talerttimemax / 86400.00) AS talerttimemaxday,
    userinteractiondata.talerttimemin,
    (userinteractiondata.talerttimemin / 86400.00) AS talerttimeminday,
    userinteractiondata.tansweredcount,
    userinteractiondata.tansweredtimesum,
    (userinteractiondata.tansweredtimesum / 86400.00) AS tansweredtimesumday,
    userinteractiondata.tansweredtimemax,
    (userinteractiondata.tansweredtimemax / 86400.00) AS tansweredtimemaxday,
    userinteractiondata.tansweredtimemin,
    (userinteractiondata.tansweredtimemin / 86400.00) AS tansweredtimeminday,
    userinteractiondata.ttalkcount,
    userinteractiondata.ttalktimesum,
    (userinteractiondata.ttalktimesum / 86400.00) AS ttalktimesumday,
    userinteractiondata.ttalktimemax,
    (userinteractiondata.ttalktimemax / 86400.00) AS ttalktimemaxday,
    userinteractiondata.ttalktimemin,
    (userinteractiondata.ttalktimemin / 86400.00) AS ttalktimeminday,
    userinteractiondata.ttalkcompletecount,
    userinteractiondata.ttalkcompletetimesum,
    (userinteractiondata.ttalkcompletetimesum / 86400.00) AS ttalkcompletetimesumday,
    userinteractiondata.ttalkcompletetimemax,
    (userinteractiondata.ttalkcompletetimemax / 86400.00) AS ttalkcompletetimemaxday,
    userinteractiondata.ttalkcompletetimemin,
    (userinteractiondata.ttalkcompletetimemin / 86400.00) AS ttalkcompletetimeminday,
    userinteractiondata.tnotrespondingcount,
    userinteractiondata.tnotrespondingtimesum,
    (userinteractiondata.tnotrespondingtimesum / 86400.00) AS tnotrespondingtimesumday,
    userinteractiondata.tnotrespondingtimemax,
    (userinteractiondata.tnotrespondingtimemax / 86400.00) AS tnotrespondingtimemaxday,
    userinteractiondata.tnotrespondingtimemin,
    (userinteractiondata.tnotrespondingtimemin / 86400.00) AS tnotrespondingtimeminday,
    userinteractiondata.theldcount,
    userinteractiondata.theldtimesum,
    (userinteractiondata.theldtimesum / 86400.00) AS theldtimesumday,
    userinteractiondata.theldtimemax,
    (userinteractiondata.theldtimemax / 86400.00) AS theldtimemaxday,
    userinteractiondata.theldtimemin,
    (userinteractiondata.theldtimemin / 86400.00) AS theldtimeminday,
    userinteractiondata.theldcompletecount,
    userinteractiondata.theldcompletetimesum,
    (userinteractiondata.theldcompletetimesum / 86400.00) AS theldcompletetimesumday,
    userinteractiondata.theldcompletetimemax,
    (userinteractiondata.theldcompletetimemax / 86400.00) AS theldcompletetimemaxday,
    userinteractiondata.theldcompletetimemin,
    (userinteractiondata.theldcompletetimemin / 86400.00) AS theldcompletetimeminday,
    userinteractiondata.thandlecount,
    userinteractiondata.thandletimesum,
    (userinteractiondata.thandletimesum / 86400.00) AS thandletimesumday,
    userinteractiondata.thandletimemax,
    (userinteractiondata.thandletimemax / 86400.00) AS thandletimemaxday,
    userinteractiondata.thandletimemin,
    (userinteractiondata.thandletimemin / 86400.00) AS thandletimeminday,
    userinteractiondata.tacwcount,
    userinteractiondata.tacwtimesum,
    (userinteractiondata.tacwtimesum / 86400.00) AS tacwtimesumday,
    userinteractiondata.tacwtimemax,
    (userinteractiondata.tacwtimemax / 86400.00) AS tacwtimemaxday,
    userinteractiondata.tacwtimemin,
    (userinteractiondata.tacwtimemin / 86400.00) AS tacwtimeminday,
    userinteractiondata.nconsult,
    userinteractiondata.nconsulttransferred,
    userinteractiondata.noutbound,
    userinteractiondata.nerror,
    userinteractiondata.ntransferred,
    userinteractiondata.nblindtransferred,
    userinteractiondata.nconnected,
    userinteractiondata.tdialingcount,
    userinteractiondata.tdialingtimesum,
    (userinteractiondata.tdialingtimesum / 86400.00) AS tdialingtimesumday,
    userinteractiondata.tdialingtimemax,
    (userinteractiondata.tdialingtimemax / 86400.00) AS tdialingtimemaxday,
    userinteractiondata.tdialingtimemin,
    (userinteractiondata.tdialingtimemin / 86400.00) AS tdialingtimeminday,
    userinteractiondata.tcontactingcount,
    userinteractiondata.tcontactingtimesum,
    (userinteractiondata.tcontactingtimesum / 86400.00) AS tcontactingtimesumday,
    userinteractiondata.tcontactingtimemax,
    (userinteractiondata.tcontactingtimemax / 86400.00) AS tcontactingtimemaxday,
    userinteractiondata.tcontactingtimemin,
    (userinteractiondata.tcontactingtimemin / 86400.00) AS tcontactingtimeminday,
    userinteractiondata.tvoicemailcount,
    userinteractiondata.tvoicemailtimesum,
    (userinteractiondata.tvoicemailtimesum / 86400.00) AS tvoicemailtimesumday,
    userinteractiondata.tvoicemailtimemax,
    (userinteractiondata.tvoicemailtimemax / 86400.00) AS tvoicemailtimemaxday,
    userinteractiondata.tvoicemailtimemin,
    (userinteractiondata.tvoicemailtimemin / 86400.00) AS tvoicemailtimeminday,
    userinteractiondata.updated
   FROM (((userinteractiondata userinteractiondata
     LEFT JOIN vwuserdetail userdetail ON (((userdetail.id)::text = (userinteractiondata.userid)::text)))
     LEFT JOIN vwqueuedetails queuedetail ON (((queuedetail.id)::text = (userinteractiondata.queueid)::text)))
     LEFT JOIN wrapupdetails wrapupdetails ON (((wrapupdetails.id)::text = (userinteractiondata.wrapupcode)::text)))
)

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(255) true Primary Key
startdateutc timestamp without time zone true Start Date (UTC)
startdateltc timestamp without time zone true Start Date (LTC)
userid varchar(50) true User ID
agentname varchar(200) true Agent Name
managerid varchar(50) true Manager GUID
managername varchar(200) true Manager Name
agentdivisionid varchar(50) true
agentdivisionname varchar(50) true
direction varchar(50) true Interaction Direction
queueid varchar(50) true Queue GUID
queuename varchar(255) true Queue Name
divisionid varchar(50) true
divisionname varchar(50) true
mediatype varchar(50) true Media Type
wrapupcode varchar(255) true Wrap-up Code
wrapupdesc varchar(255) true Wrap-up Description
talertcount integer true Alert Count
talerttimesum numeric(20,2) true Total Alert Time
talerttimesumday numeric true Total Alert Time (Days)
talerttimemax numeric(20,2) true Maximum Alert Time
talerttimemaxday numeric true Maximum Alert Time (Days)
talerttimemin numeric(20,2) true Minimum Alert Time
talerttimeminday numeric true Minimum Alert Time (Days)
tansweredcount integer true Answered Count
tansweredtimesum numeric(20,2) true Total Answered Time
tansweredtimesumday numeric true Total Answered Time (Days)
tansweredtimemax numeric(20,2) true Maximum Answered Time
tansweredtimemaxday numeric true Maximum Answered Time (Days)
tansweredtimemin numeric(20,2) true Minimum Answered Time
tansweredtimeminday numeric true Minimum Answered Time (Days)
ttalkcount integer true Talk Count
ttalktimesum numeric(20,2) true Total Talk Time
ttalktimesumday numeric true Total Talk Time (Days)
ttalktimemax numeric(20,2) true Maximum Talk Time
ttalktimemaxday numeric true Maximum Talk Time (Days)
ttalktimemin numeric(20,2) true Minimum Talk Time
ttalktimeminday numeric true Minimum Talk Time (Days)
ttalkcompletecount integer true Completed Talk Count
ttalkcompletetimesum numeric(20,2) true Total Completed Talk Time
ttalkcompletetimesumday numeric true Total Completed Talk Time (Days)
ttalkcompletetimemax numeric(20,2) true Maximum Completed Talk Time
ttalkcompletetimemaxday numeric true Maximum Completed Talk Time (Days)
ttalkcompletetimemin numeric(20,2) true Minimum Completed Talk Time
ttalkcompletetimeminday numeric true Minimum Completed Talk Time (Days)
tnotrespondingcount integer true Not Responding Count
tnotrespondingtimesum numeric(20,2) true Total Not Responding Time
tnotrespondingtimesumday numeric true Total Not Responding Time (Days)
tnotrespondingtimemax numeric(20,2) true Maximum Not Responding Time
tnotrespondingtimemaxday numeric true Maximum Not Responding Time (Days)
tnotrespondingtimemin numeric(20,2) true Minimum Not Responding Time
tnotrespondingtimeminday numeric true Minimum Not Responding Time (Days)
theldcount integer true Held Count
theldtimesum numeric(20,2) true Total Held Time
theldtimesumday numeric true Total Held Time (Days)
theldtimemax numeric(20,2) true Maximum Held Time
theldtimemaxday numeric true Maximum Held Time (Days)
theldtimemin numeric(20,2) true Minimum Held Time
theldtimeminday numeric true Minimum Held Time (Days)
theldcompletecount integer true Completed Held Count
theldcompletetimesum numeric(20,2) true Total Completed Held Time
theldcompletetimesumday numeric true Total Completed Held Time (Days)
theldcompletetimemax numeric(20,2) true Maximum Completed Held Time
theldcompletetimemaxday numeric true Maximum Completed Held Time (Days)
theldcompletetimemin numeric(20,2) true Minimum Completed Held Time
theldcompletetimeminday numeric true Minimum Completed Held Time (Days)
thandlecount integer true Handle Count
thandletimesum numeric(20,2) true Total Handle Time
thandletimesumday numeric true Total Handle Time (Days)
thandletimemax numeric(20,2) true Maximum Handle Time
thandletimemaxday numeric true Maximum Handle Time (Days)
thandletimemin numeric(20,2) true Minimum Handle Time
thandletimeminday numeric true Minimum Handle Time (Days)
tacwcount integer true ACW Count
tacwtimesum numeric(20,2) true Total ACW Time
tacwtimesumday numeric true Total ACW Time (Days)
tacwtimemax numeric(20,2) true Maximum ACW Time
tacwtimemaxday numeric true Maximum ACW Time (Days)
tacwtimemin numeric(20,2) true Minimum ACW Time
tacwtimeminday numeric true Minimum ACW Time (Days)
nconsult integer true Number of Consult Calls
nconsulttransferred integer true Number of Consult Transfers
noutbound integer true Number of Outbound Calls
nerror integer true Number of Errors
ntransferred integer true Number of Transfers
nblindtransferred integer true Number of Blind Transfers
nconnected integer true Number of Connected Calls
tdialingcount integer true Dialing Count
tdialingtimesum numeric(20,2) true Total Dialing Time
tdialingtimesumday numeric true Total Dialing Time (Days)
tdialingtimemax numeric(20,2) true Maximum Dialing Time
tdialingtimemaxday numeric true Maximum Dialing Time (Days)
tdialingtimemin numeric(20,2) true Minimum Dialing Time
tdialingtimeminday numeric true Minimum Dialing Time (Days)
tcontactingcount integer true Contacting Count
tcontactingtimesum numeric(20,2) true Total Contacting Time
tcontactingtimesumday numeric true Total Contacting Time (Days)
tcontactingtimemax numeric(20,2) true Maximum Contacting Time
tcontactingtimemaxday numeric true Maximum Contacting Time (Days)
tcontactingtimemin numeric(20,2) true Minimum Contacting Time
tcontactingtimeminday numeric true Minimum Contacting Time (Days)
tvoicemailcount integer true Voicemail Count
tvoicemailtimesum numeric(20,2) true Total Voicemail Time
tvoicemailtimesumday numeric true Total Voicemail Time (Days)
tvoicemailtimemax numeric(20,2) true Maximum Voicemail Time
tvoicemailtimemaxday numeric true Maximum Voicemail Time (Days)
tvoicemailtimemin numeric(20,2) true Minimum Voicemail Time
tvoicemailtimeminday numeric true Minimum Voicemail Time (Days)
updated timestamp without time zone true

Referenced Tables

Name Columns Comment Type
public.userinteractiondata 112 User Interaction Data Interval Data - Interval is from (15-60) Min(s) BASE TABLE
public.vwuserdetail 17 See UserDetail: User Description in detail VIEW
public.vwqueuedetails 24 See QueueDetails: Queue Lookup data VIEW
public.wrapupdetails 3 Wrap Up Code Details Lookup Up Data BASE TABLE

    • Related Articles

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

    • public.evalquestiondata

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

    • public.userinteractionpresencedetaileddata

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false userid varchar(50) true starttime timestamp without time zone false starttimeltc timestamp without time zone true endtime timestamp without time zone ...

    • public.userpresencedata

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false id varchar(50) true userid varchar(50) true startdate timestamp without time zone false startdateltc timestamp without time zone true timetype ...