Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco IPCC Web Option
  5. Technical References

Cisco Cisco IPCC Web Option Technical References

Download
Page of 404
 
2-73
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Dialer_Port_Map Table
Dialer_Port_Map Table
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.
Related tables:
Dialer (via DialerID)
Dialer_Port_Real_Time Table
Local database only.
Contains the current status of every telephone line for every dialer in Blended Agent.
Table 2-56 Dialer_Port_Map Table
Field Name
Description
Data Type
Keys and Null 
Option
DialerID
The dialer to which these statistics refer.
int
PK, FK, NOT 
NULL
PortNumber
Identifies the particular dialer port on this dialer that 
matches the ACD port.
int
PK, NOT NULL
Station
Identifies the ACD station and its mapping to a dialer port. varchar(32)
NULL
Table 2-57 Dialer_Port_Real_Time Table
Field Name
Description
Data Type
Keys and Null 
Option
DialerID
The dialer to which these statistics refer.
int
PK, FK, NOT 
NULL
PortNumber
The dialer port (line) number within the current dialer.
int
PK, NOT NULL
DateTime
The date and time at which each row was saved.
datetime
NOT NULL
PortStatus
The current line status (for example, dialing, on-hook, 
off-hook).
int
NOT NULL
PhoneNumber
If the port is dialing, this value is the phone number being 
dialed.
varchar(32)
NULL
AccountNumber
If the port is dialing, this value is the account number (if 
available) being dialed.
varchar(32)
NULL
CampaignID
If the port is dialing, this value indicates the campaign 
from which the contact being dialed was retrieved.
int
NULL
QueryRuleID
If the port is dialing, this value identifies the query rule 
from which the contact being dialed was retrieved.
int
NULL