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