public.vwqueuedetails

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,
    "substring"((qd.description)::text, 'region=([^;]+)(;|$)'::text) AS region,
    "substring"((qd.description)::text, 'grouptype=([^;]+)(;|$)'::text) AS grouptype,
    "substring"((qd.description)::text, 'country=([^;]+)(;|$)'::text) AS country,
    "substring"((qd.description)::text, 'language=([^;]+)(;|$)'::text) AS language,
    "substring"((qd.description)::text, 'accountowner=([^;]+)(;|$)'::text) AS accountowner,
    qd.divisionid,
    divisiondetails.name AS divisionname,
    divisiondetails.name AS vwuserpresencedata,
    qd.enabletranscription,
    qd.isactive,
    qd.callslatargetperc,
    qd.callslatargetduration,
    qd.callbackslatargetperc,
    qd.callbackslatargetduration,
    qd.chatslatargetperc,
    qd.chatslatargetduration,
    qd.emailslatargetperc,
    qd.emailslatargetduration,
    qd.messageslatargetperc,
    qd.messageslatargetduration
   FROM (queuedetails qd
     JOIN divisiondetails divisiondetails ON (((qd.divisionid)::text = (divisiondetails.id)::text)))
)

Columns

Name Type Default Nullable Children Parents Comment
id varchar(50) true Primary Key/Queue ID
name varchar(255) true Queue Name
description varchar(255) true Queue Description
queuegroup text true Queue Group
region text true Region
grouptype text true Group Type
country text true Country
language text true Language
accountowner text true
divisionid varchar(50) true Queue Division ID
divisionname varchar(50) true Queue Division Name
vwuserpresencedata varchar(50) true User Presence Data
enabletranscription boolean true Enable Transcription Yes/No
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

Referenced Tables

Name Columns Comment Type
public.queuedetails 17 Queue Lookup data BASE TABLE
public.divisiondetails 4 BASE TABLE

    • Related Articles

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

      Description Audit Table for Queue Membership changes Table Definition CREATE VIEW vwqueueauditdata AS ( SELECT qa.queueid, qa.userid, ud.name, ud.department, ud.managername, qa.addorremove, qa.activeorinactive, qa.datemodified, qa.modifiedby, ...

    • public.vwrealtimequeue

      Description Real-time queue data Table Definition CREATE VIEW vwrealtimequeue AS ( SELECT qd.id AS queueid, qd.name AS queuename, qd.divisionid, qd.divisionname, qr.media, COALESCE(qr.conversationstate, ''::character varying) AS conversationstate, ...

    • public.vwuserinteractiondata

      Description See UserInteractionData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwuserinteractiondata AS ( SELECT userinteractiondata.keyid, userinteractiondata.startdate AS startdateutc, userinteractiondata.startdateltc, ...

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