5 Database Administration

Call Data Tables

CDHSUM Table

The CDHSUM table contains the following information:

SUMID is a numeric field that specifies a unique identification number that joins CDHSUM.SUMID to EVSUM.SUMID.

SERVICE is a variable-length character field that specifies the service (application) name. This field can be up to 16 characters in length.

START_TIME is a date field that specifies the start of the hour (for example, 10:00:00).

DURATION is a numeric field that specifies the sum of service run times during this hour in seconds.

USAGE is a numeric field that indicates the total number of times the service was run for calls during a 1-hour period.

Note: Records are generated on a per-hour and a per-service basis.

EVENTS Table

The EVENTS table contains the following information:

SID is a numeric field that specifies a nonunique identification number.

Note: Each service run during a call creates a certain number of event records, depending on the number of events defined. All events

UCS 1000 R4.2 Administration 585-313-507

Issue 3 April 2000 202