Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Leaflet
45
Cisco Customer Response Solutions Database Schema
Database Schema
Database Table Details
Related Tables
•
(via resourceID, profileID)
•
(resourceID maps to agentID, via profileID)
•
when originatorType/destinageType is 1, via profileID)
•
(resourceID maps to targetID when targetType
is 1, via profileID)
•
(resourceID maps to monitoredRsrcID,
via profileID)
•
(via profileID)
•
when origMonitoredIDType is 1, via profileID)
•
•
•
(via resourceLoginID, profileID)
•
(assignedTeamID maps to teamID, via profileID)
ResourceGroup
Database table name: ResourceGroup
The Cisco CRS system creates a new record in the ResourceGroup table when a
resource group is set up in CRS Administration.
resource group is set up in CRS Administration.
A ResourceGroup record contains information about the resource group. One
such record exists for each active and inactive resource group.
such record exists for each active and inactive resource group.
resourceFirstName
The resource’s first name.
nvarchar(50)
NOT NULL
resourceLastName
The resource’s last name.
nvarchar(50)
NOT NULL
Table 1-15
Resource Table Fields (continued)
Field Name
Description
Storage