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...

Services

  • Article
  • 7 minutes to read

Details

Table ID: h_itsm_services

Contains the information about a Service and the associated configuration (supports translations)

Table Attributes

Name Value
Primary Key h_pk_serviceid

Columns

Name & ID Description Column Attributes Relationships
Access
h_access
 Describe who can apply changes to the service. The possible values are open or private
Type VARCHAR
Size 32
Nullable true
Indexed true
Action Visibility for Change Request
h_change_action_visibility
 The actions visible for Changes associated to this service
Type LONGTEXT
Nullable true
Action Visibility for Incident
h_incident_action_visibility
 The actions visible for Incidents associated to this service
Type LONGTEXT
Nullable true
Action Visibility for Known Error
h_knownerror_action_visibility
 The actions visible for Known Errors associated to this service
Type LONGTEXT
Nullable true
Action Visibility for Problem
h_problem_action_visibility
 The actions visible for Problems associated to this service
Type LONGTEXT
Nullable true
Action Visibility for Release
h_release_action_visibility
 The actions visible for Releases associated to this service
Type LONGTEXT
Nullable true
Action Visibility for Service Request
h_service_action_visibility
 The actions visible for Service Requests associated to this service
Type LONGTEXT
Nullable true
Allow Change Requests
h_allow_changerequests
 Hide or display the Service when raising a Change Request
Type INTEGER
Nullable true
Allow Incidents
h_allow_incidents
 Hide or display the Service when raising an Incident
Type INTEGER
Nullable true
Allow Known Errors
h_allow_knownerrors
 Hide or display the Service when raising a Known Error
Type INTEGER
Nullable true
Allow Problems
h_allow_problems
 Hide or display the Service when raising a Problem
Type INTEGER
Nullable true
Allow Releases
h_allow_releases
 Hide or display the Service when raising a Release
Type INTEGER
Nullable true
Allow Service Requests
h_allow_servicerequests
 Hide or display the Service when raising a Service Request
Type INTEGER
Nullable true
Available in Portals
h_available
 Whether this service is available in Service and Customer Portals
Type INTEGER
Nullable true
Indexed true
Business Owner
h_businessownername
 The business ownername of the service
Type VARCHAR
Size 100
Nullable true
Business Owner ID
h_businessownerid
 The Business Owner's ID
Type INTEGER
Nullable true
Change BPM Name
h_change_bpm_name
 The name of the BPM process that should be used when raising a Change
Type VARCHAR
Size 255
Nullable true
Change Email Template
h_change_email_template
 Email template used when sending an email from an Change for this service
Type VARCHAR
Size 255
Nullable true
Change Email Template Group
h_change_email_template_group
 Email template group
Type VARCHAR
Size 256
Nullable true
Change Request Portals BPM HUD
h_service_changerequest_portal_hud
 Whether or not if the BPM HUD can bev viewed in the portals for Change Request Request Type
Type VARCHAR
Size 64
Nullable true
Custom A
h_custom_a
 Custom Field A
Type VARCHAR
Size 100
Nullable true
Custom B
h_custom_b
 Custom Field B
Type VARCHAR
Size 100
Nullable true
Custom C
h_custom_c
 Custom Field C
Type VARCHAR
Size 100
Nullable true
Custom D
h_custom_d
 Custom Field D
Type VARCHAR
Size 100
Nullable true
Custom E
h_custom_e
 Custom Field E
Type VARCHAR
Size 100
Nullable true
Custom F
h_custom_f
 Custom Field F
Type VARCHAR
Size 100
Nullable true
Date Created
h_date_created
 The creation date of the record.
Type DATETIME
Nullable true
Defailt Mailbox Name
h_mbid
 The name for the mailbox that this Service should attempt to use by default when sending an email manually from a Request
Type VARCHAR
Size 64
Nullable true
Default Service Language
h_default_language
 The Default Language of the Service
Type VARCHAR
Size 25
Nullable true
FAQ Portal Order
h_faqs_portal_order
 The ordering method used when displaying the FAQ list for this service in the portals
Type VARCHAR
Size 15
Nullable true
Feedback Enabled
h_feedback_enabled
 Enable/Disable feedback for service
Type INTEGER
Nullable true
Icon
h_icon
 The icon used in portals when viewing request
Type VARCHAR
Size 255
Nullable true
Incident BPM Name
h_incident_bpm_name
 The name of the BPM process that should be used when raising an Incident
