public.vwqueueinteractiondatadaily

public.vwqueueinteractiondatadaily

Description

Queue Interaction Data Daily Data

Table Definition

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

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(255) true Primary Key
startdate timestamp without time zone true Start Datez(UTC)
direction varchar(50) true Direction of the interaction
queueid varchar(50) true Queue GUID
queuename varchar(255) true Name of the queue
queue_divisionid varchar(50) true Queue Division GUID
queue_divisionname varchar(50) true Name of the division of the queue
mediatype varchar(50) true Type of media for the interaction
wrapupcode varchar(255) true Wrap-up code associated with the interaction
wrapupdesc varchar(255) true Description of the wrap-up code
talertcount integer true Total count of alert events
talerttimesum numeric(20,2) true Total duration of alert events (in seconds)
talerttimesumday numeric true Total duration of alert events (in days)
talerttimemax numeric(20,2) true Maximum duration of a single alert event (in seconds)
talerttimemaxday numeric true Maximum duration of a single alert event (in days)
talerttimemin numeric(20,2) true Minimum duration of a single alert event (in seconds)
talerttimeminday numeric true Minimum duration of a single alert event (in days)
tansweredcount integer true Total count of answered events
tansweredtimesum numeric(20,2) true Total duration of answered events (in seconds)
tansweredtimesumday numeric true Total duration of answered events (in days)
tansweredtimemax numeric(20,2) true Maximum duration of a single answered event (in seconds)
tansweredtimemaxday numeric true Maximum duration of a single answered event (in days)
tansweredtimemin numeric(20,2) true Minimum duration of a single answered event (in seconds)
tansweredtimeminday numeric true Minimum duration of a single answered event (in days)
ttalkcount integer true Total count of talk events
ttalktimesum numeric(20,2) true Total duration of talk events (in seconds)
ttalktimesumday numeric true Total duration of talk events (in days)
ttalktimemax numeric(20,2) true Maximum duration of a single talk event (in seconds)
ttalktimemaxday numeric true Maximum duration of a single talk event (in days)
ttalktimemin numeric(20,2) true Minimum duration of a single talk event (in seconds)
ttalktimeminday numeric true Minimum duration of a single talk event (in days)
ttalkcompletecount integer true Total count of completed talk events
ttalkcompletetimesum numeric(20,2) true Total duration of completed talk events (in seconds)
ttalkcompletetimesumday numeric true Total duration of completed talk events (in days)
ttalkcompletetimemax numeric(20,2) true Maximum duration of a single completed talk event (in seconds)
ttalkcompletetimemaxday numeric true Maximum duration of a single completed talk event (in days)
ttalkcompletetimemin numeric(20,2) true Minimum duration of a single completed talk event (in seconds)
ttalkcompletetimeminday numeric true Minimum duration of a single completed talk event (in days)
tnotrespondingcount integer true Total count of not responding events
tnotrespondingtimesum numeric(20,2) true Total duration of not responding events (in seconds)
tnotrespondingtimesumday numeric true Total duration of not responding events (in days)
tnotrespondingtimemax numeric(20,2) true Maximum duration of a single not responding event (in seconds)
tnotrespondingtimemaxday numeric true Maximum duration of a single not responding event (in days)
tnotrespondingtimemin numeric(20,2) true Minimum duration of a single not responding event (in seconds)
tnotrespondingtimeminday numeric true Minimum duration of a single not responding event (in days)
theldcount integer true Total count of held events
theldtimesum numeric(20,2) true Total duration of held events (in seconds)
theldtimesumday numeric true Total duration of held events (in days)
theldtimemax numeric(20,2) true Maximum duration of a single held event (in seconds)
theldtimemaxday numeric true Maximum duration of a single held event (in days)
theldtimemin numeric(20,2) true Minimum duration of a single held event (in seconds)
theldtimeminday numeric true Minimum duration of a single held event (in days)
theldcompletecount integer true Total count of completed held events
theldcompletetimesum numeric(20,2) true Total duration of completed held events (in seconds)
theldcompletetimesumday numeric true Total duration of completed held events (in days)
theldcompletetimemax numeric(20,2) true Maximum duration of a single completed held event (in seconds)
theldcompletetimemaxday numeric true Maximum duration of a single completed held event (in days)
theldcompletetimemin numeric(20,2) true Minimum duration of a single completed held event (in seconds)
theldcompletetimeminday numeric true Minimum duration of a single completed held event (in days)
thandlecount integer true Total count of handle events
thandletimesum numeric(20,2) true Total duration of handle events (in seconds)
thandletimesumday numeric true Total duration of handle events (in days)
thandletimemax numeric(20,2) true Maximum duration of a single handle event (in seconds)
thandletimemaxday numeric true Maximum duration of a single handle event (in days)
thandletimemin numeric(20,2) true Minimum duration of a single handle event (in seconds)
thandletimeminday numeric true Minimum duration of a single handle event (in days)
tacwcount integer true Total count of after-call work (ACW) events
tacwtimesum numeric(20,2) true Total duration of after-call work (ACW) events (in seconds)
tacwtimesumday numeric true Total duration of after-call work (ACW) events (in days)
tacwtimemax numeric(20,2) true Maximum duration of a single after-call work (ACW) event (in seconds)
tacwtimemaxday numeric true Maximum duration of a single after-call work (ACW) event (in days)
tacwtimemin numeric(20,2) true Minimum duration of a single after-call work (ACW) event (in seconds)
tacwtimeminday numeric true Minimum duration of a single after-call work (ACW) event (in days)
nconsult integer true Total count of consultation events
nconsulttransferred integer true Total count of consultations transferred
noutbound integer true Total count of outbound interactions
nerror integer true Total count of error events
ntransferred integer true Total count of interactions transferred
nblindtransferred integer true Total count of interactions blindly transferred
nconnected integer true Total count of connected interactions
noffered integer true Total count of interactions offered
noversla integer true Total count of interactions oversla
tacdcount integer true Total count of Automatic Call Distributor (ACD) events
tacdtimesum numeric(20,2) true Total duration of Automatic Call Distributor (ACD) events (in seconds)
tacdtimesumday numeric true Total duration of Automatic Call Distributor (ACD) events (in days)
tacdtimemax numeric(20,2) true Maximum duration of a single Automatic Call Distributor (ACD) event (in seconds)
tacdtimemaxday numeric true Maximum duration of a single Automatic Call Distributor (ACD) event (in days)
tacdtimemin numeric(20,2) true Minimum duration of a single Automatic Call Distributor (ACD) event (in seconds)
tacdtimeminday numeric true Minimum duration of a single Automatic Call Distributor (ACD) event (in days)
tdialingcount integer true Total count of dialing events
tdialingtimesum numeric(20,2) true Total duration of dialing events (in seconds)
tdialingtimesumday numeric true Total duration of dialing events (in days)
tdialingtimemax numeric(20,2) true Maximum duration of a single dialing event (in seconds)
tdialingtimemaxday numeric true Maximum duration of a single dialing event (in days)
tdialingtimemin numeric(20,2) true Minimum duration of a single dialing event (in seconds)
tdialingtimeminday numeric true Minimum duration of a single dialing event (in days)
tcontactingcount integer true Total count of contacting events
tcontactingtimesum numeric(20,2) true Total duration of contacting events (in seconds)
tcontactingtimesumday numeric true Total duration of contacting events (in days)
tcontactingtimemax numeric(20,2) true Maximum duration of a single contacting event (in seconds)
tcontactingtimemaxday numeric true Maximum duration of a single contacting event (in days)
tcontactingtimemin numeric(20,2) true Minimum duration of a single contacting event (in seconds)
tcontactingtimeminday numeric true Minimum duration of a single contacting event (in days)
tvoicemailcount integer true Total count of voicemail events
tvoicemailtimesum numeric(20,2) true Total duration of voicemail events (in seconds)
tvoicemailtimesumday numeric true Total duration of voicemail events (in days)
tvoicemailtimemax numeric(20,2) true Maximum duration of a single voicemail event (in seconds)
tvoicemailtimemaxday numeric true Maximum duration of a single voicemail event (in days)
tvoicemailtimemin numeric(20,2) true Minimum duration of a single voicemail event (in seconds)
tvoicemailtimeminday numeric true Minimum duration of a single voicemail event (in days)
tflowoutcount integer true Total count of flow out events
tflowouttimesum numeric(20,2) true Total duration of flow out events (in seconds)
tflowouttimesumday numeric true Total duration of flow out events (in days)
tflowouttimemax numeric(20,2) true Maximum duration of a single flow out event (in seconds)
tflowouttimemaxday numeric true Maximum duration of a single flow out event (in days)
tflowouttimemin numeric(20,2) true Minimum duration of a single flow out event (in seconds)
tflowouttimeminday numeric true Minimum duration of a single flow out event (in days)
twaitcount integer true Total count of wait events
twaittimesum numeric(20,2) true Total duration of wait events (in seconds)
twaittimesumday numeric true Total duration of wait events (in days)
twaittimemax numeric(20,2) true Maximum duration of a single wait event (in seconds)
twaittimemaxday numeric true Maximum duration of a single wait event (in days)
twaittimemin numeric(20,2) true Minimum duration of a single wait event (in seconds)
twaittimeminday numeric true Minimum duration of a single wait event (in days)
tabandoncount integer true Total count of abandon events
tabandontimesum numeric(20,2) true Total duration of abandon events (in seconds)
tabandontimesumday numeric true Total duration of abandon events (in days)
tabandontimemax numeric(20,2) true Maximum duration of a single abandon event (in seconds)
tabandontimemaxday numeric true Maximum duration of a single abandon event (in days)
tabandontimemin numeric(20,2) true Minimum duration of a single abandon event (in seconds)
tabandontimeminday numeric true Minimum duration of a single abandon event (in days)
servicelevelnumerator numeric(20,2) true Numerator for calculating service level
serviceleveldenominator numeric(20,2) true Denominator for calculating service level
av1count integer true Total count of custom average events 1
av1timesum numeric(20,2) true Total duration of custom average events 1 (in seconds)
av1timesumday numeric true Total duration of custom average events 1 (in days)
av1timemax numeric(20,2) true Maximum duration of a single custom average event 1 (in seconds)
av1timemaxday numeric true Maximum duration of a single custom average event 1 (in days)
av1timemin numeric(20,2) true Minimum duration of a single custom average event 1 (in seconds)
av1timeminday numeric true Minimum duration of a single custom average event 1 (in days)
av2count integer true Total count of custom average events 2
av2timesum numeric(20,2) true Total duration of custom average events 2 (in seconds)
av2timesumday numeric true Total duration of custom average events 2 (in days)
av2timemax numeric(20,2) true Maximum duration of a single custom average event 2 (in seconds)
av2timemaxday numeric true Maximum duration of a single custom average event 2 (in days)
av2timemin numeric(20,2) true Minimum duration of a single custom average event 2 (in seconds)
av2timeminday numeric true Minimum duration of a single custom average event 2 (in days)
av3count integer true Total count of custom average events 3
av3timesum numeric(20,2) true Total duration of custom average events 3 (in seconds)
av3timesumday numeric true Total duration of custom average events 3 (in days)
av3timemax numeric(20,2) true Maximum duration of a single custom average event 3 (in seconds)
av3timemaxday numeric true Maximum duration of a single custom average event 3 (in days)
av3timemin numeric(20,2) true Minimum duration of a single custom average event 3 (in seconds)
av3timeminday numeric true Minimum duration of a single custom average event 3 (in days)
av4count integer true Total count of custom average events 4
av4timesum numeric(20,2) true Total duration of custom average events 4 (in seconds)
av4timesumday numeric true Total duration of custom average events 4 (in days)
av4timemax numeric(20,2) true Maximum duration of a single custom average event 4 (in seconds)
av4timemaxday numeric true Maximum duration of a single custom average event 4 (in days)
av4timemin numeric(20,2) true Minimum duration of a single custom average event 4 (in seconds)
av4timeminday numeric true Minimum duration of a single custom average event 4 (in days)
av5count integer true Total count of custom average events 5
av5timesum numeric(20,2) true Total duration of custom average events 5 (in seconds)
av5timesumday numeric true Total duration of custom average events 5 (in days)
av5timemax numeric(20,2) true Maximum duration of a single custom average event 5 (in seconds)
av5timemaxday numeric true Maximum duration of a single custom average event 5 (in days)
av5timemin numeric(20,2) true Minimum duration of a single custom average event 5 (in seconds)
av5timeminday numeric true Minimum duration of a single custom average event 5 (in 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.queueinteractiondatadaily 123 BASE TABLE
public.queuedetails 17 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.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 ...