Cisco Cisco IPCC Web Option Technical References
2-66
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Call_Type Table
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-58 Call_Type Table Constraints
Constraint
Field Name(s)
PK
CallTypeID
AK-1
EnterpriseName
FK
BucketIntervalID
IE-1
CustomerDefinitionID
Table 2-59 Call_Type Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
BucketIntervalID
The ID for the entry in the Bucket_Interval Table
used for this CallType. The default value is
NULL.
used for this CallType. The default value is
NULL.
NULL means that the bucket interval from
ICR_Globals will be used for this calltype
ICR_Globals will be used for this calltype
DBINT
FK
NULL
CallTypeID
A unique identifier for this call type.
DBINT
PK
NOT NULL
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
CHANGESTAMP
NOT NULL
CustomerDefinitionID
Identifies the customer definition, if any,
associated with the call type.
associated with the call type.
DBINT
IE-1
NULL
Deleted
Deleted Flag. Stored as a character:
Y = Yes
N = No
N = No
DBCHAR
NOT NULL
Description
Additional information about the call type.
DESCRIPTION
NULL
EnterpriseName
An enterprise name for this call type. This name
must be unique among all call types in the
enterprise.
must be unique among all call types in the
enterprise.
VNAME32
AK-1
NOT NULL