Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco Unified Contact Center Enterprise 9.0(2)
  5. Technical References

Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References

Download
Page of 548
   
2-241
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
  
Chapter 2      Table Details
Person Table
Person Table
Provides primary identification and authentication for all system users, including both agents and 
administrators.
Related tables:
 (via PersonID)
Table 2-252 Person Table Constraints
Constraint
Field Name(s)
PK
PersonID
AK-1
LastName
AK-2
LoginNameShadow
IE-1
FirstName
LastName
Table 2-253 Person Table
Field Name
Description
Data Type
Keys and 
Null Option
ChangeStamp
Incremented when the record is changed in the 
central database.
CHANGESTAMP
NOT NULL
Deleted
Deleted Flag. Stored as a character:
Y = Yes
N = No
DBCHAR
NOT NULL
Description
Additional information about this person.
DESCRIPTION
NULL
FirstName
The person’s first name.
VNAME32
NOT NULL
LastName
The person’s last name.
VNAME32
AK-1, IE-1
NOT NULL
LoginEnabled
Specifies whether login is allowed for this person: 
Y: yes, N: no.
DBCHAR
NOT NULL
LoginName
The person’s login or user name.
VNAME32
NOT NULL
LoginNameShadow
A duplicate checkpoint for name.
VNAME32
AK-2
NOT NULL
Password
An optional encrypted password.
VNAME32
NULL
PersonID
A unique identifier.
DBINT
PK
NOT NULL