Cisco Cisco IPCC Web Option Technical References

NOT NULL

DBTINYINT

Gate number of the agent’s primary assignment.

PriGate

NOT NULL

DBSMALLINT

Total time, in seconds, the agent was connected as a primary
assignment to external calls, internal gate transfer calls,
overflow/diversion-in calls, or internal gate calls.

PriTalkTime

AK-1 NOT NULL

DBFLT8

A unique ID assigned to each record and used internally by the
ICM/IPCC Enterprise software to track the record.

RecoveryKey

NOT NULL

DBSMALLINT

Number of external calls, internal gate transfer calls, internal gate
calls, and overflow/diversion-in calls connected to the agent while
secondarily assigned to the gate.

SecCallsHandled

NOT NULL

DBSMALLINT

Total time, in seconds, the agent spent in wrap-up after secondary
assignment external, internal gate transfer, overflow/diversion-in,
and internal gate calls.

SecCallworkTime

NOT NULL

DBTINYINT

Gate number of the agent’s secondary assignment.

SecGate

NOT NULL

DBSMALLINT

Total time, in seconds, the agent was connected as a secondary
assignment to external calls, internal gate transfer calls,
overflow/diversion-in calls, or internal gate calls.

SecTalkTime

NOT NULL

DBSMALLINT

A sequential counter maintained by the ACD.

SerialNumber

NOT NULL

DBINT

Number of seconds elapsed since the agent signed in.

SignedInSeconds

PK NOT NULL

DBDATETIME

The Central Controller date and time when the agent signed in.

SignInTime

FK NULL

DBINT

The ICM software identifier for the agent.

SkillTargetID

NOT NULL

DBTINYINT

Termination type. For valid options, click 

.

Tertype

PK NOT NULL

DBINT

The time zone for the Central Controller. The value is the offset in
minutes from UTC (formerly called GMT).

TimeZone

Galaxy_Alarm Table

This table is in the 

. For database rules, click 

.

Central database only.

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