/mcpTable 77: TextContactDetail Table Fields Storage Description Field Name varchar (64,0) NOT NULL Primary Key Alphanumeric identifier for this record. ContactID smallint NOT NULL Primary Key Contact sequence number that the system assigned to the contact or the leg. Each leg of a contact is assigned a new contact sequence number. To be used later. ContactSeqNum smallint NOT NULL Numeric identifier for the node. nodeID smallint NOT NULL Type of contact or leg: 1—Incoming. Outside contact received by the Unified CCX system. contactType smallint NOT NULL Type of the media such as email and other media types. 1—Chat 3—Email mediaType smallint NOT NULL Disposition of the contact or the leg. 1—Abandoned 2—Handled 3—Do not care 4—Aborted 8 5—Rejected 6—Cleared 7—Unknown contactDisposition Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 106 Database Schema TextContactDetail