Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Keys and Null Option:
Data Type:
Description:
Field Name:
PK, FK NOT NULL
DBINT
Together with ObjectID, identifies the object.
ObjectType
IE-2 NOT NULL
DBINT
Foreign key from the User_Group table.
UserGroupID
PK, IE-1 NOT NULL
varchar(64)
The SQL Server username of the user.
UserName
User_Supervisor_Map Table
This table is in the
. To see database rules for these tables, click
Used to allow an agent to log in as a Supervisor. When an agent logs in as a Supervisor, an entry
for the agent is created in the User Group table to allow the agent login.
for the agent is created in the User Group table to allow the agent login.
Related table
(via UserGroupID)
Table 213: Indexes for User_Supervisor_Map Table
index_keys
index_description
index_name
AgentSkillTargetID
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1UserSupervisorMap
UserGroupID, AgentSkillTargetID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKUserSupervisorMap
Fields in User_Supervisor_Map Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
PK, AK-1 NOT NULL
DBINT
The identifier for the SkillTargetID for an agent that
is a supervisor.
is a supervisor.
AgentSkillTargetID
PK, FK NOT NULL
DBINT
The identifier for the user.
UserGroupID
User_Variable Table
This table is part of the
Contains the definitions of user variables. You can optionally associate a variable with an object
type (such as service or skill group). The ICM software then creates an instance of the variable
for each object of that type (for example, for each service or each skill group). You can set and
reference variables within scripts. If a variable is persistent, its value is stored in the
Persistent_Variable table.
type (such as service or skill group). The ICM software then creates an instance of the variable
for each object of that type (for example, for each service or each skill group). You can set and
reference variables within scripts. If a variable is persistent, its value is stored in the
Persistent_Variable table.
Use the User Variable list tool to create, update, and delete definitions of user variables.
Related table
(via UserVariableID)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
365
Chapter 2: All Tables
User_Supervisor_Map Table