Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco IP Contact Center Release 4.6.1
  5. Technical References

Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Download
Page of 404
 
2-204
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Service_Array_Member Table
Service_Array_Member Table
Maps individual services to a service array. The member services in a service array must all be associated 
with the same Peripheral Gateway (PG), but may be associated with different peripherals.
Use the Service Explorer tool to add and delete Service_Array_Member records.
Related tables:
Service Array (ServiceArraySkillTargetID maps to Service_Array.SkillTargetID)
Service (ServiceSkillTargetID maps to Service.SkillTargetID)
Service_Five_Minute Table
Central database only.
Contains statistics about each service during the most recent five-minute interval.
The ICM software generates Service_Five_Minute records for each service.
Table 2-168 Service_Array_Member Table
Field Name
Description
Data Type
Keys and Null 
Option
ServiceArraySkillTargetID
Identifies the service array.
int
PK, FK, NOT 
NULL
ServiceSkillTargetID
Identifies a service that is a member of the service 
array.
int
PK, FK, NOT 
NULL
Table 2-169 Service_Five_Minute Table
Field Name
Description
Data Type
Keys and Null 
Option
DateTime
Date and time at the start of the five-minute 
interval.
smalldatetime
PK, NOT NULL
SkillTargetID
Foreign key from the Service table.
int
PK, FK, NOT 
NULL
TimeZone
The time zone for the date and time. The value 
is the offset in minutes from GMT.
int
PK, NOT NULL
CallsInProgress
Number of inbound and outbound calls that had 
previously been offered (for example, calls 
being played an announcement, queued calls, or 
connected calls) and are currently being handled 
for the service.
int
NULL
CallsOfferedToday
Number of incoming calls plus internal calls 
offered to this service since midnight.
int
NULL