Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-148
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Physical_Controller_Half_Hour Table
Related tables:
Agent (via PersonID)
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.
LastName
The person’s last name.
varchar(32)
AK1, NOT
NULL
NULL
LoginName
The person’s login or user name.
varchar(32)
NOT NULL
LoginNameShadow
A duplicate checkpoint for name.
varchar(32)
AK1
NOT NULL
NOT NULL
Password
An optional encrypted password.
varchar(32)
NULL
LoginEnabled
Specifies whether login is allowed for this person: Y:
yes, N: no.
yes, N: no.
char(1)
NOT NULL
Description
Additional information about this person.
varchar(255)
NULL
Deleted
Deleted Flag. Stored as a character:
Y = Yes
N = No
N = No
char(1)
NOT NULL
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
int
NOT NULL
Table 2-125 Person Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option
Table 2-126 Physical_Controller_Half_Hour Table
Field Name
Description
Data Type
Keys and Null
Option
Option
DateTime
Central Controller date and time at the start
of the half- hour interval.
of the half- hour interval.
smalldatetime
PK, NOT NULL
PhysicalControllerID
Unique identifier for this physical controller. smallint
PK, FK, NOT
NULL
NULL
TimeZone
The time zone for the date and time. The
value is the offset in minutes from GMT.
value is the offset in minutes from GMT.
int
PK, NOT NULL
RecoveryKey
A value used internally by the ICM software
to track virtual time.
to track virtual time.
float
AK1, NOT
NULL
NULL
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.
int
NULL