McDewey

Storage Description Field Name boolean NOT NULL Indicates whether the entry is active or inactive. f= Inactive t= Active active datetime year to second Date when the record became inactive. dateInactive ConsultLegDetail Database table name: ConsultLegDetail The Unified CCX system creates a new record in the ConsultLegDetail table when agents are in a consult call. Table 26: ConsultLegDetail Table Fields Storage Description Field Name decimal (18, 0) NOT NULL Primary Key Identifier that the system assigns to the call. sessionid smallint NOT NULL Session sequence number that the system assigns to the call. sessionseqnum smallint NOT NULL Unique identifier assigned to each server in the cluster. nodeid int NOT NULL Identifier of the agent who initiated the consult call. sourceresourceid int NOT NULL Identifier of the agent who answered the call. destinationresourceid datetime year to fraction (3) NOT NULL Date and time when agents are connected and start conversation. startdatetime datetime year to fraction (3) NOT NULL Date and time when the call is disconnected. enddatetime varchar (40) NOT NULL Unique Identifier for the contact. contactid Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 33 Database Schema ConsultLegDetail