Cisco Cisco IPCC Web Option Technical References
2-130
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Network_Target Table
Network_Target Table
Each row identifies an announcement, a peripheral target, or a scheduled target.
The ICM software automatically maintains the Network_Target table when add or delete an
announcement, peripheral target, or scheduled target through ICM Configuration Manager.
announcement, peripheral target, or scheduled target through ICM Configuration Manager.
Related tables:
Announcement (via NetworkTargetID)
Device Target (via NetworkTargetID)
Label (via NetworkTargetID)
Duration
Call duration. This field is only written for
DISCONNECT/ABANDON events, when the call has
been answered. (The field prevents the joining of two
event records for call duration reporting purposes).
DISCONNECT/ABANDON events, when the call has
been answered. (The field prevents the joining of two
event records for call duration reporting purposes).
Duration is measured in as the number of seconds between
the NIC timestamps for ANSWER and
DISCONNECT/ABANDON.
the NIC timestamps for ANSWER and
DISCONNECT/ABANDON.
int
NULL
RecoveryDay
A value used internally by the ICM software to track
virtual time.
virtual time.
int
NOT NULL
RecoveryKey
A value used internally by the ICM software to track the
record.
record.
float
NOT NULL
TimeZone
The time zone of the ICM Central Controller used for
DateTime.
DateTime.
int
NULL
Value1
A value dependent upon the event and interface that
provides additional reporting information. This might
contain a network-provided releaseCause (for
DISCONNECT), failureCause
(ROUTE_SELECT_FAILURE), etc.
provides additional reporting information. This might
contain a network-provided releaseCause (for
DISCONNECT), failureCause
(ROUTE_SELECT_FAILURE), etc.
int
NULL
Value2
Reserved for future use.
varchar(128)
NULL
Table 2-107 Network_Event_Detail Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option
Table 2-108 Network_Target Table
Field Name
Description
Data Type
Keys and Null
Option
Option
NetworkTargetID
Unique identifier for this target.
int
PK, NOT NULL
NetworkTargetType
Type of target:
1 = Announcement
2 = Peripheral target
3 = Device target
4 = Scheduled target
2 = Peripheral target
3 = Device target
4 = Scheduled target
smallint
NOT NULL