Technical References

User Group Member (page 429) (via UserName)
Table 213: Indexes for User_Security_Control Table
index_keysindex_descriptionindex_name
UserNamenonclustered located on PRIMARYXIE1User_Security_Control
UserGroupIDnonclustered located on PRIMARYXIE2User_Security_Control
ObjectType, ObjectID, UserNameclustered, unique, primary key
located on PRIMARY
XPKUser_Security_Control
Fields in User_Security_Control Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLDBINT
The level of access that the user has for the object. To see values. click
here (page 465).
AccessLevel
PK NOT NULLDBINT
Together with ObjectType, identifies the object.
ObjectID
PK, FK NOT NULLDBINT
Together with ObjectID, identifies the object.
ObjectType
IE-2 NOT NULLDBINT
Foreign key from the User_Group table.
UserGroupID
PK, IE-1 NOT NULLvarchar(64)
The SQL Server username of the user.
UserName
User_Supervisor_Map Table
This table is in the Security category (page 455). To see database rules for these tables, click
here (page 510).
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.
Related table
User Group (page 427) (via UserGroupID)
Table 214: Indexes for User_Supervisor_Map Table
index_keysindex_descriptionindex_name
AgentSkillTargetIDnonclustered, unique, unique key
located on PRIMARY
XAK1UserSupervisorMap
UserGroupID, AgentSkillTargetIDclustered, unique, primary key
located on PRIMARY
XPKUserSupervisorMap
Fields in User_Supervisor_Map Table:
Keys and Null Option:Data Type:Description:Field Name:
PK, AK-1 NOT NULLDBINT
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