Cisco Cisco IP Contact Center Release 4.6.2 Technical References

2-136

Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)

Chapter 2 Table Details

Dialer_Port_Real_Time Table

Local database only.

Contains the real time status of every telephony port for each Outbound Option Dialer.

Table 2-123 Dialer_Port_Real_Time Table Constraints

Constraint

Field Name(s)

DialerID
PortNumber

CampaignID
DialerID
QueryRuleID

Table 2-124 Dialer_Port_Real_Time Table

Field Name

Description

Data Type

Keys and Null
Option

AccountNumber

If the port is dialing, this value is the account number (if
available) of the contact being dialed.

VNAME32

NULL

CampaignID

If the port is dialing, this value indicates the campaign
from which the contact being dialed was retrieved.

This field is applicable to Outbound Option only.

DBINT

NULL

DateTime

The Central Controller date and time at which each row
was saved.

DBDATETIME

NOT NULL

DialerID

The dialer to which these statistics refer.

DBINT

PK, FK

NOT NULL

PhoneNumber

If the port is dialing, this value is the phone number being
dialed.

varchar(32)

NULL

PortNumber

The dialer port (line) number within the current dialer.

DBINT

NOT NULL

PortStatus

The current line status (for example, dialing, on-hook,
off-hook).
The following values are possible for this field:
290 = port allocated for future dial

300 = port released
310 = reservation call started
320 = agent reserved
330 = customer call started
340 = customer has been contacted
350 = call transferred too agent
360 = customer conversation complete
370 = agent completed with call

DBINT

NOT NULL

QueryRuleID

If the port is dialing, this value identifies the query rule
from which the contact being dialed was retrieved.

DBINT

NULL