5 Database Administration

Call Data Tables

Table 17. ORACLE Call Data Tables

Table Name

Table Description

 

 

EVENTS

Event data defined for a service (contains one record per

 

event). There can be more than one EVENTS records per

 

SERVICE record.

 

 

EVSUM

Summary data for the EVENTS table (contains one record

 

per hour and event number).

 

 

TRASUM

Overall traffic summary data (contains one record per hour

 

and channel).

 

 

 

2 of 2

 

 

1 The CALL and SERVICE tables replace the CDH table. Since more than one service (application) may be running during a call, there may be multiple entries in the SERVICE table related to a single entry in the CALL table. A database view named OLDCDH, consisting of fields from the CALL and SERVICE tables, has been created to represent the old CDH table.

The voice system provides four reports that use the data accumulated in these tables. See Chapter 7, Common Administration , for procedures showing how to display, modify, print, and update the available reports.

UCS 1000 R4.2 Administration 585-313-507

Issue 3 April 2000 198