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