Documentation

{{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}}

Service Catalog

Details

Table ID: h_itsm_service_catalog

A list of Catalog Items defined in Service Manager (supports translations)

Table Attributes

Name Value
Primary Key h_id

Columns

Name & ID Description Column Attributes Relationships
BPM Name
h_bpm
The Custom BPM Name
Type VARCHAR
Size 250
Nullable true
Catalog Date Published
h_date_published
The Day and Time of the of when the Catalog was published
Type DATETIME
Nullable true
Catalog Date Updated
h_last_updated
The Day and Time of the of when the Catalog was last updated
Type DATETIME
Nullable true
Catalog Description
h_catalog_description
The Catalog Description
Type LONGTEXT
Nullable true
Catalog Icon
h_icon
The Catalog Font Icon
Type VARCHAR
Size 255
Nullable true
Catalog ID
h_id
The unique Catalog Id
Type INTEGER
Nullable false
Primary Key true
Catalog Language
h_language
The Language of the Catalog
Type VARCHAR
Size 25
Nullable true
Indexed true
Catalog Order
h_order
The Order of the Catalog
Type INTEGER
Nullable true
Catalog Title
h_catalog_title
The Catalog Title / Summary
Type VARCHAR
Size 255
Nullable true
Catalog Visibility
h_visibility
The Visibility of the Catalog i.e. Portals, Service Desk or Both
Type VARCHAR
Size 64
Nullable true
Indexed true
Date Created
h_date_created
The creation date of the record.
Type DATETIME
Nullable true
Default Catalog Language
h_default_language
The Default Language of the Catalog
Type VARCHAR
Size 25
Nullable true
Indexed true
Last Updated By
h_lastupdatedby_userid
The user who last updated the record.
Type VARCHAR
Size 100
Nullable true
Linked Catalog ID
h_request_catalog_id
The linked Catalog ID
Type INTEGER
Nullable true
Indexed true
Progressive Capture
h_pro_capture
The Custom Progressive Capture
Type INTEGER
Nullable true
Published By
h_publishedby_userid
The user who published the record.
Type VARCHAR
Size 100
Nullable true
Request Type
h_request_type
The Request Type i.e. Incident / Service Request
Type VARCHAR
Size 64
Nullable true
Indexed true
Server Catalog ID
h_server_catalog_id
The ID of the catalog stored in the server
Type INTEGER
Nullable true
Indexed true
Service ID
h_service_id
The Service ID
Type INTEGER
Nullable true
Indexed true
Status
h_status
The Status of the Catalog
Type VARCHAR
Size 25
Nullable true
Indexed true
Use Service Subscription
h_flg_use_service_subscription
This determines if ALL Service's subscribers have visibility to the Catalog. By default, this flag will be set to 1 (i.e. Catalog's subscription model mirrors the Service's subscription model).
Type INTEGER
Nullable true
Indexed true
In This Document