Technical References

User_Formula Table
This table is part of the Script category (page 451). For database rules, click here. (page 509)
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
User Formula Equation (page 426) (via UserFormulaID)
Table 209: Indexes for User_Formula Table
index_keysindex_descriptionindex_name
EnterpriseNameclustered, unique, unique key
located on PRIMARY
XAK1User_Formula
UserFormulaIDnonclustered, unique, primary key
located on PRIMARY
XPKUser_Formula
Fields in User_Formula Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULLDESCRIPTION
Additional information about the function.
Description
AK-1 NOT NULLVNAME32
An enterprise name for the function. Custom function names always
begin with "user".
EnterpriseName
NOT NULLDBINT
The number of bytes in the expression for the function.
Length
NOT NULLDBINT
The number of parameters the function accepts.
ParamCount
PK NOT NULLDBINT
A unique identifier for the function.
UserFormulaID
User_Formula_Equation Table
This table is part of the Script category (page 451). For database rules, click here. (page 509)
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.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
426
Chapter 2: All Tables
User_Formula Table