Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Physical_Controller_Half_Hour Table
This table is in the
Each row provides statistics for a single Network Interface Controller (NIC) or Peripheral
Gateway (PG).
Gateway (PG).
The ICM software automatically generates Physical_Interface_Controller records.
Related table
(via PhysicalControllerID)
Table 144: Indexes for Physical_Controller_Half_Hour Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Physical_Controller_Half_H
DbDateTime
nonclustered located on PRIMARY
XIE1Physical_Controller_Half_H
DateTime, PhysicalControllerID, TimeZone
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKPhysical_Controller_Half_Ho
Fields in Physical_Controller_Half_Hour Table:
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
Number of seconds the Peripheral
Gateway’s Agent process maintained an
active connection to the Side A CallRouter.
Gateway’s Agent process maintained an
active connection to the Side A CallRouter.
ActivePGAgentSideATimeToHalf
NULL
DBINT
Number of seconds the Peripheral
Gateway’s Agent process maintained an
active connection to the Side B CallRouter.
Gateway’s Agent process maintained an
active connection to the Side B CallRouter.
ActivePGAgentSideBTimeToHalf
PK NOT NULL
DBSMALLDATE
Central Controller date and time at the start
of the half- hour interval.
of the half- hour interval.
DateTime
IE-1 NULL
DBDATETIME
The current date and time stamp when the
records are written to the HDS database.
records are written to the HDS database.
DbDateTime
The logger database has NULL for this
column.
column.
NULL
DBINT
Number of seconds the Peripheral
Gateway’s Device Management Protocol
connection to the CallRouter was in service.
Gateway’s Device Management Protocol
connection to the CallRouter was in service.
DMPInServiceTimeToHalf
PK, FK NOT
NULL
NULL
DBSMALLINT
Unique identifier for this physical controller.
PhysicalControllerID
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
223
Chapter 2: All Tables
Physical_Controller_Half_Hour Table