Type VARCHAR
Size 255
Nullable true
Incident Email Template
h_incident_email_template
 Email template used when sending an email from an Incident for this service
Type VARCHAR
Size 255
Nullable true
Incident Email Template Group
h_incident_email_template_group
 Email template group
Type VARCHAR
Size 256
Nullable true
Incident Portals BPM HUD
h_service_incident_portal_hud
 Whether or not if the BPM HUD can bev viewed in the portals for Incident Request Type
Type VARCHAR
Size 64
Nullable true
Known Error BPM Name
h_knownerror_bpm_name
 The name of the BPM process that should be used when raising a Known Error
Type VARCHAR
Size 255
Nullable true
Known Error Email Template
h_knownerror_email_template
 Email template used when sending an email from an Known Error for this service
Type VARCHAR
Size 255
Nullable true
Known Error Template Group
h_knownerror_email_template_group
 Email template group
Type VARCHAR
Size 256
Nullable true
Last Updated By
h_lastupdatedby_userid
 The user who last updated the record.
Type VARCHAR
Size 100
Nullable true
Linked Translation Id
h_linked_service_id
 The Linked Service Id
Type INTEGER
Nullable true
Indexed true
Portfolio Status
h_portfolio_status
 The service portfolio stage
Type VARCHAR
Size 50
Nullable true
Indexed true
Problem BPM Name
h_problem_bpm_name
 The name of the BPM process that should be used when raising a Problem
Type VARCHAR
Size 255
Nullable true
Problem Email Template
h_problem_email_template
 Email template used when sending an email from an Problem for this service
Type VARCHAR
Size 255
Nullable true
Problem Email Template Group
h_problem_email_template_group
 Email template group
Type VARCHAR
Size 256
Nullable true
Release BPM Name
h_release_bpm_name
 The name of the BPM process that should be used when raising a Release
Type VARCHAR
Size 255
Nullable true
Release Email Template
h_release_email_template
 Email template used when sending an email from an Problem for this service
Type VARCHAR
Size 255
Nullable true
Release Email Template Group
h_release_email_template_group
 Email template group
Type VARCHAR
Size 256
Nullable true
Server Service ID
h_server_service_id
 The ID of the service stored in the server
Type INTEGER
Nullable true
Indexed true
Service
h_servicename
 Display name of the service
Type VARCHAR
Size 200
Nullable true
Service BPM Name
h_service_bpm_name
 The name of the BPM process that should be used when raising a Service Request
Type VARCHAR
Size 255
Nullable true
Service Catalog Category
h_service_catalog_category
 The category of the Service Catalog that the Service is associated to
Type VARCHAR
Size 16
Nullable true
Service Catalog Domain
h_service_catalog_domain
 The is the name of the Service Catalog Domain the Service is associated to
Type VARCHAR
Size 255
Nullable true
Service Category
h_fk_servicecategory
 Category of the service
Type VARCHAR
Size 128
Nullable true
Service Date Updated
h_last_updated
 The Day and Time of the of when the Service was last updated
Type DATETIME
Nullable true
Service Description
h_servicedescription
 A brief description of the service
Type LONGTEXT
Nullable true
Service Email Template
h_service_email_template
 Email template used when sending an email from an Service Request for this service
Type VARCHAR
Size 255
Nullable true
Service Email Template Group
h_service_email_template_group
 Email template group
Type VARCHAR
Size 256
Nullable true
Service ID
h_pk_serviceid
 Unique ID for the Service
Type INTEGER
Nullable false
Primary Key true
One to One
ServiceStatus
h_itsm_servicestatus.h_fk_serviceid
One to Many
ServiceRequestDetails
h_itsm_service_request_details.h_service_id
ServicesUsers
h_itsm_services_users.h_service_id
ServiceRequestConfiguration
h_itsm_service_request_configuration.h_service_id
ServiceConnections
h_itsm_service_connections.h_fk_serviceid
Statuses
h_itsm_statuses.h_service_id
Service Language
h_language
 The Language of the Service
Type VARCHAR
Size 25
Nullable true
Indexed true
Service Request Portals BPM HUD
h_service_servicerequest_portal_hud
 Whether or not if the BPM HUD can bev viewed in the portals for Service Request Request Type
Type VARCHAR
Size 64
Nullable true
Status
h_status
 The current status of the service
Type VARCHAR
Size 50
Nullable true
Type ID
h_fk_type
 The service type. This may refer to the service being internal, external, customer, service, or organisation
Type VARCHAR
Size 150
Nullable true
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document