Cisco Cisco IP Contact Center Release 4.6.2 Technical References

Page of 404
 
2-129
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Network_Event_Detail Table
Network_Event_Detail Table
Provides carrier network events associated with calls processed by a Network Applications Manager 
(NAM). The data in this table includes events related to all call legs that happen under the control of the 
NIC. This includes the incoming call leg, any temporary call legs (IVR sessions under NIC control), and 
all outgoing call legs.
Table 2-107 Network_Event_Detail Table
Field Name
Description
Data Type
Keys and Null 
Option
CallLegID
Used with the RouterCallKey and 
RouterCallSequenceNumber to identify the related 
Route_Call_Detail record. This field also provides a link 
to the CustomerID via the DialedNumberID in the 
Route_Call_Detail record. This link can only be used if 
CustomerID and Dialed Numbers are implemented on the 
NAM.
smallint
NOT NULL
RouterCallKeyDay
Used with the RouterCallKey and 
RouterCallKeySequenceNumber to identify the related 
Route_Call_Detail record. Together with RouterCallKey, 
the RouterCallKeyDay value forms a unique 64-bit key for 
the call. This field also provide a link to the CustomerID 
via the DialedNumberID in the Route_Call_Detail record. 
This link can only be used if CustomerID and Dialed 
Numbers are implemented on the NAM.
int
NOT NULL
RouterCallKey
Used with RouterCallKeyDay and 
RouterCallKeySequenceNumber to identify the 
Route_Call_Detail record. This value forms the unique 
portion of the 64-bit key for the call. The ICM software 
resets this counter at midnight.
int
NOT NULL
DateTime
Timestamp of receipt of event at the NIC (in UTC).
datetime
NOTNULL
RouterCallKey-
SequenceNumber
Used with RouterCallKey and RouterCallKeyDay to 
identify related Route_Call_Detail record.
int
NULL
Event
The event from network that caused the record to be 
written: 
SUBSCRIBER_BUSY
NETWORK_BUSY
NO_REPLY
ABANDON
DISCONNECT
ROUTE_SELECT_FAILURE
ANSWER.
smallint
NULL