- Contents
Interaction Director Logging and Reporting Help
QueueStatsSummary Table
Interaction Director Local/Remote Statistics report uses this table. The system summarizes and moves data from logging tables to this summary table, periodically. The system uses this summary table to create Local and Remote statistics reports.
The following table describes the values summarized for this table.
|
Name |
Type |
Description |
|
QueueName |
Varchar(50) Cannot be NULL |
Name of the queue configured in Director Server. |
|
Server id |
Varchar(8) Cannot be NULL |
Site ID of the interested queue. |
|
Server Name |
Varchar(48) Cannot be NULL |
Server name. |
|
EnterpriseGroup |
Varchar (48) Cannot be NULL |
Name of the enterprise group associated to the queue. |
|
InteractionType |
Tiny int Cannot be NULL |
Numeric code that identifies the type of interaction. |
|
StartSumTime |
DateTime Cannot be NULL |
Start of the summary time in GMT. This value passes as an input parameter to the stored procedure. |
|
EndSumTime |
DateTime Cannot be NULL |
End of the summary time in GMT. This value passes as an input parameter to the stored procedure. |
|
nLLAnsSL1 |
Integer (default to 0) |
Local Receive Local Answer Service Threshold 1. |
|
nLLAnsSL2 |
Integer (default to 0) |
Local Receive Local Answer Service Threshold 2. |
|
nLLAnsSL3 |
Integer (default to 0) |
Local Receive Local Answer Service Threshold 3. |
|
nLLAnsSL4 |
Integer (default to 0) |
Local Receive Local Answer Service Threshold 4. |
|
nLLAnsSL5 |
Integer (default to 0) |
Local Receive Local Answer Service Threshold 5. |
|
nLLAnsSL6 |
Integer (default to 0) |
Local Receive Local Answer Service Threshold 6. |
|
nLLAnsSL7 |
Integer (default to 0) |
Local Receive Local Answer Service Threshold 7. |
|
nLRAnsSL1 |
Integer (default to 0) |
Local Receive Remo Answer Service Threshold 1. |
|
nLRAnsSL2 |
Integer (default to 0) |
Local Receive Remo Answer Service Threshold 2. |
|
nLRAnsSL3 |
Integer (default to 0) |
Local Receive Remo Answer Service Threshold 3. |
|
nLRAnsSL4 |
Integer (default to 0) |
Local Receive Remo Answer Service Threshold 4. |
|
nLRAnsSL5 |
Integer (default to 0) |
Local Receive Remo Answer Service Threshold 5. |
|
nLRAnsSL6 |
Integer (default to 0) |
Local Receive Remo Answer Service Threshold 6. |
|
nLRAnsSL7 |
Integer (default to 0) |
Local Receive Remo Answer Service Threshold 7. |
|
nRLAnsSL1 |
Integer (default to 0) |
Remote Receive Local Answer Service Threshold 1. |
|
nRLAnsSL2 |
Integer (default to 0) |
Remote Receive Local Answer Service Threshold 2. |
|
nRLAnsSL3 |
Integer (default to 0) |
Remote Receive Local Answer Service Threshold 3. |
|
nRLAnsSL4 |
Integer (default to 0) |
Remote Receive Local Answer Service Threshold 4. |
|
nRLAnsSL5 |
Integer (default to 0) |
Remote Receive Local Answer Service Threshold 5. |
|
nRLAnsSL6 |
Integer (default to 0) |
Remote Receive Local Answer Service Threshold 6. |
|
nRLAnsSL7 |
Integer (default to 0) |
Remote Receive Local Answer Service Threshold 7. |
|
nCustomValue1 |
Integer |
Custom column for future use. |
|
nCustomValue2 |
Integer |
Custom column for future use. |
|
nCustomValue3 |
Integer |
Custom column for future use. |
|
nCustomValue4 |
Integer |
Custom column for future use. |
|
nCustomValue5 |
Integer |
Custom column for future use. |
|
nCustomValue6 |
Integer |
Custom column for future use. |
|
I3TimeStampGMT |
DateTime Cannot be NULL |
Used for purging the table. |