Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References
2-285
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
User_Formula Table
Related tables:
Trunk Group (via TrunkGroupID)
User_Formula Table
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.
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 tables:
User Formula Equation (via UserFormulaID)
InUseOutboundTimeHalf
Aggregate number of seconds trunks in the group have
been in use for outbound calls during the current
half-hour interval.
been in use for outbound calls during the current
half-hour interval.
int
NULL
InUseOutboundTimeToday
Aggregate number of seconds trunks in the group have
been in use for outbound calls since midnight.
been in use for outbound calls since midnight.
int
NULL
TrunksIdle
Number of non-busy trunks in the group now.
int
NULL
TrunksInService
Number of trunks in the trunk group in service now.
int
NULL
Table 2-187 Trunk_Group_Real_Time Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option
Table 2-188 User_Formula Table
Field Name
Description
Data Type
Keys and Null
Option
Option
UserFormulaID
A unique identifier for the function.
int
PK, NOT NULL
EnterpriseName
An enterprise name for the function. Custom function
names always begin with "user".
names always begin with "user".
varchar(32)
AK1, NOT
NULL
NULL
ParamCount
The number of parameters the function accepts.
int
NOT NULL
Description
Additional information about the function.
varchar(255)
NULL
Length
The number of bytes in the expression for the function. int
NOT NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL