HP R4.2 CDHSUM Table, EVENTS Table

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