Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 620
Fields in Physical_Controller_Half_Hour Table:
Keys and Null
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.
ActivePGAgentSideATimeToHalf
NULL
DBINT
Number of seconds the Peripheral 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.
DateTime
IE-1 NULL
DBDATETIME
The current date and time stamp when the records are written
to the HDS database. The logger database has NULL for
this column.
DbDateTime
NULL
DBINT
Number of seconds the Peripheral Gateway’s Device
Management Protocol connection to the CallRouter was in
service.
DMPInServiceTimeToHalf
PK, FK NOT NULL
DBSMALLINT
Unique identifier for this physical controller.
PhysicalControllerID
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
To see database rules for these tables, click 
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.
Related tables
 (via PhysicalControllerID)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
265
Chapter 2:  All Tables
Physical_Interface_Controller Table