Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Keys and Null
Option:

Data Type:

Description:

Field Name:

AK-1 NOT
NULL

DBFLT8

A unique ID assigned to each record and
used internally by the ICM/IPCC Enterprise
software to track the record.

RecoveryKey

PK NOT NULL

DBINT

The time zone for the date and time. The
value is the offset in minutes from GMT.

TimeZone

Physical_Interface_Controller Table

This table is in the

Device category (page 375)

. To see database rules for these tables, click

here

(page 442)

Describes a single Network Interface Controller (NIC) or Peripheral Gateway (PG). A duplexed
NIC has two entries in the Physical Interface Controller table and a single entry in the Logical
Interface Controller table. A pair of duplexed PGs share a single entry in the Physical Interface
Controller table.

Use the PG or NIC Explorer tools to add, update, and delete Physical_Interface_Controller
records.

(via LogicalControllerID)

Routing Client Five Minute (page 256)

(via PhysicalControllerID)

Physical Controller Half Hour (page 223)

(via PhysicalControllerID)

Table 145: Indexes for Physical_Interface_Controller Table

index_keys

index_description

index_name

EnterpriseName

nonclustered, unique, unique key
located on PRIMARY

XAK1Physical_Interface_Control

LogicalControllerID

nonclustered located on PRIMARY

XIE1Physical_Interface_Control

PhysicalControllerID

clustered, 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 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

Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)

224

Chapter 2: - All Tables

Physical_Interface_Controller Table