Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Release Note
1-37
Cisco Unified CCX Database Schema Guide, Release 8.0(1)
Chapter 1 Database Schema
Database Table Details
Related Tables
•
(via resourceID, profileID)
•
(resourceID maps to agentID, via profileID)
•
(resourceID maps originatorID/destinationID 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)
•
(resourceID maps to origMonitoredID when
origMonitoredIDType is 1, via profileID)
•
(via resourceGroupID, profileID)
•
(via resourceSkillMapID, profileID)
•
(via resourceLoginID, profileID)
•
(assignedTeamID maps to teamID, via profileID)
ResourceGroup
Database table name: ResourceGroup
The Unified CCX system creates a new record in the ResourceGroup table when a resource group is set
up in the Unified CCX Administration.
up in the Unified CCX Administration.
A ResourceGroup record contains information about the resource group. One such record exists for each
active and inactive resource group.
active and inactive resource group.
The Resource Group table contains the fields shown in
.
assignedTeamID
Identifier of the resource’s assigned team.
int
NOT NULL
resourceFirstName
The resource’s first name.
nvarchar(50)
NOT NULL
resourceLastName
The resource’s last name.
nvarchar(50)
NOT NULL
Table 1-17
Resource Table Fields (continued)
Field Name
Description
Storage