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
