5
Database Administration
Call Data Tables
UCS 1000 R4.2 Administration 585-313-507
Issue 3 April 2000 203
records associated with this call have the same SID number as
the SID field of the corresponding SERVICE record.
See
Relationship Between the CALL, SERVICE, and EVENT
Tables on page 204
for more information.
EVSUM Table
The EVSUM table contains the following information:
•
SUMID is a numeric field that specifies a unique identification number.
Note:
The values in this field are related to the SUMID values in the
CDHSUM table.
•
EVENT_NUMBER is a numeric field that specifies the internal mapping
between the event and an internal number.
•
SUM_TOT is a numeric field that indicates the total number of
occurrences for this event.
Note:
If the event type is a numeric, the value in SUM_TOT is the sum of
the values of this event field for all the calls. For example, if an
event field, NUM_TRANS, keeps track of the number of
transactions for each call, SUM_TOT contains the sum of
NUM_TRANS for all calls during this time period. On the other
hand, if the event type is not a number, each call increments
SUM_TOT by one.
