Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technische Referenzen
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.
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
Option
ServiceArraySkillTargetID
Identifies the service array.
int
PK, FK, NOT
NULL
NULL
ServiceSkillTargetID
Identifies a service that is a member of the service
array.
array.
int
PK, FK, NOT
NULL
NULL
Table 2-169 Service_Five_Minute Table
Field Name
Description
Data Type
Keys and Null
Option
Option
DateTime
Date and time at the start of the five-minute
interval.
interval.
smalldatetime
PK, NOT NULL
SkillTargetID
Foreign key from the Service table.
int
PK, FK, NOT
NULL
NULL
TimeZone
The time zone for the date and time. The value
is the offset in minutes from GMT.
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.
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.
offered to this service since midnight.
int
NULL