Documentation
    {{docApp.userSession.userId}}
    {{docApp.userSession.userName}}
    {{docApp.userSession.email}}
    Issuer : {{docApp.userSession.issuerInstance}}
    Expires : {{new Date(docApp.userSession.validUntil).toLocaleDateString()}}

{{docApp.title}}

{{docApp.description}}

How can we help?

{{docApp.searchError}}
{{product.name}}

Searching in {{docApp.searchFilterBySpecificBookTitle}}

{{docApp.searchResultFilteredItems.length}} results for: {{docApp.currentResultsSearchText}} in {{docApp.searchFilterBySpecificBookTitle}}
Search results have been limited. There are a total of {{docApp.searchResponse.totalResultsAvailable}} matches.

You have an odd number of " characters in your search terms - each one needs closing with a matching " character!

{{docApp.libraryHomeViewProduct.title || docApp.libraryHomeViewProduct.id}}

{{docApp.libraryHomeViewProduct.description}}

  1. {{book.title}}

{{group.title || group.id}}

{{group.description}}

  1. {{book.title}}

{{group.title}}

{{book.title}}
More...

Request SLM Targets

  • Article
  • 2 minutes to read

Details

Table ID: h_itsm_request_slm_targets

Details of the targets for a particular Service Level

Table Attributes

Name Value
Primary Key h_id

Columns

Name & ID Description Column Attributes Relationships
Archived By
h_archivedby
 ID of the person who archived the service level target
Type VARCHAR
Size 255
Nullable true
Archived On
h_archivedon
 The date and time the target was archived
Type DATETIME
Nullable true
Name
h_name
 Name of the service level target
Type VARCHAR
Size 255
Nullable true
Request Reference
h_request_id
 Reference number of the request in the h_itsm_request table
Type VARCHAR
Size 100
Nullable true
Indexed true
Service Level ID
h_fk_servlevelid
 The foreign key of the service level
Type VARCHAR
Size 100
Nullable true
Target Completion Duration
h_target_completed_duration
 Total Time Duration spent when the target was completed
Type INTEGER
Nullable true
Target Completion Time
h_target_completed_time
 The date and time the target was completed on
Type DATETIME
Nullable true
Target Duration
h_target_duration
 Total Time Duration given for the target
Type INTEGER
Nullable true
Target ID
h_id
 The primary key of the request slm target
Type VARCHAR
Size 100
Nullable false
Primary Key true
Target Met
h_target_met
 If the target was completed within the target time
Type INTEGER
Nullable true
Target Start Time
h_target_start
 The date and time the target was started
Type DATETIME
Nullable true
Target State
h_state
 The state of the target - 0 current, 1 archived, 2 cancelled
Type INTEGER
Nullable true
Target Time
h_target_time
 The date and time the target should be completed by
Type DATETIME
Nullable true
Timer Elapsed Working Time
h_timer_elapsed_working_duration
 The working time duration elapsed by the related system timer during its lifetime
Type VARCHAR
Size 100
Nullable true
Timer End Time
h_timer_end
 The date and time the related system timer was stopped
Type DATETIME
Nullable true
Timer ID
h_timer_id
 Optional related timer id of the system timer in use in h_sys_timers to process the target
Type INTEGER
Nullable true
Timer Service Level Calendar
h_timer_servlevelcalendar
 Relates to the Working Time Calendar used by the related system timer
Type VARCHAR
Size 64
Nullable true
Timer Start Time
h_timer_start
 The date and time the related system timer was started
Type DATETIME
Nullable true
Timer State
h_timer_state
 The state of the system timer - 0=Idle, 1=Running, 2=Paused, 3=Expired
Type INTEGER
Nullable true
Type
h_type
 Type of the service level target
Type VARCHAR
Size 255
Nullable true
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document