Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References
(via PhysicalControllerID)
Table 146: Indexes for Physical_Interface_Controller Table
index_keys
index_description
index_name
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Physical_Interface_Control
LogicalControllerID
nonclustered located on PRIMARY
XIE1Physical_Interface_Control
PhysicalControllerID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKPhysical_Interface_Controll
Fields in Physical_Interface_Controller Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NOT NULL
DBCHAR
Deleted Flag. Stored as a character:
Deleted
• Y = Yes
• N = No
NULL
DESCRIPTION
Additional information about the controller.
Description
AK-1 NOT NULL
VNAME32
An enterprise name for the controller. This name must be unique
for all physical controllers in the enterprise.
for all physical controllers in the enterprise.
EnterpriseName
FK, IE-1 NOT NULL
DBSMALLINT
Foreign key from Logical Interface Controller table.
LogicalControllerID
PK NOT NULL NULL
DBSMALLINT
Unique identifier for this physical controller.
PhysicalControllerID
Query_Rule Table
. To see database rules for these tables,
click
Specifies the association between a query rule clause and an import rule. A query rule works
on a particular import rule to select a group of contacts from an overall import list. For example,
from a particular import list you might want to select and call all customers that have account
numbers greater than 10,000.
on a particular import rule to select a group of contacts from an overall import list. For example,
from a particular import list you might want to select and call all customers that have account
numbers greater than 10,000.
Note: If Outbound Option was not selected during setup, this table will contain no data.
Use the Outbound Option Configuration option within ICM Configuration Manager to modify
Query_Rule records.
Query_Rule records.
Related tables
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
266
Chapter 2: All Tables
Query_Rule Table