Cisco Cisco IP Contact Center Release 4.6.2 Technical References
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.
(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
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.
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.
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.
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
SequenceNumber
Used with RouterCallKey and RouterCallKeyDay to
identify related Route_Call_Detail record.
identify related Route_Call_Detail record.
int
NULL
Event
The event from network that caused the record to be
written:
written:
SUBSCRIBER_BUSY
NETWORK_BUSY
NO_REPLY
ABANDON
DISCONNECT
ROUTE_SELECT_FAILURE
ANSWER.
NETWORK_BUSY
NO_REPLY
ABANDON
DISCONNECT
ROUTE_SELECT_FAILURE
ANSWER.
smallint
NULL