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

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

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

    • public.vwsurveyquestiongroupscores

      Description Survey Question Group Scores View Table Definition CREATE VIEW vwsurveyquestiongroupscores AS ( SELECT surveyquestiongroupscores.surveyid, surveyquestiongroupscores.conversationid, surveyquestiongroupscores.surveyformid, ...

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

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