McDewey

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

Page 463

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

It gets populated on central and HDS databases. This table contains statistics about each script version for the most recent five-minute interval. The system software generates Script_Five_Minute records for each script. Related Tables Script, on page 441 (via ScriptID) Table 372: Indexes for Script_Five_Minute Table index_keys index_description index_name RecoveryKey Nonclustered, unique, unique key located on PRIMARY XAK1Script_Five_Minute ScriptID, DateTime, TimeZone Clustered, unique, primary key located on PRIMARY XPKScript_Five_Minute Table 373: Fields in Script_Five_Minute Table Keys and NULL Option Data Type Description Name NOT NULL DBINT Number of calls that came into the script during the five-minute interval. CallsIncomingTo5 NOT NULL varchar An array indicating the number of calls that traversed each node of the script during the five-minute interval. Each element in the array is a short integer. An array for a script with 40 nodes is stored in the database as a varbinary(80) array. CallsPerNode NOT NULL DBINT Number of calls that came into the script during the five-minute interval. CallsRoutedTo5 PK NOT NULL DBSMALLDATE Central Controller date and time at start of five-minute interval. DateTime NOT NULL DBINT Currently not used, set to zero (0). RecoveryDay 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 PK, FK NOT NULL DBINT Foreign key from the Script table. ScriptID PK NOT NULL DBINT The Central Controller’s time zone for the date and time. The value is the offset in minutes from UTC (formerly GMT).The value is negative for time zones to the east of UTC and positive for time zones to the west of UTC. TimeZone Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 445 All Tables Script_Five_Minute