Technical References

Dialed Number Map (page 158) (via
CallTypeID)
Default Call Type (page 154) (via
CallTypeID)
Customer Definition (page 153) (via
CustomerDefinitionID)
Termination Call Detail (page 407) (via
CallTypeID)
Route Call Detail (page 278) (via
CallTypeID)
ICR Globals (page 209)
(Call_Type.CallTypeID maps to
ICR_Globals.DefaultCallType)
Table 47: Indexes for Call_Type Table
index_keysindex_descriptionindex_name
EnterpriseNamenonclustered, unique, unique key
located on PRIMARY
XAK1Call_Type
CustomerDefinitionIDnonclustered located on PRIMARYXIE1Call_Type
CallTypeIDclustered, unique, primary key
located on PRIMARY
XPKCall_Type
Fields in Call_Type Table :
Keys and Null
Option:
Data Type:Description:Field Name:
FK NULLDBINT
The ID for the entry in the Bucket_Interval Table used for this
CallType. The default value is NULL.
BucketIntervalID
NULL means that the bucket interval from ICR_Globals will be
used for this calltype.
PK NOT NULLDBINT
A unique identifier for this call type.
CallTypeID
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
IE-1 NULLDBINT
Identifies the customer definition, if any, associated with the call
type.
CustomerDefinitionID
NOT NULLDBCHAR
Deleted Flag. Stored as a character:
Deleted
• Y = Yes
• N = No
NULLDESCRIPTION
Additional information about the call type.
Description
AK-1 NOT NULLVNAME32
An enterprise name for this call type. This name must be unique
among all call types in the enterprise.
EnterpriseName
NULLDBINT
The time in seconds to be used as the service level threshold.
ServiceLevelThreshold
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
75
Chapter 2: All Tables
Call_Type Table