Previous Topic: Service_Contract TableNext Topic: session_log Table

Data Element Dictionary › Service_Desc Table

Service_Desc Table

This table contains the Call Request Service Types that are not related to service level agreements in Problem Manager. These may be used to associate the types of service call requests to receive, and are can be defined by the user. Examples include: Platinum, Gold, Silver, or Bronze.

Field

Data Type

Reference

Remarks

code

nvarchar(30)

 

Specifies the primary key of this table.

del

INTEGER

Active_Boolean_ Table::enum

Specifies the status of the Deleted flag as follows:
0—Active
1—Inactive/marked as deleted

description

nvarchar
(500)

 

Provides the text description of service.

id

INTEGER

 

Specifies the primary key of this table.

last_mod_by

byte(16)

ca_contact::uuid

Specifies the UUID of the contact who last modified this record.

last_mod_dt

INTEGER

 

Identifies the timestamp for when this record was last modified.

owning
_contract

INTEGER

Service_Contract ::id

Specifies the unique (to the table) numeric ID.

persid

nvarchar(30)

 

Identifies the Persistent ID: (SystemObjectName:id)

rank

INTEGER

 

Identifies the ranking status of the service type to determine level of priority.

schedule

nvarchar(30)

Bop_Workshift
::persid

Foreign key to the peristent_id field of the bpwshft table, this is the Schedule.

sym

nvarchar(30)

 

Identifies the name of the service type.

violation_cost

INTEGER

 

Specifies the monetary cost for violation.