Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Fields in User_Formula_Equation Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NULL
varchar(255)
The expression string.
EquationString
PK NOT NULL
DBINT
Specifies the order of strings for a formula. A formula may
have one or more strings.
have one or more strings.
RowOrder
PK, FK NOT NULL
DBINT
Foreign key from the User_Formula table.
UserFormulaID
User_Group Table
. To see database rules for these tables, click
Lists the groups of users to which specific access rights apply. A record in this table can represent
a group of users (with multiple associated records in the User_Group_Member table) or a single
user (with a single associated record in the User_Group_Member table).
a group of users (with multiple associated records in the User_Group_Member table) or a single
user (with a single associated record in the User_Group_Member table).
Use Configuration Manager to create, update, and delete user groups.
Related tables
FeatureSetID)
CustomerDefinitionID)
UserGroupName)
(via
UserGroupID)
(via
UserGroupName)
(via
UserGroupID)
UserGroupID)
(via
UserGroupName)
Table 210: Indexes for User_Group Table
index_keys
index_description
index_name
UserGroupName
clustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1User_Group
CustomerDefinitionID
nonclustered located on PRIMARY
XIE1User_Group
UserGroupID
nonclustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKUser_Group
Fields in User_Group Table:
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the
central database.
central database.
ChangeStamp
FK, IE-1 NULL
DBINT
Identifies the customer associated with the user
group.
group.
CustomerDefinitionID
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
362
Chapter 2: - All Tables
User_Group Table