Call data tables – HP R4.2 User Manual

Page 236

Advertising
background image

5

Database Administration

Call Data Tables

UCS 1000 R4.2 Administration 585-313-507

Issue 3 April 2000 197

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 Name

Table 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).

CALL

1

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

Advertising