public.queuedetails

Description

Queue Lookup data

Name	Type	Nullable	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

Name	Type	Definition
queuedetails_pkey	PRIMARY KEY	PRIMARY KEY (id)

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.vwqueuedetails
Description See QueueDetails: Queue Lookup data Table Definition CREATE VIEW vwqueuedetails AS ( SELECT qd.id, qd.name, qd.description, "substring"((qd.description)::text, 'queuegroup=([^;]+)(;|$)'::text) AS queuegroup, ...
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 ...