McDewey

ChatTriggerPoint Database table name: ChatTriggerPoint This table describes chat CSQ tag information. A ChatTriggerPoint is uniquely identified by a csqID and a chattriggerpointname. Chat contacts inserted into Unified CCX are queued to respective CSQs based on the chattriggerpointname present in the contact. When a chat CSQ is created, a new record is inserted into this table. When a CSQ is modified, the old record is marked as inactive, and a new record is inserted into the table with a the new csqID. When a CSQ is deleted, the corresponding record is marked as inactive. Table 22: ChatTriggerPoint Table Fields Storage Description Field Name int NOT NULL Numeric identifier for the CSQ. csqID Ivarchar(256) NOT NULL Name of fields present in the chat trigger point. chattriggerpointname boolean NOT NULL Indicates whether the record is currently active. f = Inactive t = Active active Datetime year to fraction(3) NULL If the active field is “f”, date and time that the record became inactive. dateinactive Related Topics ChatUserForm, on page 29 ChatUserForm Database table name: ChatUserForm This table contains the user form fields included in each chat widget along with the order of the fields in the widget. Table 23: ChatUserForm Table Fields Storage Description Field Name int NOT NULL Primary Key Unique ID for each chat widget. It is the foreign key which associates this table with the chatwidget table. wdID lvarchar (200) NOT NULL Name of fields present in the user form. fieldName Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 29 Database Schema ChatTriggerPoint