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