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