Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 557
Each row describes a custom function. A custom function is a shorthand for an expression. It
may, optionally, accept parameters. The expression associated with the function is stored in the
User_Formula_Equation table.
Use the Script Editor to create, modify, and delete custom functions.
Related table
 (via UserFormulaID)
Table 208: Indexes for User_Formula Table
index_keys
index_description
index_name
EnterpriseName
clustered, unique, unique key
located on PRIMARY
XAK1User_Formula
UserFormulaID
nonclustered, unique, primary key
located on PRIMARY
XPKUser_Formula
Fields in User_Formula Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the
central database.
ChangeStamp
NULL
DESCRIPTION
Additional information about the function.
Description
AK-1 NOT NULL
VNAME32
An enterprise name for the function. Custom
function names always begin with "user".
EnterpriseName
NOT NULL
DBINT
The number of bytes in the expression for the
function.
Length
NOT NULL
DBINT
The number of parameters the function accepts.
ParamCount
PK NOT NULL
DBINT
A unique identifier for the function.
UserFormulaID
User_Formula_Equation Table
This table is part of the 
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.
Related table
 (via UserFormulaID)
Table 209: Indexes for User_Formula_Equation Table
index_keys
index_description
index_name
UserFormulaID, RowOrder
clustered, unique, primary key
located on PRIMARY
XPKUser_Formula_Equation
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
361
Chapter 2:  All Tables
User_Formula_Equation Table