Service Level Agreement in problem manager. Links Service Descriptions with Events
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Unique (to the table) numeric identifier. |
| persid | nvarchar(30) | with null | Persistent ID (SystemObjectName:id) |
| map_sdsc | nvarchar(30) | not null | The map sdsc value for this Attached_SLA. |
| ticket_id | integer | not null | The ticket id value for this Attached_SLA. |
| ticket_type | nvarchar(30) | not null | The ticket type value for this Attached_SLA. |
| sla_viol_status | integer | with null | The sla viol status value for this Attached_SLA. |
| time_to_violation | integer | with null | The time to violation value for this Attached_SLA. |
| last_ttv_upd | integer | with null | The last ttv upd value for this Attached_SLA. |
| ttv_event | nvarchar(30) | with null | The ttv event value for this Attached_SLA. |
| del | integer | not null | Deleted flag (0=active 1=inactive/marked as deleted) |
| 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 |
| _mapped_cr | nvarchar(30) | with null | These are mostly required for advanced runtime queries: |
| _mapped_chg | integer | with null | The mapped chg value for this Attached_SLA. |
| _mapped_iss | nvarchar(30) | with null | The mapped iss value for this Attached_SLA. |
| _mapped_wf | integer | with null | The mapped wf value for this Attached_SLA. |
| _mapped_iss_wf | integer | with null | The mapped iss wf value for this Attached_SLA. |
Product Name: Unicenter Service Desk
Table Type: Table