Cisco Cisco IPCC Web Option Technical References
2-41
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Business_Entity Table
Business_Entity Table
Lists the business entities within the enterprise.
Related tables:
Enterprise Service (via EntityID)
Enterprise Skill Group (via EntityID)
Master Script (via Entity ID)
Schedule (via EntityID)
Call_Type Table
Each row describes a category of calls that the ICM software can handle. The Dialed Number Map table
determines which calls are assigned to each category; the Call Type Map table determines which scripts
are executed for each call type.
determines which calls are assigned to each category; the Call Type Map table determines which scripts
are executed for each call type.
Use the Call Type list tool to add, update, and delete Call_Type records. This tool can be launched
through the Configuration Manager.
through the Configuration Manager.
Table 2-27 Business_Entity Table
Field Name
Description
Data Type
Keys and Null
Option
Option
EntityID
A unique identifier for the business entity.
int
PK, NOT NULL
EntityName
The name of the business entity.
varchar(30)
AK1, NOT
NULL
NULL
Description
Additional information about the business entity.
varchar(255)
NOT NULL
ChangeStamp
Incremented when the record is changed in the central database. int
NOT NULL
Table 2-28 Call_Type Table
Field Name
Description
Data Type
Keys and Null
Option
Option
CallTypeID
A unique identifier for this call type.
int
PK, NOT NULL
CustomerDefinitionID
Identifies the customer definition, if any, associated with
the call type.
the call type.
int
NULL
EnterpriseName
An enterprise name for this call type. This name must be
unique among all call types in the enterprise.
unique among all call types in the enterprise.
varchar(32)
AK1, NOT
NULL
NULL
Description
Additional information about the call type.
varchar(255)
NULL
ServiceLevelThreshold
The time in seconds to be used as the service level
threshold.
threshold.
smallint
NULL
ServiceLevelType
Default value that indicates how the ICM software
calculates the service level (that is, how it handles
abandoned calls in calculating the service level). You can
override this default for individual services.
calculates the service level (that is, how it handles
abandoned calls in calculating the service level). You can
override this default for individual services.
smallint
NULL