Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Release Note
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.
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.
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.
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