/mcpKeys and NULL Option Data Type Description Name NULL DBINT Running total of calls the system software sent to the route since midnight. CallsRoutedToday PK NOT NULL DBSMALLDATE The Central Controller date and time at the start of the five-minute interval. DateTime NULL DBINT Length of time that the longest call in the queue for the route had been there at the end of the five-minute interval. LongestCallQ 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 Route table. RouteID NULL DBINT Total of calls to the route abandoned within the service level threshold during the five-minute interval. ServiceLevelAbandTo5 NULL DBINT Cumulative total of calls to the route abandoned within the service level threshold since midnight. ServiceLevelAbandToday NULL DBINT Total number of calls to the route that had a service level event during the five-minute interval. ServiceLevelCallsOfferedTo5 NULL DBINT Total number of calls to the route that had a service level event since midnight. ServiceLevelCallsOfferedToday NULL DBINT Number of calls to the route that had been in queue longer than the service level threshold as of the end of the five-minute interval. ServiceLevelCallsQHeld NULL DBINT Total of calls to the route answered within the service level threshold during the five-minute interval. ServiceLevelCallsTo5 NULL DBINT Cumulative total of calls to the route answered within the service level since midnight. ServiceLevelCallsToday NULL DBFLT4 Service level for the route for the five-minute interval. ServiceLevelTo5 Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 395 All Tables Route_Five_Minute