Previous Topic: Attached_Events Table

Next Topic: Attachment Table

Attached_SLA Table

Service Level Agreements associated to a ticket.

Field

Data Type

Reference

Remarks

_mapped_chg

INTEGER

chg id

 

_mapped_cr

STRING 30

Call_Req::persid

These are mostly required for advanced runtime queries.

_mapped_iss

STRING 30

issue persistent_id

 

_mapped_iss_wf

INTEGER

isswf::id

 

_mapped_wf

INTEGER

wf::id

 

del

INTEGER NOT_NULL

Active_Boolean_ Table::enum

Deleted flag

0—Active

1—Inactive/marked as deleted

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.

last_ttv_upd

LOCAL_TIME

 

 

map_sdsc

STRING 30 NOT_NULL

Service_Desc:: code

 

persid

STRING 30

 

Persistent ID (SystemObjectName:id)

sla_viol_status

INTEGER

 

 

ticket_id

INTEGER NOT_NULL S_KEY

 

 

ticket_type

STRING 30 NOT_NULL

 

 

time_to_ violation

LOCAL_TIME

 

 

ttv_event

STRING 30

Attached_Events::persid