public.queueinteractiondatadaily

public.queueinteractiondatadaily

Description

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(255) false
direction varchar(50) true
queueid varchar(50) true
mediatype varchar(50) true
wrapupcode varchar(255) true
startdate timestamp without time zone true
talertcount integer true
talerttimesum numeric(20,2) true
talerttimemax numeric(20,2) true
talerttimemin numeric(20,2) true
tansweredcount integer true
tansweredtimesum numeric(20,2) true
tansweredtimemax numeric(20,2) true
tansweredtimemin numeric(20,2) true
ttalkcount integer true
ttalktimesum numeric(20,2) true
ttalktimemax numeric(20,2) true
ttalktimemin numeric(20,2) true
ttalkcompletecount integer true
ttalkcompletetimesum numeric(20,2) true
ttalkcompletetimemax numeric(20,2) true
ttalkcompletetimemin numeric(20,2) true
tnotrespondingcount integer true
tnotrespondingtimesum numeric(20,2) true
tnotrespondingtimemax numeric(20,2) true
tnotrespondingtimemin numeric(20,2) true
theldcount integer true
theldtimesum numeric(20,2) true
theldtimemax numeric(20,2) true
theldtimemin numeric(20,2) true
theldcompletecount integer true
theldcompletetimesum numeric(20,2) true
theldcompletetimemax numeric(20,2) true
theldcompletetimemin numeric(20,2) true
thandlecount integer true
thandletimesum numeric(20,2) true
thandletimemax numeric(20,2) true
thandletimemin numeric(20,2) true
tacwcount integer true
tacwtimesum numeric(20,2) true
tacwtimemax numeric(20,2) true
tacwtimemin numeric(20,2) true
nconsult integer true
nconsulttransferred integer true
noutbound integer true
nerror integer true
ntransferred integer true
nblindtransferred integer true
nconnected integer true
noffered integer true
noversla integer true
tacdcount integer true
tacdtimesum numeric(20,2) true
tacdtimemax numeric(20,2) true
tacdtimemin numeric(20,2) true
tdialingcount integer true
tdialingtimesum numeric(20,2) true
tdialingtimemax numeric(20,2) true
tdialingtimemin numeric(20,2) true
tcontactingcount integer true
tcontactingtimesum numeric(20,2) true
tcontactingtimemax numeric(20,2) true
tcontactingtimemin numeric(20,2) true
tvoicemailcount integer true
tvoicemailtimesum numeric(20,2) true
tvoicemailtimemax numeric(20,2) true
tvoicemailtimemin numeric(20,2) true
tflowoutcount integer true
tflowouttimesum numeric(20,2) true
tflowouttimemax numeric(20,2) true
tflowouttimemin numeric(20,2) true
twaitcount integer true
twaittimesum numeric(20,2) true
twaittimemax numeric(20,2) true
twaittimemin numeric(20,2) true
tabandoncount integer true
tabandontimesum numeric(20,2) true
tabandontimemax numeric(20,2) true
tabandontimemin numeric(20,2) true
servicelevelnumerator numeric(20,2) true
serviceleveldenominator numeric(20,2) true
av1count integer true
av1timesum numeric(20,2) true
av1timemax numeric(20,2) true
av1timemin numeric(20,2) true
av2count integer true
av2timesum numeric(20,2) true
av2timemax numeric(20,2) true
av2timemin numeric(20,2) true
av3count integer true
av3timesum numeric(20,2) true
av3timemax numeric(20,2) true
av3timemin numeric(20,2) true
av4count integer true
av4timesum numeric(20,2) true
av4timemax numeric(20,2) true
av4timemin numeric(20,2) true
av5count integer true
av5timesum numeric(20,2) true
av5timemax numeric(20,2) true
av5timemin numeric(20,2) true
av6count integer true
av6timesum numeric(20,2) true
av6timemax numeric(20,2) true
av6timemin numeric(20,2) true
av7count integer true
av7timesum numeric(20,2) true
av7timemax numeric(20,2) true
av7timemin numeric(20,2) true
av8count integer true
av8timesum numeric(20,2) true
av8timemax numeric(20,2) true
av8timemin numeric(20,2) true
av9count integer true
av9timesum numeric(20,2) true
av9timemax numeric(20,2) true
av9timemin numeric(20,2) true
av10count integer true
av10timesum numeric(20,2) true
av10timemax numeric(20,2) true
av10timemin numeric(20,2) true
updated timestamp without time zone true
startdateltc timestamp without time zone true

Constraints

Name Type Definition
queueinteractiondatadaily_pkey PRIMARY KEY PRIMARY KEY (keyid)

Indexes

Name Definition
queueinteractiondatadaily_pkey CREATE UNIQUE INDEX queueinteractiondatadaily_pkey ON public.queueinteractiondatadaily USING btree (keyid)

    • Related Articles

    • public.vwqueueinteractiondatadaily

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

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