Technical References

Fields in Persistent_Variable Table:
Keys and Null Option:Data Type:Description:Field Name:
PK NOT NULLDBINT
If the variable is associated with an object type, the key value of the
specific object.
ForeignKey1
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, FK NOT NULLDBINT
Foreign key from the User_Variable table.
UserVariableID
NULLDESCRIPTION
The value of the variable, if it is a character string.
ValueChar
NULLDBDATETIME
The value of the variable, if it is a date-time.
ValueDateTime
NULLDBFLT8
The value of the variable, if it is a floating point number.
ValueFloat
NULLDBINT
The value of the variable, if it is an integer..
ValueInt
Person Table
This table is in the Skill Target category (page 456). To see database rules for these tables, click
here (page 510).
Provides primary identification and authentication for all system users, including both agents
and administrators.
Related table
Agent (page 15) (via PersonID)
Table 144: Indexes for Person Table
index_keysindex_descriptionindex_name
LoginNameShadownonclustered, unique, unique key
located on PRIMARY
XAK2Person
FirstName, LastNamenonclustered located on PRIMARYXIE1Person
PersonIDclustered, unique, primary key
located on PRIMARY
XPKPerson
Fields in Person Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NOT NULLDBCHAR
Deleted Flag. Stored as a character:
Deleted
• Y = Yes
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
263
Chapter 2: All Tables
Person Table