Queue Observations

Queue Observations

contactcentredb.queueobservations

Description

Columns

Name Type Default Nullable Children Parents Comment
QueueName varchar(255) false
LastUpdate timestamp without time zone true
AGENTS_ONLINE smallint true
AGENTS_AVAILABLE smallint true
AGENTS_ON_CALL smallint true
AGENTS_AFTER_CONTACT_WORK smallint true
AGENTS_ERROR smallint true
AGENTS_STAFFED smallint true
AGENTS_NON_PRODUCTIVE smallint true
CONTACTS_IN_QUEUE smallint true
OLDEST_CONTACT_AGE integer true
CONTACTS_SCHEDULED smallint true
db_last_updated timestamp without time zone true

Constraints

Name Type Definition
pk_queueobservations PRIMARY KEY PRIMARY KEY (“QueueName”)

Indexes

Name Definition
pk_queueobservations CREATE UNIQUE INDEX pk_queueobservations ON contactcentredb.queueobservations USING btree (“QueueName”)

Generated by tbls


    • Related Articles

    • Queue Metrics

      contactcentredb.queuemetrics Description Columns Name Type Default Nullable Children Parents Comment QueueNameKey varchar(255) false LastUpdate timestamp without time zone true StartDate timestamp without time zone true QueueName varchar(255) true ...

    • Queue Grouping Metrics

      Background Some customers may have excessive numbers of Genesys Cloud queues defined due to the nature of their business and or various legacy reasons. Managing hundreds of queues can present challenges in finding, sorting and filtering queue related ...

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

    • public.queueauditdata

      Description Audit Table for Queue Membership changes Columns Name Type Default Nullable Children Parents Comment keyid varchar(500) false Primary Key queueid varchar(50) true Queue GUID userid varchar(50) true User GUID addorremove varchar(10) true ...

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