Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Keys and Null Option:
Data Type:
Description:
Field Name:
NULL
DBFLT8
The value of the variable, if it is a floating point
number.
number.
ValueFloat
NULL
DBINT
The value of the variable, if it is an integer..
ValueInt
Person Table
This table is in the
. To see database rules for these tables, click
Provides primary identification and authentication for all system users, including both agents
and administrators.
and administrators.
Related table
Table 143: Indexes for Person Table
index_keys
index_description
index_name
LoginNameShadow
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK2Person
FirstName, LastName
nonclustered located on PRIMARY
XIE1Person
PersonID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKPerson
Fields in Person Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the
central database.
central database.
ChangeStamp
NOT NULL
DBCHAR
Incremented when the record is changed in the
central database.
central database.
Deleted
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.
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
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
222
Chapter 2: - All Tables
Person Table