5 Database Administration

Call Data Tables

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.

UCS 1000 R4.2 Administration 585-313-507

Issue 3 April 2000 203