Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-42
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Call_Type_Half_Hour Table
Related tables:
Call Type Half Hour (via CallTypeID)
Call Type Map (via CallTypeID)
Call Type Real Time (via CallTypeID)
Customer Definition (via CustomerDefinitionID)
Default Call Type (via CallTypeID)
Dialed Number Map (via CallTypeID)
ICR Globals (Call_Type.CallTypeID maps to ICR_Globals.DefaultCallType)
Route Call Detail (via CallTypeID)
Call_Type_Half_Hour Table
Central database only.
Provides half- hour statistics for each call type defined in the ICM software. The ICM software generates
Call_Type_Half_Hour records for each call type.
Call_Type_Half_Hour records for each call type.
Deleted
Deleted Flag. Stored as a character:
Y = Yes
N = No
N = No
char(1)
NOT NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL
Table 2-28 Call_Type Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option
Table 2-29 Call_Type_Half_Hour Table
Field Name
Description
Data Type
Keys and Null
Option
Option
DateTime
The date and time when the row was
generated.
generated.
Datetime
PK, NOT NULL
CallTypeID
Identifies the call type.
int
PK, FK, NOT
NULL
NULL
TimeZone
The time zone for the date and time. The
value is the offset in minutes from GMT.
value is the offset in minutes from GMT.
int
PK, NOT NULL
RecoveryKey
A value used internally by the ICM software
to track virtual time.
to track virtual time.
float
NOT NULL