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

Page of 76
1-26
Cisco Unified CCX Database Schema Guide, Release 8.0(1)
Chapter 1      Database Schema
  Database Table Details
CrsTrigger
Database table name: CrsTrigger
The CrsTrigger table describes trigger information. A trigger is uniquely identified by a trigger name 
(triggerName). When a trigger is created, a new record is inserted into this table. When a trigger is 
modified, the old record is marked as inactive, and a new record is inserted into the table with a new 
recordID. When a trigger is deleted, the corresponding record will be marked as inactive.
The CrsGroup table contains the information shown in 
Table 1-12
CrsTrigger Table Fields 
Field Name
Description
Storage
recordID
Unique numeric ID for each record. Introduced for historical 
reporting purposes.
int
NOT NULL
Primary Key
profileID
Identifier of the profile.
Possible values: 1, 2, 3...
int
NOT NULL
Primary Key
configClass
Represents trigger configuration class.
Possible values:
ApplicationTriggerConfig.class
lvarchar(512)
NOT NULL
version
Specifies internal configuration schema version. 
Possible values: 3
int
NOT NULL
configImplClass
Represents trigger configuration implementation class. 
Possible values:
  •
com.cisco.crs.email.
  •
CiscoEmailControlGroupConfig
lvarchar(512)
NOT NULL
triggerName
Uniquely identifies a trigger. Available from CRS 4.5 
onwards. The API does limit the string length. Go back and 
revisit the length.
nvarchar(50)
NOT NULL
triggerType
Hard coded.
Possible values:
  •
Cisco Http Trigger
  •
Cisco JTAPI Trigger
nvarchar(128)
NOT NULL
applicationName
Application name being triggered by the trigger.
nvarchar(50)
NOT NULL
triggerEnabled
Whether the trigger is enabled
Possible values:
  •
f = disabled
  •
t = enabled
boolean
NOT NULL