Cisco Cisco IP Contact Center Release 4.6.2 Technical References

Each row contains all or part of the expression associated with a custom formula.

Use the Script Editor to add, modify, and delete custom formulas.

User_Formula Table (via UserFormulaID)

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).

Use Configuration Manager to create, update, and delete user groups.

UserFormulaID

Foreign key from the User_Formula table.

int

PK, FK, NOT 
NULL

RowOrder

Specifies the order of strings for a formula. A formula 
may have one or more strings.

int

PK, NOT NULL

EquationString

The expression string.

varchar(255)

NULL

UserGroupID

A unique identifier for the group.

int

PK, NOT NULL

CustomerDefinitionID

Identifies the customer associated with the user group.

int

IE1, FK, NULL

UserGroupName

The name of the group.

varchar(30)

AK1, NOT 
NULL

UserGroupType

The type of the group: 

U = for an individual user.
G = for a group of users.

char(1)

NOT NULL

Description

Additional information about the group.

varchar(255)

NOT NULL

ServiceProvider

Valid options include:

Y = Service provider or normal customer.
N = Service bureau customer.

char(1)

NOT NULL

ReadOnly

Valid options include:

Y = Read-only user.
N = Normal user.

char(1)

NOT NULL