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 Bulletins

Details

Table ID: h_itsm_service_bulletins

Contains details of bulletins related to a Service (supports translations)

Table Attributes

Name Value
Primary Key h_id

Columns

Name & ID Description Column Attributes Relationships
Bulletin Date Published
h_date_published
The Day and Time of the of when the Bulletin was published
Type DATETIME
Nullable true
Bulletin Date Updated
h_last_updated
The Day and Time of the of when the Bulletin was last updated
Type DATETIME
Nullable true
Bulletin Description
h_bulletin_description
TheBulletin Description
Type LONGTEXT
Nullable true
Bulletin End Timer
h_end_timer
The End Timer of the Bulletin
Type DATETIME
Nullable true
Indexed true
Bulletin ID
h_id
The unique Bulletin Id
Type INTEGER
Nullable false
Primary Key true
Auto Increment true
Bulletin Image
h_service_bulletin_image
The Image Banner of the Bulletin
Type VARCHAR
Size 255
Nullable true
Bulletin Language
h_language
The Language of the Bulletin
Type VARCHAR
Size 25
Nullable true
Indexed true
Bulletin Order
h_order
The Order of the Bulletin
Type INTEGER
Nullable true
Bulletin Start Timer
h_start_timer
The Start Timer of the Bulletin
Type DATETIME
Nullable true
Indexed true
Bulletin Title
h_bulletin_title
The Bulletin Title / Summary
Type VARCHAR
Size 255
Nullable true
Date Created
h_date_created
The creation date of the record.
Type DATETIME
Nullable true
Default Bulletin Language
h_default_language
The Default Language of the Bulletin
Type VARCHAR
Size 25
Nullable true
Display Bulletin Text
h_display_bulletin_text
Configuration option to display the the bulletin text on the Portals
Type INTEGER
Nullable true
Display Text Shadow
h_display_text_shadow
Configuration option to display the the bulletin text shadow
Type INTEGER
Nullable true
Employee Portal Link
h_link
A link to use when view a bulletin in the employee portal
Type VARCHAR
Size 255
Nullable true
Last Updated By
h_lastupdatedby_userid
The user who last updated the record.
Type VARCHAR
Size 100
Nullable true
Linked Service Bulletin ID
h_service_bulletin_id
The linked Service Bulletin ID
Type INTEGER
Nullable true
Indexed true
Published By
h_publishedby_userid
The user who published the record.
Type VARCHAR
Size 100
Nullable true
Service ID
h_service_id
The Service ID
Type INTEGER
Nullable true
Indexed true
Status
h_status
The Status of the Bulletin
Type VARCHAR
Size 25
Nullable true
Indexed true
In This Document