public.queueinteractiondata

public.queueinteractiondata

Description

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

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(255) false Primary Key
direction varchar(50) true Direction
queueid varchar(50) true Queue GUID
mediatype varchar(50) true Media Type
wrapupcode varchar(255) true Wrap Up GUID
startdate timestamp without time zone false Interval Start Date (UTC)
startdateltc timestamp without time zone true Interval Start Date (LTC)
talertcount integer true Total Alert Count
talerttimesum numeric(20,2) true Total Alert Time (Seconds)
talerttimemax numeric(20,2) true Max Alert Time (Seconds)
talerttimemin numeric(20,2) true Min ACW Time (Seconds)
tansweredcount integer true Total Answered Count
tansweredtimesum numeric(20,2) true Total Answered Time (Seconds)
tansweredtimemax numeric(20,2) true Max Answered Time (Seconds)
tansweredtimemin numeric(20,2) true Min Answered Time (Seconds)
ttalkcount integer true Total Talk Count
ttalktimesum numeric(20,2) true Total Talk Time (Seconds)
ttalktimemax numeric(20,2) true Max Talk Time (Seconds)
ttalktimemin numeric(20,2) true Min Talk Time (Seconds)
ttalkcompletecount integer true Total Talk Count For Completed Conversations
ttalkcompletetimesum numeric(20,2) true Total Talk Time For Completed Conversations
ttalkcompletetimemax numeric(20,2) true Max Talk Time For Completed Conversations
ttalkcompletetimemin numeric(20,2) true Min Talk Time For Completed Conversations
tnotrespondingcount integer true Total Not Responding Count
tnotrespondingtimesum numeric(20,2) true Total Not Responding Time (Seconds)
tnotrespondingtimemax numeric(20,2) true Max Not Responding Time (Seconds)
tnotrespondingtimemin numeric(20,2) true Min Not Responding Time (Seconds)
theldcount integer true Total Hold Count
theldtimesum numeric(20,2) true Total Hold Time (Seconds)
theldtimemax numeric(20,2) true Max Hold Time (Seconds)
theldtimemin numeric(20,2) true Min Hold Time (Seconds)
theldcompletecount integer true Total Hold Count for Completed Conversations
theldcompletetimesum numeric(20,2) true Total Hold Time for Completed Conversations
theldcompletetimemax numeric(20,2) true Max Hold Time for Completed Conversations
theldcompletetimemin numeric(20,2) true Min Hold Time for Completed Conversations
thandlecount integer true Total Handle Count
thandletimesum numeric(20,2) true Total Handle Time (Seconds)
thandletimemax numeric(20,2) true Max Handle Time (Seconds)
thandletimemin numeric(20,2) true Min Handle Time (Seconds)
tacwcount integer true Total ACW Count
tacwtimesum numeric(20,2) true Total ACW Time (Seconds)
tacwtimemax numeric(20,2) true Max ACW Time (Seconds)
tacwtimemin numeric(20,2) true Min ACW Time (Seconds)
nconsult integer true Total Consult Count
nconsulttransferred integer true Total Consult Transfer Count
noutbound integer true Total OutBound Conversations
nerror integer true Total Error Count
ntransferred integer true Total Transfer Count
nblindtransferred integer true Total Blind Transfer Count
nconnected integer true Total Conversations Connected Count
noffered integer true Total Conversations Offered Count
noversla integer true Total Conversations Answered over the SLA Count
tacdcount integer true Total Conversations Queued Count
tacdtimesum numeric(20,2) true Total Conversations Queued Time (Seconds)
tacdtimemax numeric(20,2) true Max Conversations Queued Time (Seconds)
tacdtimemin numeric(20,2) true Min Conversations Queued Time (Seconds)
tdialingcount integer true Total Dialing Count
tdialingtimesum numeric(20,2) true Total Dialing Time (Seconds)
tdialingtimemax numeric(20,2) true Max Dialing Time (Seconds)
tdialingtimemin numeric(20,2) true Min Dialing Time (Seconds)
tcontactingcount integer true Total Contacting Count
tcontactingtimesum numeric(20,2) true Total Contacting Time (Seconds)
tcontactingtimemax numeric(20,2) true Max Contacting Time (Seconds)
tcontactingtimemin numeric(20,2) true Min Contacting Time (Seconds)
tvoicemailcount integer true Total Voicemail Count
tvoicemailtimesum numeric(20,2) true Total Voicemail Time (Seconds)
tvoicemailtimemax numeric(20,2) true Max Voicemail Time (Seconds)
tvoicemailtimemin numeric(20,2) true Min Voicemail Time (Seconds)
tflowoutcount integer true Total Flow Out Count
tflowouttimesum numeric(20,2) true Total Flow Out Time (Seconds)
tflowouttimemax numeric(20,2) true Max Flow Out Time (Seconds)
tflowouttimemin numeric(20,2) true Min Flow Out Time (Seconds)
twaitcount integer true Total Wait Count
twaittimesum numeric(20,2) true Total Wait Time (Seconds)
twaittimemax numeric(20,2) true Max Wait Time (Seconds)
twaittimemin numeric(20,2) true Min Wait Time (Seconds)
tabandoncount integer true Total Abandoned Count
tabandontimesum numeric(20,2) true Total Abandoned Time (Seconds)
tabandontimemax numeric(20,2) true Max Abandoned Time (Seconds)
tabandontimemin numeric(20,2) true Min Abandoned Time (Seconds)
servicelevelnumerator numeric(20,2) true Total Conversations Answer in SLA
serviceleveldenominator numeric(20,2) true Total Converstions Chosen for the GOS Calc by Genesys
av1count integer true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av1timesum numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av1timemax numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av1timemin numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av2count integer true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av2timesum numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av2timemax numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av2timemin numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av3count integer true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av3timesum numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av3timemax numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av3timemin numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av4count integer true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av4timesum numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av4timemax numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av4timemin numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av5count integer true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av5timesum numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av5timemax numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av5timemin numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av6count integer true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av6timesum numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av6timemax numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av6timemin numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av7count integer true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av7timesum numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av7timemax numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av7timemin numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av8count integer true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av8timesum numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av8timemax numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av8timemin numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av9count integer true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av9timesum numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av9timemax numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av9timemin numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av10count integer true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av10timesum numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av10timemax numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
av10timemin numeric(20,2) true Custom Configurable Field - Please Talk to UCA About the use of Aggregation Queries in the adapter
oservicetarget integer true Service Target Count
tivrcount integer true Total IVR Count
tivrtimesum numeric(20,2) true Total IVR Time (Seconds)
tivrtimemax numeric(20,2) true Max IVR Time (Seconds)
tivrtimemin numeric(20,2) true Min IVR Time (Seconds)
tshortabandoncount integer true Total Short Abandon Count
tshortabandontimesum numeric(20,2) true Total Short Abandon Time (Seconds)
tshortabandontimemax numeric(20,2) true Max Short Abandon Time (Seconds)
tshortabandontimemin numeric(20,2) true Min Short Abandon Time (Seconds)
tuserresponsetimecount integer true Total User Response Time Count
tuserresponsetimetimesum numeric(20,2) true Total User Response Time (Seconds)
tuserresponsetimetimemax numeric(20,2) true Max User Response Time (Seconds)
tuserresponsetimetimemin numeric(20,2) true Min User Response Time (Seconds)
tagentresponsetimecount integer true Total Agent Response Time Count
tagentresponsetimetimesum numeric(20,2) true Total Agent Response Time (Seconds)
tagentresponsetimetimemax numeric(20,2) true Max Agent Response Time (Seconds)
tagentresponsetimetimemin numeric(20,2) true Min Agent Response Time (Seconds)
updated timestamp without time zone true Date Row Updated (UTC)

Constraints

Name Type Definition
queueinteractiondatanw_pkey PRIMARY KEY PRIMARY KEY (keyid, startdate)

Indexes

Name Definition
queueinteractiondatanw_pkey CREATE UNIQUE INDEX queueinteractiondatanw_pkey ON ONLY public.queueinteractiondata USING btree (keyid, startdate)
QueueInteractionDataDate CREATE INDEX “QueueInteractionDataDate” ON ONLY public.queueinteractiondata USING btree (startdate)
QueueInteractionDataDateLTC CREATE INDEX “QueueInteractionDataDateLTC” ON ONLY public.queueinteractiondata USING btree (startdateltc)
QueueInteractionDataMedia CREATE INDEX “QueueInteractionDataMedia” ON ONLY public.queueinteractiondata USING btree (mediatype)
queueinteractiondata_startdateltc_cover CREATE INDEX queueinteractiondata_startdateltc_cover ON ONLY public.queueinteractiondata USING btree (startdateltc) INCLUDE (queueid, mediatype, direction)
QueueInteractionDataQueue CREATE INDEX “QueueInteractionDataQueue” ON ONLY public.queueinteractiondata USING btree (queueid)

    • Related Articles

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

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

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