OmniMessaging Functional Description 8.3

OmniMessaging Functional Description
07/22/04 Opsol Integrators Inc. Confidential and Proprietary Page 62 of 68
Stats table structure
Reports are generated from stats table, which stores the statistics for CP, CTI and
CC. Structure of stats table is show below.
Column Names Description
Trans_Hash_Key Hash Key to distribute the records evenly
across all the partitions
Transaction_id Unique ID generated for each transaction
Server_Type Type of the server for which the stats
are being collected
Start_Time Start time of the transaction in Julian
Timestamp
End_Time End Time of the transaction in Julian
Timestamp
Counter1-Counter125 General purpose counters for reporting
purposes
Column1-Column10 General purpose columns for reporting
purposes