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

Page of 76
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. 
A ResourceGroup record contains information about the resource group. One such record exists for each 
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