Technical References

Keys and Null
Option:
Data Type:Description:Field Name:
NULLDBINT
Telephony call result (busy, no answer, etc.) or agent reservation
attempt result (Agent Rejected Call, Unable to reserve, etc.). Click
here to see the eld values that can populate CallResult (page 471).
CallResult
NULLDBINT
Reserved for future use
CallResultDetail
NULLCHAR(1)
Current status of the customer record for Zone1.
CallStatusZone1
Click here to see the values that can populate this eld. (page 473)
NULLCHAR(1)
Current status of the customer record for Zone2.
CallStatusZone2
Click here to see the values that can populate this eld. (page 473)
NULLDBINT
The campaign that the call was placed for.
CampaignID
NULLDBINT
The value is the offset in minutes that the customer is from UTC
(formerly GMT).
CustomerTimeZone
NOT NULLDBDATETIME
The UTC date and time at the start of the interval when the row
was generated.
DateTime
NULL, IndexDBDATETIME
The current date and time stamp when the records are written to
the HDS database. The logger database has NULL for this column.
DbDateTime
NULLDBINT
DialerID of the dialer where the outbound call was initiated.
DialerID
NULLDBINT
Unique identier from the dialing list
(DL_<CampaignID>_<QueryRuleID>) table in the outbound
database.
DialingListID
If the attempt is a Personal Callback, then this unique identier
refers to the PersonalCallbackListID eld in the
Personal_Callback_List table in the outbound database.
NULLDBINT
Campaign mode the call was called.
DialingMode
Click here to see the eld values. (page 474)
NULLVARCHAR(50)
First name of the contact
FirstName
NULLDBINT
Reserved for future use
FutureUseInt1 -
FutureUseInt8
NULLVARCHAR(64)
Reserved for future use
FutureUseVarChar1-4
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
165
Chapter 2: All Tables
Dialer_Detail Table