Queue Metrics

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
Channel varchar(255) true
CONTACTS_QUEUED smallint true
CONTACTS_HANDLED smallint true
CONTACTS_ABANDONED smallint true
CONTACTS_CONSULTED smallint true
CONTACTS_AGENT_HUNG_UP_FIRST smallint true
CONTACTS_HANDLED_INCOMING smallint true
CONTACTS_HANDLED_OUTBOUND smallint true
CONTACTS_HOLD_ABANDONS smallint true
CONTACTS_TRANSFERRED_IN smallint true
CONTACTS_TRANSFERRED_OUT smallint true
CONTACTS_TRANSFERRED_IN_FROM_QUEUE smallint true
CONTACTS_TRANSFERRED_OUT_FROM_QUEUE smallint true
CALLBACK_CONTACTS_HANDLED smallint true
API_CONTACTS_HANDLED smallint true
CONTACTS_MISSED smallint true
OCCUPANCY double precision true
HANDLE_TIME double precision true
AFTER_CONTACT_WORK_TIME double precision true
QUEUED_TIME double precision true
ABANDON_TIME double precision true
QUEUE_ANSWER_TIME double precision true
HOLD_TIME double precision true
INTERACTION_TIME double precision true
INTERACTION_AND_HOLD_TIME double precision true
SERVICE_LEVEL_15 double precision true
SERVICE_LEVEL_20 double precision true
SERVICE_LEVEL_25 double precision true
SERVICE_LEVEL_30 double precision true
SERVICE_LEVEL_45 double precision true
SERVICE_LEVEL_60 double precision true
SERVICE_LEVEL_90 double precision true
SERVICE_LEVEL_120 double precision true
SERVICE_LEVEL_180 double precision true
SERVICE_LEVEL_240 double precision true
SERVICE_LEVEL_300 double precision true
SERVICE_LEVEL_600 double precision true
db_last_updated timestamp without time zone true

Constraints

Name Type Definition
pk_queuemetrics PRIMARY KEY PRIMARY KEY (“QueueNameKey”)

Indexes

Name Definition
pk_queuemetrics CREATE UNIQUE INDEX pk_queuemetrics ON contactcentredb.queuemetrics USING btree (“QueueNameKey”)

Generated by tbls


    • Related Articles

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

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

    • public.vwcallsummary

      Description See Callummary : View for call summary data with aggregated metrics Table Definition CREATE VIEW vwcallsummary AS ( SELECT di.conversationid AS "Fact.ConversationId", qd.name AS "Fact.QueueName", di.conversationstartdate AS ...

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

    • README

      Logo Genesys Adapter Data Dictionary Tables Name Columns Comment Type public.tabledefinitions 5 Subscription Detailed Data BASE TABLE public.activeqmembersdata 9 Historical Active Membership of Queues BASE TABLE public.activitycodedetails 11 Activity ...