Cisco Cisco Unified Contact Center Enterprise 9.0(1) Referências técnicas
Table 213: Indexes for User_Security_Control Table
index_keys
index_description
index_name
UserName
nonclustered located on PRIMARY
XIE1User_Security_Control
UserGroupID
nonclustered located on PRIMARY
XIE2User_Security_Control
ObjectType, ObjectID, UserName
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKUser_Security_Control
Fields in User_Security_Control Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
DBINT
The level of access that the user has for the object. To see values. click
.
AccessLevel
PK NOT NULL
DBINT
Together with ObjectType, identifies the object.
ObjectID
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
. 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 214: 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.
AgentSkillTargetID
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
430
Chapter 2: All Tables
User_Supervisor_Map Table