Table name: queues

Contains/Role: This is a kind of “support table” for the event tables. Holds a more descriptive text for the queue_keys used in table call_events and agent_events. If joined from the event tables, both service_num and menue_key should be used as join criteria, since databases holding data for more than one customer might have duplicates for the key alone. Outer join is recommended since all keys in use not necessarily has a description defined in this table


Column Name Datatype Description
service_num Varchar(100)


queue_key nvarchar(100) The key used in the call_events and agent_events tables.
descript nvarchar(255) Describes the key.


Last updated