/mcpKeys and NULL Option Data Type Description Name NULL DBINT Foreign key from Department. NULL for global department. DepartmentID NULL DESCRIPTION Additional information about the agent. Description IE-4 NOT NULL VNAME32 An enterprise name for the agent that is unique within the enterprise. You might form the name by combining the agent's first and last name with the name of the peripheral. In a Unified CCE deployment, this is the value that appears in the Cisco Unified Intelligence Center Agent Report Value List. For custom reporting, you may want to use the agent person LoginName (as is used for Packaged CCE), or agent last name/first name as a friendlier user representation. EnterpriseName AK-1, AK-2, FK NOT NULL DBSMALLINT Foreign key from the Peripheral table. PeripheralID NULL VNAME32 The name of the agent as known to the peripheral. PeripheralName AK-2 NOT NULL varchar(32) The agent's login ID assigned at the switch. PeripheralNumber AK-1, FK NOT NULL DBINT Foreign key from the Person table. PersonID FK, IE-3 NULL DBINT Identifies an imported schedule associated with the agent. ScheduleID PK, FK NOT NULL DBINT An identifier that is unique among all skill targets in the enterprise. SkillTargetID NOT NULL DBCHAR Indicates whether an agent is a supervisor. • Y = Yes, agent is a supervisor • N = No, agent is not a supervisor SupervisorAgent Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 19 All Tables Agent