Cisco Cisco IPCC Web Option Technical References

Page of 404
 
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.
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).
Duration is measured in as the number of seconds between 
the NIC timestamps for ANSWER and 
DISCONNECT/ABANDON.
int
NULL
RecoveryDay
A value used internally by the ICM software to track 
virtual time.
int
NOT NULL
RecoveryKey
A value used internally by the ICM software to track the 
record.
float
NOT NULL
TimeZone
The time zone of the ICM Central Controller used for 
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.
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
Table 2-108 Network_Target Table
Field Name
Description
Data Type
Keys and Null 
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
smallint
NOT NULL