5 Database Administration

Call Data Tables

Call Data Tables

The base ORACLE software package creates the following database tables to store call data (Table 17).

Note: All these tables are created and owned by the sqlplus user sti/sti.

Table 17. ORACLE Call Data Tables

Table NameTable Description

 

 

CCA

Call classification analysis data (contains one record for

 

each attempted transfer or outdial).

 

 

CCASUM

Summary data for the CCA table (contains one record per

 

hour, telephone number, and result code).

 

 

CALL1

Basic call information (contains one record per call).

SERVICE

Basic service information (contains one or more service

 

records per call).

 

 

CDHSUM

Summary data for the CALL and SERVICE tables

 

(contains one record per hour and service).

 

 

 

1 of 2

 

 

UCS 1000 R4.2 Administration 585-313-507

Issue 3 April 2000 197