Cisco Cisco IPCC Web Option Technical References

Page of 620
Fields in Application_Gateway_Half_Hour Table :
Keys and Null
Option:
Data Type:
Description:
Field Name:
PK, FK NOT NULL
DBINT
Identifies the Application Gateway.
ApplicationGatewayID
NULL
DBINT
The average response time, in milliseconds, for all requests to the
Application Gateway during the half-hour interval.
AvgDelayToHalf
PK NOT NULL
DBSMALLDATE
The Central Controller date and time at the start of the interval.
DateTime
IE-1 NULL
DBDATETIME
The current date and time stamp when the records are written to the
HDS database. The logger database has NULL for this column.
DbDateTime
NULL
DBINT
Number of errors that occurred for Application Gateway requests
during the half-hour interval. Consult EMS logs for specific error
information.
ErrorsToHalf
NULL
DBINT
Number of responses that exceeded the LateTimeout value for the
connection during the half-hour interval.
LatesToHalf
NULL
DBINT
The longest response time, in milliseconds, for any request to the
Application Gateway during the half-hour interval.
MaxDelayToHalf
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
NULL
DBINT
The number of requests rejected by the Application Gateway during
the half-hour interval.
RejectsToHalf
NULL
DBINT
The number of request sent to the Application Gateway during the
half-hour interval.
RequestsToHalf
NULL
DBINT
The number of requests to the Application Gateway that timed out
during the half-hour interval.
TimeoutsToHalf
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
NULL
DBINT
Number of requests attempted while no Application Gateway was
available during the half-hour interval.
UnavailableToHalf
Application_Instance Table
. For database rules, click 
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
66
Chapter 2:  All Tables
Application_Instance Table