Technical References

Keys and Null
Option:
Data Type:Description:Field Name:
NULLDBDATETIME
The Central Controller date/time when the record was imported.
ImportRuleDateTime
NULLDBINT
These fields should not be used.
InternalUse1 - InternalUse11
NULLVARCHAR(50)
Last name of the contact
LastName
NULLDBINT
An identifier for the call that is provided by Call Manager and is
unique to the Call Manager cluster.
PeripheralCallKey
NULLDBINT
Peripheral ID for the peripheral that the Agent is associated with.
PeripheralID
NULLVARCHAR(20)
Phone number that was called.
Phone
NULLVARCHAR(8)
Phone extension that was imported.
PhoneExt
NULLDBINT
The identifier of the phone that was dialed. This can be any of
phones 1 through 10.
PhoneID
NULLDBINT
Phone index in the campaign target sequence
Phone Index
NULLDBINT
Reserved for future use
PortNumber
NULLDBINT
The query rule that the call was placed for.
QueryRuleID
Clustered Index, Not
Null
DBFLT8
A unique ID assigned to each record and used internally by the
ICM/IPCC Enterprise software to track the record.
RecoveryKey
NULLDBINT
Skill Group ID of the agent who handled the call.
SkillGroupSkillTargetID
NULLDBINT
The value is the offset in minutes that the Campaign Manager is
from Central Controller time.
TimeZone
NULLDBSMALLINT
The zone that was active at the time that the attempt was made.
This can be 0 or 1.
ZoneIndex
Dialer_Half_Hour Table
This table is in the Blended Agent category (page 439). To see database rules for these tables,
click here (page 503).
Central database only.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
166
Chapter 2: All Tables
Dialer_Half_Hour Table