McDewey

Multi-vendor documentation library · semantic search · MCP endpoint at /mcp

Page 410

↗ View in doc context
page
410
source
ucce/v15.0.1/db-schema-handbook/db-schema-handbook.md
chunk_id
ucce::v15.0.1::db-schema-handbook::db-schema-handbook::396

index_keys index_description index_name DateTime Nonclustered located on PRIMARY XIE1Route_Call_Variable DbDateTime Nonclustered located on PRIMARY XIE2Route_Call_Variable RecoveryKey Nonclustered, unique, primary key located on PRIMARY XPKRoute_Call_Variable Table 333: Fields in Route_Call_Variable Table Keys and NULL Option Data Type Description Name AK-2 NOT NULL DBINT If the expanded call variable is an array, this identifies the array element: 0 to N-1, where N is the size of the array. ArrayIndex IE-1 NOT NULL DBSMALLDATE The date and time when the call was routed. DateTime IE-2 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 VARCHAR(255) The value of the call variable or array element. ECCValue AK-2, FK NOT NULL DBSMALLINT Identifies the expanded call variable. ExpandedCallVariableID AK-2 NOT NULL DBFLT8 The RecoveryKey value from the associated Route_Call_Detail row. RCDRecoveryKey AK-1 NOT NULL DBFLT8 A unique ID assigned to each record and used internally by the Unified CCE software to track the record. RecoveryKey Route_Five_Minute This table is in the Route category (see Route, on page 625). To see database rules for these tables, see Route Tables, on page 700. It gets populated on central and HDS databases. Each row contains statistics about a route during the most recent five-minute interval. The system software generates Route_Five_Minute records for each route. Related Table Route, on page 379 (via RouteID) Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 392 All Tables Route_Five_Minute