Technical References

Fields in Physical_Controller_Half_Hour Table:
Keys and Null
Option:
Data Type:Description:Field Name:
NULLDBINT
Number of seconds the Peripheral Gateway’ s Agent process
maintained an active connection to the Side A CallRouter.
ActivePGAgentSideATimeToHalf
NULLDBINT
Number of seconds the Peripheral Gateway’ s Agent process
maintained an active connection to the Side B CallRouter.
ActivePGAgentSideBTimeToHalf
PK NOT NULLDBSMALLDATE
Central Controller date and time at the start of the half- hour
interval.
DateTime
IE-1 NULLDBDATETIME
The current date and time stamp when the records are written
to the HDS database. The logger database has NULL for
this column.
DbDateTime
NULLDBINT
Number of seconds the Peripheral Gateway’s Device
Management Protocol connection to the CallRouter was in
service.
DMPInServiceTimeToHalf
PK, FK NOT NULLDBSMALLINT
Unique identifier for this physical controller.
PhysicalControllerID
AK-1 NOT NULLDBFLT8
A unique ID assigned to each record and used internally by
the ICM/IPCC Enterprise software to track the record.
RecoveryKey
PK NOT NULLDBINT
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 441). To see database rules for these tables, click here
(page 504).
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
Logical Interface Controller (page 230) (via LogicalControllerID)
Routing Client Five Minute (page 299) (via PhysicalControllerID)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
265
Chapter 2: All Tables
Physical_Interface_Controller Table