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

Page of 76
1-24
Cisco Unified CCX Database Schema Guide, Release 8.0(1)
Chapter 1      Database Schema
  Database Table Details
Related Table
  •
 (via profileID)
CrsGroup
Database Table Name: CrsGroup table
The CrsGroup table describes group information. A group is uniquely identified by the combination of 
groupClassName and groupID. When a group is created, a new record is inserted into this table. When 
a group is modified, the old record is marked as inactive, and a new record is inserted into the table with 
a new recordID. When a group is deleted, the corresponding record is marked as inactive.
The CrsGroup table contains the information shown in 
description
The description of the application that is configured in the 
Unified CCX Administration.
nvarchar(128)
NULL
privateData
Internal data not exposed to customers.
BLOB
NULL
createDateTime
The time when the record is created or updated.
Default value: Current year to second
datetime year 
to second
NOT NULL
active
Whether this record is active.
Possible values:
  •
f = inactive
  •
t = active
boolean
NOT NULL
dateInactive
If active = f, the time when this record became inactive.
datetime year 
to second
NULL
Table 1-10
CrsApplication Table Fields (continued)
Field Name
Description
Storage
Table 1-11
CrsGroup Table Fields 
Field Name
Description
Storage
recordID
A 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 Group configuration class.
Possible values: GroupConfig.class
lvarchar(512)
NOT NULL