Technical References

Keys and
Null Option:
Data Type:Description:Field Name:
NULLDBFLT4
Service level during the five-minute interval. This is derived from
ServiceLevelCallsTo5 and ServiceLevelCallsHandledTo5.
ServiceLevelTo5
NULLDBFLT4
Cumulative ICM service level for the service since midnight. This
is derived from ServiceLevelCallsToday and
ServiceLevelCallsOfferedToday.
ServiceLevelToday
PK, FK NOT
NULL
DBINT
Foreign key from the Service table.
SkillTargetID
PK NOT NULLDBINT
The time zone for the date and time. The value is the offset in
minutes from UTC (formerly called GMT).
TimeZone
NULLDBINT
This field is not currently used.
Unused1
Service_Half_Hour Table
This table is in the Skill Target category (page 456). To see database rules for these tables, click
here (page 510).
Central database only.
Contains information about each service during the most recent 30-minute interval.
The ICM software generates Service_Half_Hour records for each service.
Related table
Service (page 325) (via SkillTargetID)
Table 190: Indexes for Service_Half_Hour Table
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAK1Service_Half_Hour
DbDateTimenonclustered located on PRIMARYXIE1Service_Half_Hour
DateTime, SkillTargetID, TimeZoneclustered, unique, primary key
located on PRIMARY
XPKService_Half_Hour
Fields in Service_Half_Hour Table:
Keys
and
Null
Option:
Data Type:Description:Field Name:
NULLDBINT
The sum of AnswerWaitTime in seconds for all calls answered for the
service during the last half-hour interval. AnswerWaitTime is the
AnswerWaitTimeToHalf
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
334
Chapter 2: All Tables
Service_Half_Hour Table