Cisco Cisco IPCC Web Option Technical References

PK NOT NULL

DBSMALLDATE

Record timestamp (unique).

DateTime

NOT NULL

DBINT

Number of EMS messages received in the five-minute interval.

EMSMessagesTo5

NOT NULL

DBINT

Total number of five-minute records written during the
five-minute interval.

FiveMinuteHistoryTo5

NOT NULL

DBINT

Total number of half-hour records written during the
five-minute interval.

HalfHourHistoryTo5

NOT NULL

DBFLT8

Number of log pages allocated.

LogPagesAllocated

NULL

DBFLT8

Number of log pages used.

LogPagesUsed

NOT NULL

DBINT

Number of MDS messages received in the five-minute interval.

MDSMessagesTo5

NOT NULL

DBINT

Time spent processing messages in the five-minute interval,
in milliseconds.

MessageTimeTo5

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

DBINT

Number of Route Call Detail rows written during the
five-minute interval.

RouteCallDetailTo5

NOT NULL

DBINT

Number of Termination Call Detail rows written during the
five-minute interval.

TerminationCallDetailTo5

PK NOT NULL

DBINT

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

TimeZone

Logger_Type Table

This table is in the 

. To see database rules for these tables, click 

Identifies the Logger type (that is, standard, Customer ICM (CICM), or Network Applications
Manager (NAM). If the Logger is a NAM Logger, this table also specifies whether or not the
NAM is a slave NAM.

NOT NULL

DBINT

The type of Logger:

LoggerType

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