McDewey

Storage Description Field Name smallint Primary Key Unique identifier assigned to each Unified CCX server in the cluster. nodeid smallint Primary Key A new qIndex is created whenever a Unified CCX call is conferenced to a Unified CCX route point. qindex datetime year to fraction Primary Key Date and time that the call or the leg started ringing at the device of an agent. startDateTime smallint Unique number of wrapup reasons for a particular call. A call can have maximum of five wrapup reasons. wrapupindex varchar(40) A unique identifier for all the records related to a single call across various tables in Unified CCX. contactid CrsApplication Database table name: CrsApplication The CrsApplication table records application information. An application is uniquely identified by applicationName. When an application is created, a new record is inserted into this table. When an application is modified, the old record is marked as inactive, and a new record is inserted into the table with a new recordID. When an application is deleted, the corresponding record is marked as inactive. Table 36: CrsApplication Table Fields Storage Description Field Name int NOT NULL Primary Key Unique numeric ID for each record. Introduced for historical reporting purposes. Possible values: 1, 2, 3.... record ID int NOT NULL Primary Key The indentifier of the profile profileID int NOT NULL Configurable application identifier. Not unique for an application. Exposed for Cisco Unified Intelligent Contact Management Enterprise (Unified ICME) integration. Configured on Unified CCX Administration, modifiable. Possible values: -1, 1, 2, 3... applicationID Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 52 Database Schema CrsApplication