Previous Topic: SLA_Contract_Map TableNext Topic: Spell_Macro Table


SLA_Template Table

Service Level Agreement Templates for Call and Change. Not related to service level agreements in problem manager. Links Service Descriptions with Events.

Field

Data Type

Reference

Remarks

del

INTEGER NOT_NULL

Active_Boolean_Table::enum

Deleted flag

0—Active

1—Inactive/marked as deleted

elapsed

DURATION NOT_NULL

 

Specifies the elapsed time to delay event.

event

STRING 30

Events::persid

Specifies the event.

id

INTEGER UNIQUE NOT_NULL KEY

 

Unique (to the table) Numeric ID

last_mod_by

UUID

ca_contact::uuid

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

last_mod_dt

LOCAL_TIME

 

Indicates the timestamp of when this record was last modified

object_type

STRING 30

 

Specifies the object type for this SLA (cr, chg).

persid

STRING 30

 

Persistent ID (SystemObjectName:id)

service_type

STRING 30 NOT_NULL

Service_Desc::code

 

sym

STRING 30 NOT_NULL S_KEY

 

Specifies the name of the SLA.