/mcpTable 274: Fields in Person Table Keys and NULL Option Data Type Description Name NOT NULL CHANGESTAMP Incremented when the record is changed in the central database. ChangeStamp NULL DBDATETIME Records the date and time when a record is added/updated. DateTimeStamp NOT NULL DBCHAR Deleted Flag. Stored as a character: • Y = Yes • N = No Incremented when the record is changed in the central database. Deleted NULL DBINT Foreign key from Department. NULL for global department. DepartmentID NULL DESCRIPTION Additional information about this person. Description NOT NULL DBSMALLINT Indicates whether an agent is enabled for digital channel interaction. The values are: • 0 = NO • 1 = YES DigitalChannelEnabled NOT NULL DBSMALLINT Reserved for future use. PasswordChangeRequired 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. LoginEnabled NOT NULL VARCHAR(255) The person's login or user name. In a Packaged CCE deployment, the FirstName, LastName, and LoginName appear as the value in the Agent Report Value List. LoginName AK-2 NOT NULL VARCHAR(255) A login name in uppercase or lowercase, as indicated in ICR Globals. LoginNameShadow NULL varchar An optional encrypted password. Password Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 324 All Tables Person