/mcpTable 250: Fields in Network_Event_Detail Table Keys and NULL Option Data Type Description Name NOT NULL DBSMALLINT The LegID identifies the calling party the event pertains to. LegIDs are typically numbered starting with 1 (for example: LegID1 = Calling Party) and incremented for the next party (agents are typically LegID2). CallLegID NOT NULL DBDATETIME Timestamp of receipt of event at the NIC (in UTC).. DateTime NULL DBINT The duration is written for DISCONNECT/UNKNOWN events. Unless an error occurs, the Disconnect event will be written with the duration. If the call ends for a reason other than Disconnect event (e.g. - network stops call), an Unknown event will be written with the duration. Duration NULL DBSMALLINT Valid values are: • 1 = RouteSelectFailure • 2 = CallPartyBusy • 3= NoAnswer • 4 = Answer • 5 = Abandon • 6 = Disconnect • 7 = Unknown Event 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 NOT NULL DBINT Used with RouterCallKeyDay and RouterCallKeySequenceNumber to identify the Route_Call_Detail record. This value forms the unique portion of the 64-bit key for the call. The system software resets this counter at midnight. RouterCallKey Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 309 All Tables Network_Event_Detail