Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Release Note

Page of 76
1-22
Cisco Unified CCX Database Schema Guide, Release 8.0(1)
Chapter 1      Database Schema
  Database Table Details
Related Tables
  •
 (recordID maps to targetID when targetType is 0, and via profileID)
  •
 (via profileID)
  •
 (recordID maps to origMonitoredID when origMonitoredIDType 
is 2, and via profileID)
  •
 (via resourceGroupID and profileID)
  •
 (via skillGroupID and profileID)
  •
 (contactServiceQueueID maps to csqID, and via profileID
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.
The CrsApplication table contains the information shown in 
orderList
Reserved for future use.
int
NULL
wrapupTime
Time in seconds that agent is placed in Work state. 
Possible values: 
 
1 – 7200
 
0 – disabled
smallint
NULL
prompt
The prompt value is used for remote monitoring. The 
customer can record the name of the CSQ and store it in a 
WAV file. This field contains the name of the WAV file.
lvarchar (256)
NOT NULL
privateData
Any fields which are used internally only can be stored in 
this column in a blob.
BLOB
NULL
queueType
A type of the CSQ. 
Possible values: 
 
0 – voice CSQ
 
1 – email CSQ
smallint 
NOT NULL
Table 1-9
ContactServiceQueue Table Fields (continued)
Field Name
Description
Storage