Technical References

Keys and Null
Option:
Data Type:Description:Field Name:
AK-1 NOT NULLDBFLT8
A value used internally by the ICM software to track virtual
time.
RecoveryKey
NULLDBINT
The number of calls made during the half-hour interval in
which SIT tones were detected.
SITToneDetectToHalf
PK NOT NULLDBINT
The time zone for the date and time. The value is the offset in
minutes from UTC (formerly called GMT).
TimeZone
NULLDBINT
The number of calls made during the half-hour interval in
which a voice was detected.
VoiceDetectToHalf
NULLDBINT
The number of calls where the customer phone number was
incorrect (the customer did not live there).
WrongNumberCountToHalf
Dialer_Port_Map Table
This table is in the Blended Agent category (page 439). To see database rules for these tables,
click here (page 503).
Note: If Outbound Option was not selected during setup, this table will contain no data.
Maps port numbers on the dialer to the ports on the ACD, and identifies the ACD stations and
their mapping to dialer ports. Use the Blended Agent Configuration option within ICM
Configuration Manager to modify Dialer_Port_Map records. The Primary Key (PK) is
nonclustered.
Related table
Dialer (page 161) (via DialerID)
Table 80: Indexes for Dialer_Port_Map Table
index_keysindex_descriptionindex_name
DialerID, PortNumberclustered, unique, primary key
located on PRIMARY
XPKPort_Map
Fields in Dialer_Port_Map Table:
Keys and Null Option:Data Type:Description:Field Name:
PK, FK NOT NULLDBINT
The dialer to which these statistics refer.
DialerID
NULLDBINT
Reserved for future use
FutureUseInt1
NULLDBINT
Reserved for future use
FutureUseInt2
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
169
Chapter 2: All Tables
Dialer_Port_Map Table