srv_desc

Call Request Service Types. not related to service level agreements in problem manager. May be used to associate the type of service a call request is to receive. Defineable by the user. Examples: Platinum, Gold, Silver, Bronze.

Column Name Column Datatype Column Null Option Column Comment
id integer not null Primary key of this table
persid nvarchar(30) with null Persistent ID (SystemObjectName:id)
del integer not null Deleted flag (0=active 1=inactive/marked as deleted)
sym nvarchar(30) not null Name of service type
last_mod_dt integer with null Timestamp of when this record was last modified
last_mod_by byte(16) with null Specifies the UUID of the contact who last modified this record
description nvarchar(500) with null Text description of service
code nvarchar(30) not null Primary key of this table
rank integer with null Service type ranking to determine
schedule nvarchar(30) with null Schedule. Foreign key to the peristent_id field of the bpwshft table
owning_contract integer with null Unique (to the table) Numeric ID
violation_cost integer with null Monetary cost for violation

Product Name: Unicenter Service Desk

Table Type: Table


Copyright © 2006 CA. All rights reserved.