McDewey

• AgentConnectionDetail, on page 4 (monitoredSessionSeqNum maps to sessionSeqNum, via nodeID, profileID) • ContactCallDetail, on page 34 (monitoredSessionSeqNum maps to sessionSeqNum, via sessionID, nodeID, profileID) • ContactQueueDetail (monitoredSessionSeqNum maps to sessionSeqNum, via nodeID, profileID) • ContactRoutingDetail , on page 46 (monitoredSessionSeqNum maps to sessionSeqNum, via nodeID, profileID) • RemoteMonitoringDetail , on page 79 (via sessionID, profileID, nodeID, startMonitoringReqTime) • Resource, on page 81 (monitoredRsrcID maps to resourceID, via profileID) MediaCustomerDataMapping Database table name: MediaCustomerDataMapping The MediaCustomerDataMapping table contains mapping between the customer data fields for a specific media (such as email and other media types) and the order of fields stored in the TextCustomerDetail table. Do not edit this table directly. It is for internal use only Note Table 50: MediaCustomerDataMapping Table Fields Storage Description Field Name int NOT NULL Primary Key Unique identifier for the record. recordId varchar(30,0) NOT NULL Primary Key Type of the media such as email and other media types. mediaType varchar(50,0) NOT NULL Name of the field in the customer data. fieldName int NOT NULL Field ID in the TextCustomerDetail where this field is stored. columnId Related Topics • TextCustomerDetails, on page 109 (via columnId) Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 74 Database Schema MediaCustomerDataMapping