Cisco Cisco IPCC Web Option Technical References
Keys and Null Option:
Data Type:
Description:
Field Name:
• N = No
Incremented when the record is changed in the central database.
NULL
DESCRIPTION
Additional information about this person.
Description
NOT NULL
VNAME32
The person’s first name.
FirstName
AK-1, IE-1 NOT NULL
VNAME32
The person’s last name.
LastName
NOT NULL
DBCHAR
Specifies whether login is allowed for this person: Y: yes, N: no.
LoginEnabled
NOT NULL
VNAME32
The person’s login or user name.
LoginName
AK-2 NOT NULL
VNAME32
A duplicate checkpoint for name.
LoginNameShadow
NULL
varchar
An optional encrypted password.
Password
PK NOT NULL
DBINT
A unique identifier.
PersonID
Physical_Controller_Half_Hour Table
. To see database rules for these tables, click
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 145: 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
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
264
Chapter 2: All Tables
Physical_Controller_Half_Hour Table