Cisco Cisco Administrative Workstation Technical References
2-242
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Physical_Controller_Half_Hour Table
Physical_Controller_Half_Hour Table
Each row provides statistics for a single Network Interface Controller (NIC) or Peripheral Gateway
(PG).
(PG).
The ICM software automatically generates Physical_Interface_Controller records.
Related tables:
(via PhysicalControllerID)
Table 2-254 Physical_Controller_Half_Hour Table Constraints
Constraint
Field Name(s)
PK
DateTime
PhysicalControllerID
TimeZone
PhysicalControllerID
TimeZone
AK-1
RecoveryKey
FK
PhysicalControllerID
IE-1
DbDateTime
Table 2-255 Physical_Controller_Half_Hour Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
ActivePGAgentSideATimeToHalf
Number of seconds the Peripheral Gateway’s
Agent process maintained an active connection to
the Side A CallRouter.
Agent process maintained an active connection to
the Side A CallRouter.
DBINT
NULL
ActivePGAgentSideBTimeToHalf
Number of seconds the Peripheral Gateway’s
Agent process maintained an active connection to
the Side B CallRouter.
Agent process maintained an active connection to
the Side B CallRouter.
DBINT
NULL
DateTime
Central Controller date and time at the start of the
half- hour interval.
half- hour interval.
DBSMALLDATE
PK
NOT 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.
are written to the HDS database. The logger
database has NULL for this column.
DBDATETIME
IE-1
NULL
DMPInServiceTimeToHalf
Number of seconds the Peripheral Gateway’s
Device Management Protocol connection to the
CallRouter was in service.
Device Management Protocol connection to the
CallRouter was in service.
DBINT
NULL
PhysicalControllerID
Unique identifier for this physical controller.
DBSMALLINT
PK, FK
NOT NULL
RecoveryKey
A unique ID assigned to each record and used
internally by the ICM/IPCC Enterprise software to
track the record.
internally by the ICM/IPCC Enterprise software to
track the record.
DBFLT8
AK-1
NOT NULL
TimeZone
The time zone for the date and time. The value is
the offset in minutes from GMT.
the offset in minutes from GMT.
DBINT
PK
NOT NULL