Technical References

The combination of FirstName and LastName is an inversion key for the Agent table. While
this key value is not necessarily unique, it is a convenient way to locate specific agents. This
table lists the types of keys and the codes used for them in the ICM database.
DescriptionCodeKey Type
Consists of one or more fields that have a unique value for each record in
the table.
PKPrimary key
A unique key that can be used instead of the primary key to locate a specific
record.
AKAlternate key
A primary key from one table that appears in a second table. A foreign key
that establishes a one-to-one relationship is always unique. A foreign key
that establishes a one-to-many relationship is not unique.
FKForeign key
A key that does not necessarily have a unique value, but can be used to locate
a group of records within the table.
IEInversion key
In the section All Tables (page 13), the codes from this table are used to identify key fields in
each table. If a table has more than one key of the same type, then numbers are attached to the
codes. For example, if a table has two alternate keys, then the fields that participate in the first
are marked AK1 and the fields that participate in the second are marked AK2.
Each field is also marked as either NULL (meaning the NULL value is valid for the field) or
NOT NULL (meaning the NULL value is not valid).
Reserved Fields
Some fields in the database are marked as reserved. This means that ICM software or the database
manager might use the field, but it has no external meaning. You must not modify any field
marked as reserved.
Field Applicability
Unless specifically indicated otherwise, table fields apply to both ICM and IPCC.
Data Types
This table describes the data types used for fields in the ICM/IPCC database.
DescriptionNull Option
Default
MS SQL Server
Data Type
ICM/IPCC Defined
Data Type
Consists of one or more fields that have a unique value
for each record in the table.
NOT NULLintCHANGESTAMP
Up to 1 character. The value 1 is the storage size.NOT NULLchar(1)DBCHAR
A date and time accurate to the second. Stored as two
four-byte integers (eight bytes total): days before or
since January 1, 1900 and seconds since midnight.
datetimedatetimeDBDATETIME
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
10
Chapter 1: Introduction
General Concepts