/mcpTable 63: Fields in Attribute Table Keys and NULL Option Data Type Description Name NOT NULL DBINT Data type for this attribute. Valid values are: • 0 = Unknown • 1 = Integer • 2 = String • 3 = Boolean • 4 = Skill (special form of integer) AttributeDataType PK1 NOT NULL DBINT ID and primary key. AttributeID NOT NULL DBCHAR Y or N. Default is N. If Y, this attribute appears on the agent desktop. This flag is only advisory for the desktop software. AppearsOnDesktop NOT NULL CHANGESTAMP Change stamp. ChangeStamp NULL DBDATETIME Records the date and time when a record is added / updated. DateTimeStamp NULL varchar255 Must be convertable to the datatype specified. DefaultValue NOT NULL DBCHAR Deleted Flag stored as a character. Valid values are: • Y = Yes • N = No Deleted NULL DBINT Foreign key from Department. NULL for global department. DepartmentID NULL DESCRIPTION Description of the attribute. Description NOT NULL VNMAE32 Name of this attribute. EnterpriseName NULL varchar255 Must be convertable to the datatype specified. MaximumValue NULL varchar255 Must be convertable to the datatype specified. MinimumValue NOT NULL DBCHAR Y or N (Default). If Y, the agent can set this attribute for the desktop. This flag is only advisory for the desktop software. SettableByAgent Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 97 All Tables Attribute