5 Database Administration Call Data Tables
UCS 1000 R4.2 Administration 585-313-507 Issue 3 April 2000 202
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
