5 Database Administration

Call Data Tables

SERVICE Table

The SERVICE table contains the following information:

CID is a numeric field that specifies a non-unique identification number that joins multiple SERVICE.CID to one CALL.CID.

Each call creates one or more SERVICE records, depending on the number of services used to handle the call. All SERVICE records associated with a call have the same SERVICE.CID as the CALL.CID in the CALL record. See Relationship Between the CALL, SERVICE, and EVENT Tables on page 204.

SID is a numeric field that specifies a unique identification that joins one SERVICE.SID to multiple EVENTS.SID.

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 starting time of each service.

END_TIME is a date field that specifies the ending time of each service.

UCS 1000 R4.2 Administration 585-313-507

Issue 3 April 2000 201