Technical References

Physical Controller Half Hour (page 264) (via PhysicalControllerID)
Table 146: Indexes for Physical_Interface_Controller Table
index_keysindex_descriptionindex_name
EnterpriseNamenonclustered, unique, unique key
located on PRIMARY
XAK1Physical_Interface_Control
LogicalControllerIDnonclustered located on PRIMARYXIE1Physical_Interface_Control
PhysicalControllerIDclustered, unique, primary key
located on PRIMARY
XPKPhysical_Interface_Controll
Fields in Physical_Interface_Controller Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NOT NULLDBCHAR
Deleted Flag. Stored as a character:
Deleted
• Y = Yes
• N = No
NULLDESCRIPTION
Additional information about the controller.
Description
AK-1 NOT NULLVNAME32
An enterprise name for the controller. This name must be unique
for all physical controllers in the enterprise.
EnterpriseName
FK, IE-1 NOT NULLDBSMALLINT
Foreign key from Logical Interface Controller table.
LogicalControllerID
PK NOT NULL NULLDBSMALLINT
Unique identifier for this physical controller.
PhysicalControllerID
Query_Rule Table
This table is in the Blended Agent category (page 439). To see database rules for these tables,
click here (page 503).
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.
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.
Related tables
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
266
Chapter 2: All Tables
Query_Rule Table