public.queuedetails

public.queuedetails

Description

Queue Lookup data

Columns

Name Type Default Nullable Children Parents Comment
id varchar(50) false Primary Key / Queue GUID
name varchar(255) true Queue Name
description varchar(255) true
divisionid varchar(50) true Queue Division GUID
updated timestamp without time zone true Date Row Updated (UTC)
enabletranscription boolean true Queue Transcriptions Enabled?
isactive boolean true Active Yes/No
callslatargetperc double precision true SLA Target Percentage for Calls
callslatargetduration integer true SLA Target Duraction (sec) for Calls
callbackslatargetperc double precision true SLA Target Percentage for Callbacks
callbackslatargetduration integer true SLA Target Duraction (sec) for Callbacks
chatslatargetperc double precision true SLA Target Percentage for Chats
chatslatargetduration integer true SLA Target Duraction (sec) for Chats
emailslatargetperc double precision true SLA Target Percentage for Emails
emailslatargetduration integer true SLA Target Duraction (sec) for Emails
messageslatargetperc double precision true SLA Target Percentage for Messages
messageslatargetduration integer true SLA Target Duraction (sec) for Messages
assistantid varchar(100) true Assistant ID if queue has assistant enabled
assistantstate varchar(20) true Assistant state (Active, Inactive, etc.)
assistantmediatypes text true Comma-separated list of media types with assistant enabled (Call, Message, Email)
assistantenabled boolean true Whether queue has an assistant enabled for Call media type

Constraints

Name Type Definition
queuedetails_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
queuedetails_pkey CREATE UNIQUE INDEX queuedetails_pkey ON public.queuedetails USING btree (id)

    • Related Articles

    • public.vwqueueconvrealtime

      Description See QueueConvRealTime: Queue Conversation Real-Time Data Table Definition CREATE VIEW vwqueueconvrealtime AS ( SELECT queuerealtimeconvdata.conversationid, queuerealtimeconvdata.media, queuerealtimeconvdata.actingas, ...

    • public.vwqueuerealtimedata

      Description Table Definition CREATE VIEW vwqueuerealtimedata AS ( SELECT qc.keyid, qc.queueid, qd.name AS queuename, qc.media, qc.statscount, qc.startdate, qc.startdateltc, COALESCE(datediff('second'::character varying, qc.startdate, ...

    • public.vwuserqueuemappings

      Description UserQueueMappings: View for mappings in between User and Queue Table Definition CREATE VIEW vwuserqueuemappings AS ( SELECT qm.queueid, qd.name AS queuename, qm.userid, ud.name, ud.department, ud.managername, qm.divisionid FROM ...

    • public.vwheadcountforecast

      Description See HeadCountForecast - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwheadcountforecast AS ( SELECT hcf.businessunitid, bu.name AS businessunitname, hcf.planninggroup AS planninggroup_id, pg.name AS ...

    • public.vwsurveydata

      Description Survey Data View Table Definition CREATE VIEW vwsurveydata AS ( SELECT surveydata.surveyid, surveydata.conversationid, surveydata.surveyformid, surveydata.surveyname, surveydata.agentid, agent.name AS agentname, agent.department AS ...