public.vwqueueinteractiondata

public.vwqueueinteractiondata

Description

Queue Interaction Data Interval Data - Interval is from (15-60) Min(s)

Table Definition

CREATE VIEW vwqueueinteractiondata AS (
 SELECT queueinteractiondata.keyid,
    queueinteractiondata.startdate,
    queueinteractiondata.startdateltc,
    queueinteractiondata.direction,
    queueinteractiondata.queueid,
    queuedetails.name AS queuename,
    queuedetails.divisionid AS queue_divisionid,
    divisiondetails.name AS queue_divisionname,
    queueinteractiondata.mediatype,
    queueinteractiondata.wrapupcode,
    wrapupdetails.name AS wrapupdesc,
    queueinteractiondata.talertcount,
    queueinteractiondata.talerttimesum,
    (queueinteractiondata.talerttimesum / 86400.00) AS talerttimesumday,
    queueinteractiondata.talerttimemax,
    (queueinteractiondata.talerttimemax / 86400.00) AS talerttimemaxday,
    queueinteractiondata.talerttimemin,
    (queueinteractiondata.talerttimemin / 86400.00) AS talerttimeminday,
    queueinteractiondata.tansweredcount,
    queueinteractiondata.tansweredtimesum,
    (queueinteractiondata.tansweredtimesum / 86400.00) AS tansweredtimesumday,
    queueinteractiondata.tansweredtimemax,
    (queueinteractiondata.tansweredtimemax / 86400.00) AS tansweredtimemaxday,
    queueinteractiondata.tansweredtimemin,
    (queueinteractiondata.tansweredtimemin / 86400.00) AS tansweredtimeminday,
    queueinteractiondata.ttalkcount,
    queueinteractiondata.ttalktimesum,
    (queueinteractiondata.ttalktimesum / 86400.00) AS ttalktimesumday,
    queueinteractiondata.ttalktimemax,
    (queueinteractiondata.ttalktimemax / 86400.00) AS ttalktimemaxday,
    queueinteractiondata.ttalktimemin,
    (queueinteractiondata.ttalktimemin / 86400.00) AS ttalktimeminday,
    queueinteractiondata.ttalkcompletecount,
    queueinteractiondata.ttalkcompletetimesum,
    (queueinteractiondata.ttalkcompletetimesum / 86400.00) AS ttalkcompletetimesumday,
    queueinteractiondata.ttalkcompletetimemax,
    (queueinteractiondata.ttalkcompletetimemax / 86400.00) AS ttalkcompletetimemaxday,
    queueinteractiondata.ttalkcompletetimemin,
    (queueinteractiondata.ttalkcompletetimemin / 86400.00) AS ttalkcompletetimeminday,
    queueinteractiondata.tnotrespondingcount,
    queueinteractiondata.tnotrespondingtimesum,
    (queueinteractiondata.tnotrespondingtimesum / 86400.00) AS tnotrespondingtimesumday,
    queueinteractiondata.tnotrespondingtimemax,
    (queueinteractiondata.tnotrespondingtimemax / 86400.00) AS tnotrespondingtimemaxday,
    queueinteractiondata.tnotrespondingtimemin,
    (queueinteractiondata.tnotrespondingtimemin / 86400.00) AS tnotrespondingtimeminday,
    queueinteractiondata.theldcount,
    queueinteractiondata.theldtimesum,
    (queueinteractiondata.theldtimesum / 86400.00) AS theldtimesumday,
    queueinteractiondata.theldtimemax,
    (queueinteractiondata.theldtimemax / 86400.00) AS theldtimemaxday,
    queueinteractiondata.theldtimemin,
    (queueinteractiondata.theldtimemin / 86400.00) AS theldtimeminday,
    queueinteractiondata.theldcompletecount,
    queueinteractiondata.theldcompletetimesum,
    (queueinteractiondata.theldcompletetimesum / 86400.00) AS theldcompletetimesumday,
    queueinteractiondata.theldcompletetimemax,
    (queueinteractiondata.theldcompletetimemax / 86400.00) AS theldcompletetimemaxday,
    queueinteractiondata.theldcompletetimemin,
    (queueinteractiondata.theldcompletetimemin / 86400.00) AS theldcompletetimeminday,
    queueinteractiondata.thandlecount,
    queueinteractiondata.thandletimesum,
    (queueinteractiondata.thandletimesum / 86400.00) AS thandletimesumday,
    queueinteractiondata.thandletimemax,
    (queueinteractiondata.thandletimemax / 86400.00) AS thandletimemaxday,
    queueinteractiondata.thandletimemin,
    (queueinteractiondata.thandletimemin / 86400.00) AS thandletimeminday,
    queueinteractiondata.tacwcount,
    queueinteractiondata.tacwtimesum,
    (queueinteractiondata.tacwtimesum / 86400.00) AS tacwtimesumday,
    queueinteractiondata.tacwtimemax,
    (queueinteractiondata.tacwtimemax / 86400.00) AS tacwtimemaxday,
    queueinteractiondata.tacwtimemin,
    (queueinteractiondata.tacwtimemin / 86400.00) AS tacwtimeminday,
    queueinteractiondata.nconsult,
    queueinteractiondata.nconsulttransferred,
    queueinteractiondata.noutbound,
    queueinteractiondata.nerror,
    queueinteractiondata.ntransferred,
    queueinteractiondata.nblindtransferred,
    queueinteractiondata.nconnected,
    queueinteractiondata.noffered,
    queueinteractiondata.noversla,
    queueinteractiondata.tacdcount,
    queueinteractiondata.tacdtimesum,
    (queueinteractiondata.tacdtimesum / 86400.00) AS tacdtimesumday,
    queueinteractiondata.tacdtimemax,
    (queueinteractiondata.tacdtimemax / 86400.00) AS tacdtimemaxday,
    queueinteractiondata.tacdtimemin,
    (queueinteractiondata.tacdtimemin / 86400.00) AS tacdtimeminday,
    queueinteractiondata.tdialingcount,
    queueinteractiondata.tdialingtimesum,
    (queueinteractiondata.tdialingtimesum / 86400.00) AS tdialingtimesumday,
    queueinteractiondata.tdialingtimemax,
    (queueinteractiondata.tdialingtimemax / 86400.00) AS tdialingtimemaxday,
    queueinteractiondata.tdialingtimemin,
    (queueinteractiondata.tdialingtimemin / 86400.00) AS tdialingtimeminday,
    queueinteractiondata.tcontactingcount,
    queueinteractiondata.tcontactingtimesum,
    (queueinteractiondata.tcontactingtimesum / 86400.00) AS tcontactingtimesumday,
    queueinteractiondata.tcontactingtimemax,
    (queueinteractiondata.tcontactingtimemax / 86400.00) AS tcontactingtimemaxday,
    queueinteractiondata.tcontactingtimemin,
    (queueinteractiondata.tcontactingtimemin / 86400.00) AS tcontactingtimeminday,
    queueinteractiondata.tvoicemailcount,
    queueinteractiondata.tvoicemailtimesum,
    (queueinteractiondata.tvoicemailtimesum / 86400.00) AS tvoicemailtimesumday,
    queueinteractiondata.tvoicemailtimemax,
    (queueinteractiondata.tvoicemailtimemax / 86400.00) AS tvoicemailtimemaxday,
    queueinteractiondata.tvoicemailtimemin,
    (queueinteractiondata.tvoicemailtimemin / 86400.00) AS tvoicemailtimeminday,
    queueinteractiondata.tflowoutcount,
    queueinteractiondata.tflowouttimesum,
    (queueinteractiondata.tflowouttimesum / 86400.00) AS tflowouttimesumday,
    queueinteractiondata.tflowouttimemax,
    (queueinteractiondata.tflowouttimemax / 86400.00) AS tflowouttimemaxday,
    queueinteractiondata.tflowouttimemin,
    (queueinteractiondata.tflowouttimemin / 86400.00) AS tflowouttimeminday,
    queueinteractiondata.twaitcount,
    queueinteractiondata.twaittimesum,
    (queueinteractiondata.twaittimesum / 86400.00) AS twaittimesumday,
    queueinteractiondata.twaittimemax,
    (queueinteractiondata.twaittimemax / 86400.00) AS twaittimemaxday,
    queueinteractiondata.twaittimemin,
    (queueinteractiondata.twaittimemin / 86400.00) AS twaittimeminday,
    (sum(queueinteractiondata.twaittimesum) / (sum(queueinteractiondata.twaitcount))::numeric) AS twaittimeavg,
    queueinteractiondata.tabandoncount,
    queueinteractiondata.tabandontimesum,
    (queueinteractiondata.tabandontimesum / 86400.00) AS tabandontimesumday,
    queueinteractiondata.tabandontimemax,
    (queueinteractiondata.tabandontimemax / 86400.00) AS tabandontimemaxday,
    queueinteractiondata.tabandontimemin,
    (queueinteractiondata.tabandontimemin / 86400.00) AS tabandontimeminday,
    (sum(queueinteractiondata.tabandontimesum) / (sum(queueinteractiondata.tabandoncount))::numeric) AS tabandontimeavg,
    ((sum(queueinteractiondata.tabandontimesum) / (sum(queueinteractiondata.tabandoncount))::numeric) / 86400.00) AS tabandontimeavgday,
    (sum(queueinteractiondata.tabandoncount) / NULLIF(sum(queueinteractiondata.noffered), 0)) AS tabandoncountavg,
    queueinteractiondata.servicelevelnumerator,
    queueinteractiondata.serviceleveldenominator,
    (sum(queueinteractiondata.servicelevelnumerator) / sum(queueinteractiondata.serviceleveldenominator)) AS servicelevelcalc,
    queueinteractiondata.av1count,
    queueinteractiondata.av1timesum,
    (queueinteractiondata.av1timesum / 86400.00) AS av1timesumday,
    queueinteractiondata.av1timemax,
    (queueinteractiondata.av1timemax / 86400.00) AS av1timemaxday,
    queueinteractiondata.av1timemin,
    (queueinteractiondata.av1timemin / 86400.00) AS av1timeminday,
    queueinteractiondata.av2count,
    queueinteractiondata.av2timesum,
    (queueinteractiondata.av2timesum / 86400.00) AS av2timesumday,
    queueinteractiondata.av2timemax,
    (queueinteractiondata.av2timemax / 86400.00) AS av2timemaxday,
    queueinteractiondata.av2timemin,
    (queueinteractiondata.av2timemin / 86400.00) AS av2timeminday,
    queueinteractiondata.av3count,
    queueinteractiondata.av3timesum,
    (queueinteractiondata.av3timesum / 86400.00) AS av3timesumday,
    queueinteractiondata.av3timemax,
    (queueinteractiondata.av3timemax / 86400.00) AS av3timemaxday,
    queueinteractiondata.av3timemin,
    (queueinteractiondata.av3timemin / 86400.00) AS av3timeminday,
    queueinteractiondata.av4count,
    queueinteractiondata.av4timesum,
    (queueinteractiondata.av4timesum / 86400.00) AS av4timesumday,
    queueinteractiondata.av4timemax,
    (queueinteractiondata.av4timemax / 86400.00) AS av4timemaxday,
    queueinteractiondata.av4timemin,
    (queueinteractiondata.av4timemin / 86400.00) AS av4timeminday,
    queueinteractiondata.av5count,
    queueinteractiondata.av5timesum,
    (queueinteractiondata.av5timesum / 86400.00) AS av5timesumday,
    queueinteractiondata.av5timemax,
    (queueinteractiondata.av5timemax / 86400.00) AS av5timemaxday,
    queueinteractiondata.av5timemin,
    (queueinteractiondata.av5timemin / 86400.00) AS av5timeminday,
    queueinteractiondata.av6count,
    queueinteractiondata.av6timesum,
    (queueinteractiondata.av6timesum / 86400.00) AS av6timesumday,
    queueinteractiondata.av6timemax,
    (queueinteractiondata.av6timemax / 86400.00) AS av6timemaxday,
    queueinteractiondata.av6timemin,
    (queueinteractiondata.av6timemin / 86400.00) AS av6timeminday,
    queueinteractiondata.av7count,
    queueinteractiondata.av7timesum,
    (queueinteractiondata.av7timesum / 86400.00) AS av7timesumday,
    queueinteractiondata.av7timemax,
    (queueinteractiondata.av7timemax / 86400.00) AS av7timemaxday,
    queueinteractiondata.av7timemin,
    (queueinteractiondata.av7timemin / 86400.00) AS av7timeminday,
    queueinteractiondata.av8count,
    queueinteractiondata.av8timesum,
    (queueinteractiondata.av8timesum / 86400.00) AS av8timesumday,
    queueinteractiondata.av8timemax,
    (queueinteractiondata.av8timemax / 86400.00) AS av8timemaxday,
    queueinteractiondata.av8timemin,
    (queueinteractiondata.av8timemin / 86400.00) AS av8timeminday,
    queueinteractiondata.av9count,
    queueinteractiondata.av9timesum,
    (queueinteractiondata.av9timesum / 86400.00) AS av9timesumday,
    queueinteractiondata.av9timemax,
    (queueinteractiondata.av9timemax / 86400.00) AS av9timemaxday,
    queueinteractiondata.av9timemin,
    (queueinteractiondata.av9timemin / 86400.00) AS av9timeminday,
    queueinteractiondata.av10count,
    queueinteractiondata.av10timesum,
    (queueinteractiondata.av10timesum / 86400.00) AS av10timesumday,
    queueinteractiondata.av10timemax,
    (queueinteractiondata.av10timemax / 86400.00) AS av10timemaxday,
    queueinteractiondata.av10timemin,
    (queueinteractiondata.av10timemin / 86400.00) AS av10timeminday,
    queueinteractiondata.updated
   FROM (((queueinteractiondata queueinteractiondata
     LEFT JOIN queuedetails queuedetails ON (((queuedetails.id)::text = (queueinteractiondata.queueid)::text)))
     LEFT JOIN wrapupdetails wrapupdetails ON (((wrapupdetails.id)::text = (queueinteractiondata.wrapupcode)::text)))
     LEFT JOIN divisiondetails divisiondetails ON (((queuedetails.divisionid)::text = (divisiondetails.id)::text)))
  GROUP BY queueinteractiondata.keyid, queueinteractiondata.startdate, queueinteractiondata.startdateltc, queueinteractiondata.direction, queueinteractiondata.queueid, queuedetails.name, queuedetails.divisionid, divisiondetails.name, queueinteractiondata.mediatype, queueinteractiondata.wrapupcode, wrapupdetails.name, queueinteractiondata.talertcount, queueinteractiondata.talerttimesum, queueinteractiondata.talerttimemax, queueinteractiondata.talerttimemin, queueinteractiondata.tansweredcount, queueinteractiondata.tansweredtimesum, queueinteractiondata.tansweredtimemax, queueinteractiondata.tansweredtimemin, queueinteractiondata.ttalkcount, queueinteractiondata.ttalktimesum, queueinteractiondata.ttalktimemax, queueinteractiondata.ttalktimemin, queueinteractiondata.ttalkcompletecount, queueinteractiondata.ttalkcompletetimesum, queueinteractiondata.ttalkcompletetimemax, queueinteractiondata.ttalkcompletetimemin, queueinteractiondata.tnotrespondingcount, queueinteractiondata.tnotrespondingtimesum, queueinteractiondata.tnotrespondingtimemax, queueinteractiondata.tnotrespondingtimemin, queueinteractiondata.theldcount, queueinteractiondata.theldtimesum, queueinteractiondata.theldtimemax, queueinteractiondata.theldtimemin, queueinteractiondata.theldcompletecount, queueinteractiondata.theldcompletetimesum, queueinteractiondata.theldcompletetimemax, queueinteractiondata.theldcompletetimemin, queueinteractiondata.thandlecount, queueinteractiondata.thandletimesum, queueinteractiondata.thandletimemax, queueinteractiondata.thandletimemin, queueinteractiondata.tacwcount, queueinteractiondata.tacwtimesum, queueinteractiondata.tacwtimemax, queueinteractiondata.tacwtimemin, queueinteractiondata.nconsult, queueinteractiondata.nconsulttransferred, queueinteractiondata.noutbound, queueinteractiondata.nerror, queueinteractiondata.ntransferred, queueinteractiondata.nblindtransferred, queueinteractiondata.nconnected, queueinteractiondata.noffered, queueinteractiondata.noversla, queueinteractiondata.tacdcount, queueinteractiondata.tacdtimesum, queueinteractiondata.tacdtimemax, queueinteractiondata.tacdtimemin, queueinteractiondata.tdialingcount, queueinteractiondata.tdialingtimesum, queueinteractiondata.tdialingtimemax, queueinteractiondata.tdialingtimemin, queueinteractiondata.tcontactingcount, queueinteractiondata.tcontactingtimesum, queueinteractiondata.tcontactingtimemax, queueinteractiondata.tcontactingtimemin, queueinteractiondata.tvoicemailcount, queueinteractiondata.tvoicemailtimesum, queueinteractiondata.tvoicemailtimemax, queueinteractiondata.tvoicemailtimemin, queueinteractiondata.tflowoutcount, queueinteractiondata.tflowouttimesum, queueinteractiondata.tflowouttimemax, queueinteractiondata.tflowouttimemin, queueinteractiondata.twaitcount, queueinteractiondata.twaittimesum, queueinteractiondata.twaittimemax, queueinteractiondata.twaittimemin, queueinteractiondata.tabandoncount, queueinteractiondata.tabandontimesum, queueinteractiondata.tabandontimemax, queueinteractiondata.tabandontimemin, queueinteractiondata.servicelevelnumerator, queueinteractiondata.serviceleveldenominator, queueinteractiondata.av1count, queueinteractiondata.av1timesum, queueinteractiondata.av1timemax, queueinteractiondata.av1timemin, queueinteractiondata.av2count, queueinteractiondata.av2timesum, queueinteractiondata.av2timemax, queueinteractiondata.av2timemin, queueinteractiondata.av3count, queueinteractiondata.av3timesum, queueinteractiondata.av3timemax, queueinteractiondata.av3timemin, queueinteractiondata.av4count, queueinteractiondata.av4timesum, queueinteractiondata.av4timemax, queueinteractiondata.av4timemin, queueinteractiondata.av5count, queueinteractiondata.av5timesum, queueinteractiondata.av5timemax, queueinteractiondata.av5timemin, queueinteractiondata.av6count, queueinteractiondata.av6timesum, queueinteractiondata.av6timemax, queueinteractiondata.av6timemin, queueinteractiondata.av7count, queueinteractiondata.av7timesum, queueinteractiondata.av7timemax, queueinteractiondata.av7timemin, queueinteractiondata.av8count, queueinteractiondata.av8timesum, queueinteractiondata.av8timemax, queueinteractiondata.av8timemin, queueinteractiondata.av9count, queueinteractiondata.av9timesum, queueinteractiondata.av9timemax, queueinteractiondata.av9timemin, queueinteractiondata.av10count, queueinteractiondata.av10timesum, queueinteractiondata.av10timemax, queueinteractiondata.av10timemin, queueinteractiondata.updated
)

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(255) true Primary Key
startdate timestamp without time zone true Start Date (UTC)
startdateltc timestamp without time zone true Start Date (LTC)
direction varchar(50) true Direction
queueid varchar(50) true Queue GUID
queuename varchar(255) true Queue Name
queue_divisionid varchar(50) true Queue Division GUID
queue_divisionname varchar(50) true Queue Division Name
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 Sum
talerttimesumday numeric true Total Alert Time Sum (Days)
talerttimemax numeric(20,2) true Max Alert Time
talerttimemaxday numeric true Max Alert Time (Days)
talerttimemin numeric(20,2) true Min Alert Time
talerttimeminday numeric true Min Alert Time (Days)
tansweredcount integer true Answered Count
tansweredtimesum numeric(20,2) true Total Answered Time Sum
tansweredtimesumday numeric true Total Answered Time Sum (Days)
tansweredtimemax numeric(20,2) true Max Answered Time
tansweredtimemaxday numeric true Max Answered Time (Days)
tansweredtimemin numeric(20,2) true Min Answered Time
tansweredtimeminday numeric true Min Answered Time (Days)
ttalkcount integer true Talk Count
ttalktimesum numeric(20,2) true Total Talk Time Sum
ttalktimesumday numeric true Total Talk Time Sum (Days)
ttalktimemax numeric(20,2) true Max Talk Time
ttalktimemaxday numeric true Max Talk Time (Days)
ttalktimemin numeric(20,2) true Min Talk Time
ttalktimeminday numeric true Min Talk Time (Days)
ttalkcompletecount integer true Talk Complete Count
ttalkcompletetimesum numeric(20,2) true Total Talk Complete Time Sum
ttalkcompletetimesumday numeric true Total Talk Complete Time Sum (Days)
ttalkcompletetimemax numeric(20,2) true Max Talk Complete Time
ttalkcompletetimemaxday numeric true Max Talk Complete Time (Days)
ttalkcompletetimemin numeric(20,2) true Min Talk Complete Time
ttalkcompletetimeminday numeric true Min Talk Complete Time (Days)
tnotrespondingcount integer true Not Responding Count
tnotrespondingtimesum numeric(20,2) true Total Not Responding Time Sum
tnotrespondingtimesumday numeric true Total Not Responding Time Sum (Days)
tnotrespondingtimemax numeric(20,2) true Max Not Responding Time
tnotrespondingtimemaxday numeric true Max Not Responding Time (Days)
tnotrespondingtimemin numeric(20,2) true Min Not Responding Time
tnotrespondingtimeminday numeric true Min Not Responding Time (Days)
theldcount integer true Held Count
theldtimesum numeric(20,2) true Total Held Time Sum
theldtimesumday numeric true Total Held Time Sum (Days)
theldtimemax numeric(20,2) true Max Held Time
theldtimemaxday numeric true Max Held Time (Days)
theldtimemin numeric(20,2) true Min Held Time
theldtimeminday numeric true Min Held Time (Days)
theldcompletecount integer true Held Complete Count
theldcompletetimesum numeric(20,2) true Total Held Complete Time Sum
theldcompletetimesumday numeric true Total Held Complete Time Sum (Days)
theldcompletetimemax numeric(20,2) true Max Held Complete Time
theldcompletetimemaxday numeric true Max Held Complete Time (Days)
theldcompletetimemin numeric(20,2) true Min Held Complete Time
theldcompletetimeminday numeric true Min Held Complete Time (Days)
thandlecount integer true Handle Count
thandletimesum numeric(20,2) true Total Handle Time Sum
thandletimesumday numeric true Total Handle Time Sum (Days)
thandletimemax numeric(20,2) true Max Handle Time
thandletimemaxday numeric true Max Handle Time (Days)
thandletimemin numeric(20,2) true Min Handle Time
thandletimeminday numeric true Min Handle Time (Days)
tacwcount integer true ACW Count
tacwtimesum numeric(20,2) true Total ACW Time Sum
tacwtimesumday numeric true Total ACW Time Sum (Days)
tacwtimemax numeric(20,2) true Max ACW Time
tacwtimemaxday numeric true Max ACW Time (Days)
tacwtimemin numeric(20,2) true Min ACW Time
tacwtimeminday numeric true Min ACW Time (Days)
nconsult integer true Consult Count
nconsulttransferred integer true Consult Transferred Count
noutbound integer true Outbound Count
nerror integer true Error Count
ntransferred integer true Transferred Count
nblindtransferred integer true Blind Transferred Count
nconnected integer true Connected Count
noffered integer true Offered Count
noversla integer true Over SLA Count
tacdcount integer true ACD Count
tacdtimesum numeric(20,2) true Total ACD Time Sum
tacdtimesumday numeric true Total ACD Time Sum (Days)
tacdtimemax numeric(20,2) true Max ACD Time
tacdtimemaxday numeric true Max ACD Time (Days)
tacdtimemin numeric(20,2) true Min ACD Time
tacdtimeminday numeric true Min ACD Time (Days)
tdialingcount integer true Dialing Count
tdialingtimesum numeric(20,2) true Total Dialing Time Sum
tdialingtimesumday numeric true Total Dialing Time Sum (Days)
tdialingtimemax numeric(20,2) true Max Dialing Time
tdialingtimemaxday numeric true Max Dialing Time (Days)
tdialingtimemin numeric(20,2) true Min Dialing Time
tdialingtimeminday numeric true Min Dialing Time (Days)
tcontactingcount integer true Contacting Count
tcontactingtimesum numeric(20,2) true Total Contacting Time Sum
tcontactingtimesumday numeric true Total Contacting Time Sum (Days)
tcontactingtimemax numeric(20,2) true Max Contacting Time
tcontactingtimemaxday numeric true Max Contacting Time (Days)
tcontactingtimemin numeric(20,2) true Min Contacting Time
tcontactingtimeminday numeric true Min Contacting Time (Days)
tvoicemailcount integer true Voicemail Count
tvoicemailtimesum numeric(20,2) true Total Voicemail Time Sum
tvoicemailtimesumday numeric true Total Voicemail Time Sum (Days)
tvoicemailtimemax numeric(20,2) true Max Voicemail Time
tvoicemailtimemaxday numeric true Max Voicemail Time (Days)
tvoicemailtimemin numeric(20,2) true Min Voicemail Time
tvoicemailtimeminday numeric true Min Voicemail Time (Days)
tflowoutcount integer true Flowout Count
tflowouttimesum numeric(20,2) true Total Flowout Time Sum
tflowouttimesumday numeric true Total Flowout Time Sum (Days)
tflowouttimemax numeric(20,2) true Max Flowout Time
tflowouttimemaxday numeric true Max Flowout Time (Days)
tflowouttimemin numeric(20,2) true Min Flowout Time
tflowouttimeminday numeric true Min Flowout Time (Days)
twaitcount integer true Wait Count
twaittimesum numeric(20,2) true Total Wait Time Sum
twaittimesumday numeric true Total Wait Time Sum (Days)
twaittimemax numeric(20,2) true Max Wait Time
twaittimemaxday numeric true Max Wait Time (Days)
twaittimemin numeric(20,2) true Min Wait Time
twaittimeminday numeric true Min Wait Time (Days)
twaittimeavg numeric true Average Wait Time
tabandoncount integer true Abandon Count
tabandontimesum numeric(20,2) true Total Abandon Time Sum
tabandontimesumday numeric true Total Abandon Time Sum (Days)
tabandontimemax numeric(20,2) true Max Abandon Time
tabandontimemaxday numeric true Max Abandon Time (Days)
tabandontimemin numeric(20,2) true Min Abandon Time
tabandontimeminday numeric true Min Abandon Time (Days)
tabandontimeavg numeric true Average Abandon Time
tabandontimeavgday numeric true
tabandoncountavg bigint true
servicelevelnumerator numeric(20,2) true Service Level Numerator
serviceleveldenominator numeric(20,2) true Service Level Denominator
servicelevelcalc numeric true Service Level Calculation
av1count integer true AV1 Count
av1timesum numeric(20,2) true Total AV1 Time Sum
av1timesumday numeric true Total AV1 Time Sum (Days)
av1timemax numeric(20,2) true Max AV1 Time
av1timemaxday numeric true Max AV1 Time (Days)
av1timemin numeric(20,2) true Min AV1 Time
av1timeminday numeric true Min AV1 Time (Days)
av2count integer true AV2 Count
av2timesum numeric(20,2) true Total AV2 Time Sum
av2timesumday numeric true Total AV2 Time Sum (Days)
av2timemax numeric(20,2) true Max AV2 Time
av2timemaxday numeric true Max AV2 Time (Days)
av2timemin numeric(20,2) true Min AV2 Time
av2timeminday numeric true Min AV2 Time (Days)
av3count integer true AV3 Count
av3timesum numeric(20,2) true Total AV3 Time Sum
av3timesumday numeric true Total AV3 Time Sum (Days)
av3timemax numeric(20,2) true Max AV3 Time
av3timemaxday numeric true Max AV3 Time (Days)
av3timemin numeric(20,2) true Min AV3 Time
av3timeminday numeric true Min AV3 Time (Days)
av4count integer true AV4 Count
av4timesum numeric(20,2) true Total AV4 Time Sum
av4timesumday numeric true Total AV4 Time Sum (Days)
av4timemax numeric(20,2) true Max AV4 Time
av4timemaxday numeric true Max AV4 Time (Days)
av4timemin numeric(20,2) true Min AV4 Time
av4timeminday numeric true Min AV4 Time (Days)
av5count integer true AV5 Count
av5timesum numeric(20,2) true Total AV5 Time Sum
av5timesumday numeric true Total AV5 Time Sum (Days)
av5timemax numeric(20,2) true Max AV5 Time
av5timemaxday numeric true Max AV5 Time (Days)
av5timemin numeric(20,2) true Min AV5 Time
av5timeminday numeric true Min AV5 Time (Days)
av6count integer true AV6 Count
av6timesum numeric(20,2) true Total AV6 Time Sum
av6timesumday numeric true Total AV6 Time Sum (Days)
av6timemax numeric(20,2) true Max AV6 Time
av6timemaxday numeric true Max AV6 Time (Days)
av6timemin numeric(20,2) true Min AV6 Time
av6timeminday numeric true Min AV6 Time (Days)
av7count integer true AV7 Count
av7timesum numeric(20,2) true Total AV7 Time Sum
av7timesumday numeric true Total AV7 Time Sum (Days)
av7timemax numeric(20,2) true Max AV7 Time
av7timemaxday numeric true Max AV7 Time (Days)
av7timemin numeric(20,2) true Min AV7 Time
av7timeminday numeric true Min AV7 Time (Days)
av8count integer true AV8 Count
av8timesum numeric(20,2) true Total AV8 Time Sum
av8timesumday numeric true Total AV8 Time Sum (Days)
av8timemax numeric(20,2) true Max AV8 Time
av8timemaxday numeric true Max AV8 Time (Days)
av8timemin numeric(20,2) true Min AV8 Time
av8timeminday numeric true Min AV8 Time (Days)
av9count integer true AV9 Count
av9timesum numeric(20,2) true Total AV9 Time Sum
av9timesumday numeric true Total AV9 Time Sum (Days)
av9timemax numeric(20,2) true Max AV9 Time
av9timemaxday numeric true Max AV9 Time (Days)
av9timemin numeric(20,2) true Min AV9 Time
av9timeminday numeric true Min AV9 Time (Days)
av10count integer true AV10 Count
av10timesum numeric(20,2) true Total AV10 Time Sum
av10timesumday numeric true Total AV10 Time Sum (Days)
av10timemax numeric(20,2) true Max AV10 Time
av10timemaxday numeric true Max AV10 Time (Days)
av10timemin numeric(20,2) true Min AV10 Time
av10timeminday numeric true Min AV10 Time (Days)
updated timestamp without time zone true

Referenced Tables

Name Columns Comment Type
public.queueinteractiondata 123 Queue Interaction Data Interval Data - Interval is from (15-60) Min(s) BASE TABLE
public.queuedetails 7 Queue Lookup data BASE TABLE
public.wrapupdetails 3 Wrap Up Code Details Lookup Up Data BASE TABLE
public.divisiondetails 4 BASE TABLE

    • Related Articles

    • public.vwqueueinteractiondatadaily

      Description Queue Interaction Data Daily Data Table Definition CREATE VIEW vwqueueinteractiondatadaily AS ( SELECT queueinteractiondatadaily.keyid, queueinteractiondatadaily.startdate, queueinteractiondatadaily.direction, ...

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