McDewey

happen while storing the customer data into the database. Customer can write custom reports on top of this historical reporting table and use the persisted data. Table 79: TextCustomerDetail Table Fields Storage Description Field Name nvarchar (64,0) NOT NULL Primary Key Alphanumeric identifier for this record. ContactID int NOT NULL The unique field IDs corresponding to the field names in the non-voice contact or MediaCustomerDataMapping table. In actual table schema there are 10 individual columns named FieldID1 through FieldID10. FieldID1 to FieldID10 lvarchar (600) NOT NULL Indicates the field values provided for the corresponding field names in the non-voice contact or MediaCustomerDataMapping table. In actual table schema there are 10 individual columns named FieldValue1 through FieldValue10. FieldValue1 to FieldValue5 FieldValue9 to FieldValue10 lvarchar (5080) NULL Indicates the field values provided for the corresponding field names in the non-voice contact or MediaCustomerDataMapping table. In case of email contact the field values 6 to 8 are used for the Agent added email addresses in the CC, BCC and To fields respectively. FieldValue6 to FieldValue8 datetime year to fraction(3) NOT NULL Indicates the date and time of insertion. InsertionDate Related Topics • ChatUserForm, on page 29 (via fieldID) • TextContactDetail , on page 105 (via ContactID) • MediaCustomerDataMapping, on page 74 (via FieldID) TextRatingDetail Database table name: TextRatingDetail The Unified CCX system creates a new record in the TextRatingDetail table each time the customer rates a chat experience. Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 110 Database Schema TextRatingDetail