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

Assessments

Details

Table ID: h_sm_assessment

Details of the assessment matrix that determines which assessment is applied to a Request

Table Attributes

Name Value
Primary Key h_id

Columns

Name & ID Description Column Attributes Relationships
Assessment Matrix
h_assessment_matrix
The matrix for this assessment in JSON format. for example, if this assessment is used to assess the Impact on a request, then the JSON object will be something like {"impact": {"1": {"from": 0, "to": 2},"2": {"from": 3, "to": 6},"3": {"from": 7, "to": 10}}} where 1, 2, 3 are the IDs of the possible Impacts (Low, Medium, High)
Type LONGTEXT
Nullable true
Date Created
h_date_created
The creation date of the record.
Type DATETIME
Nullable true
Default Language
h_default_language
The Default fallback Language of the assessment
Type VARCHAR
Size 64
Nullable true
Indexed true
ID
h_id
The primary key of the table
Type INTEGER
Nullable false
Primary Key true
Auto Increment true
One to Many
h_sm_assessment_questions.h_assessment_id
Language
h_language
Current Language of the name of the assessment
Type VARCHAR
Size 64
Nullable true
Indexed true
Status
h_status
The status of the assessment
Type VARCHAR
Size 32
Nullable true
The assessment type ID
h_assessment_type_id
The assessment type ID
Type INTEGER
Nullable true
Indexed true
Type Date Updated
h_last_updated
The Day and Time of the of when the assessment was last updated
Type DATETIME
Nullable true
Type ID
h_assessment_id
The Linked Type ID
Type INTEGER
Nullable true
Indexed true
Type Name
h_name
The Name of the Assessment
Type VARCHAR
Size 100
Nullable true
Indexed true
In This Document