Cisco Cisco IP Contact Center Release 4.6.1 Technical References

NULL

DBDATETIME

The Central Controller date/time when the record was imported.

ImportRuleDateTime

NULL

DBINT

These fields should not be used.

InternalUse1 - InternalUse11

NULL

VARCHAR(50)

Last name of the contact

LastName

NULL

DBINT

An identifier for the call that is provided by Call Manager and is
unique to the Call Manager cluster.

PeripheralCallKey

NULL

DBINT

Peripheral ID for the peripheral that the Agent is associated with.

PeripheralID

NULL

VARCHAR(20)

Phone number that was called.

Phone

NULL

VARCHAR(8)

Phone extension that was imported.

PhoneExt

NULL

DBINT

The identifier of the phone that was dialed. This can be any of
phones 1 through 10.

PhoneID

NULL

DBINT

Phone index in the campaign target sequence

Phone Index

NULL

DBINT

Reserved for future use

PortNumber

NULL

DBINT

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

NULL

DBINT

Skill Group ID of the agent who handled the call.

SkillGroupSkillTargetID

NULL

DBINT

The value is the offset in minutes that the Campaign Manager is
from Central Controller time.

TimeZone

NULL

DBSMALLINT

The zone that was active at the time that the attempt was made.
This can be 0 or 1.

ZoneIndex

Dialer_Half_Hour Table

. To see database rules for these tables,

click 

Central database only.

Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)