Cisco Cisco IPCC Web Option Technical References

Page of 404
 
2-122
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Logger_Meters Table
Related tables:
Customer Definition (via CustomerDefinitionID)
Dialed Number (via LabelID)
Dialed Number Label (via LabelID)
Network Target (via NetworkTargetID)
Network Vru (via LabelID)
Routing Client (via RoutingClientID)
Logger_Meters Table
Central database only.
Contains performance information about the ICM Logger process. One copy of the Logger process runs 
on the Central Controller and another runs on each Admin Workstation.
The Logger process on the Admin Workstation creates a new Logger Meters row in the local database 
every five minutes. The Logger process on the Central Controller creates a new Logger Meters row in 
the central database every five minutes.
LabelType
The type of the label: 
0 = Normal
1 = DNIS Override (for MCI routing clients only)
2 = Busy
3 = Ring (for AT&T GTN only)
4 = Post-Query
5 = Resource
smallint
NOT NULL
RoutingClientID
Identifies the routing client that can receive this label.
smallint
AK1, FK, NOT 
NULL
Label
The label to be returned to the routing client.
varchar(32)
AK1, NOT 
NULL
Description
Additional information about the label.
varchar(255)
NULL
ChangeStamp
Incremented when the record is changed in the central 
database.
int
NOT NULL
Table 2-100 Label Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option
Table 2-101 Logger_Meters Table
Field Name
Description
Data Type
Keys and Null 
Option
DateTime
Record timestamp (unique).
smalldatetime
PK, NOT NULL
TimeZone
The time zone for the date and time. The value is the 
offset in minutes from GMT.
int
PK, NOT NULL