Cisco Cisco IPCC Web Option Technical References
2-141
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Peripheral_Default_Route Table
Peripheral_Default_Route Table
Each row specifies the default route to be used for accounting calls at the peripheral that are otherwise
not accounted for.
not accounted for.
The ICM software automatically generates a Peripheral_Default_Route record for each Peripheral. You
can modify the record through the PG Explorer tool.
can modify the record through the PG Explorer tool.
Related tables:
Media Routing Domain (via MRDomainID)
Peripheral (via PeripheralID)
Route (via RouteID)
Peripheral_Half_Hour Table
Central database only.
Each row contains statistics for a specific peripheral for a specific half- hour interval.
Table 2-119 Peripheral_Default_Route Table
Field Name
Description
Data Type
Keys and Null
Option
Option
PeripheralID
Link to the Peripheral table.
smallint
PK1, NOT
NULL
NULL
MRDomainID
The Media Routing Domain associated with this
peripheral default route.
peripheral default route.
int
PK2 NOT
NULL
NULL
RouteID
Foreign key from the Route table.
int
FK, NULL
Table 2-120 Peripheral_Half_Hour Table
Field Name
Description
Data Type
Keys and Null
Option
Option
DateTime
Central Controller date and time at the start
of the half- hour interval.
of the half- hour interval.
smalldatetime
PK, NOT NULL
PeripheralID
Identifier for the peripheral.
smallint
PK, FK, NOT
NULL
NULL
TimeZone
The time zone for the date and time. The
value is the offset in minutes from GMT.
value is the offset in minutes from GMT.
int
PK, NOT NULL
MRDomainID
The ID for the Media Routing Domain
associated with this peripheral.
associated with this peripheral.
int
PK, FK NOT
NULL
NULL
RecoveryKey
A value used internally by the ICM software
to track virtual time.
to track virtual time.
float
AK1, NOT
NULL
NULL