Technical References

Keys and Null Option:Data Type:Description:Field Name:
PK NOT NULLDBSMALLDATE
Record timestamp (unique).
DateTime
NOT NULLDBINT
Number of EMS messages received in the five-minute interval.
EMSMessagesTo5
NOT NULLDBINT
Total number of five-minute records written during the
five-minute interval.
FiveMinuteHistoryTo5
NOT NULLDBINT
Total number of half-hour records written during the
five-minute interval.
HalfHourHistoryTo5
NOT NULLDBFLT8
Number of log pages allocated.
LogPagesAllocated
NULLDBFLT8
Number of log pages used.
LogPagesUsed
NOT NULLDBINT
Number of MDS messages received in the five-minute interval.
MDSMessagesTo5
NOT NULLDBINT
Time spent processing messages in the five-minute interval,
in milliseconds.
MessageTimeTo5
AK-1 NOT NULLDBFLT8
A unique ID assigned to each record and used internally by
the ICM/IPCC Enterprise software to track the record.
RecoveryKey
NOT NULLDBINT
Number of Route Call Detail rows written during the
five-minute interval.
RouteCallDetailTo5
NOT NULLDBINT
Number of Termination Call Detail rows written during the
five-minute interval.
TerminationCallDetailTo5
PK NOT NULLDBINT
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 System category (page 460). To see database rules for these tables, click here
(page 511).
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.
Fields in Logger_Type Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLDBINT
The type of Logger:
LoggerType
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
229
Chapter 2: All Tables
Logger_Type Table