Technical References

Keys and Null Option:Data Type:Description:Field Name:
• N = No
Incremented when the record is changed in the central database.
NULLDESCRIPTION
Additional information about this person.
Description
NOT NULLVNAME32
The person’s first name.
FirstName
AK-1, IE-1 NOT NULLVNAME32
The person’s last name.
LastName
NOT NULLDBCHAR
Specifies whether login is allowed for this person: Y: yes, N: no.
LoginEnabled
NOT NULLVNAME32
The person’s login or user name.
LoginName
AK-2 NOT NULLVNAME32
A duplicate checkpoint for name.
LoginNameShadow
NULLvarchar
An optional encrypted password.
Password
PK NOT NULLDBINT
A unique identifier.
PersonID
Physical_Controller_Half_Hour Table
This table is in the Device category (page 441). To see database rules for these tables, click here
(page 504).
Each row provides statistics for a single Network Interface Controller (NIC) or Peripheral
Gateway (PG).
The ICM software automatically generates Physical_Interface_Controller records.
Related table
Physical Interface Controller (page 265) (via PhysicalControllerID)
Table 145: Indexes for Physical_Controller_Half_Hour Table
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAK1Physical_Controller_Half_H
DbDateTimenonclustered located on PRIMARYXIE1Physical_Controller_Half_H
DateTime, PhysicalControllerID, TimeZoneclustered, unique, primary key
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