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 Assessments

  • Article
  • 1 minutes to read

Details

Table ID: h_sm_request_assessments

Contains the outcomes of the assessment of a Request

Table Attributes

Name Value
Primary Key h_id

Columns

Name & ID Description Column Attributes Relationships
Assessment Data
h_assessment_data
 Assessment question and answer data stored as JSON
Type LONGTEXT
Nullable true
Assessment Date Last Modified
h_date_lastmodified
 The Day and Time of the of when the assessment was last modified
Type DATETIME
Nullable true
Assessment ID
h_assessment_id
 The ID of the related assessment from h_sm_assessment
Type INTEGER
Nullable true
Indexed true
Assessment Type ID
h_assessment_type_id
 The ID of the related assessment type from h_sm_assessment_types
Type INTEGER
Nullable true
Indexed true
Date Created
h_date_created
 The creation date of the record.
Type DATETIME
Nullable true
ID
h_id
 The primary key of the table
Type INTEGER
Nullable false
Primary Key true
Auto Increment true
Outcome
h_outcome
 The outcome value of the assessment
Type INTEGER
Nullable true
Indexed true
Request Id
h_request_id
 Id of a Request that an assessment record relates to.
Type VARCHAR
Size 100
Nullable true
Indexed true
User Id
h_user_id
 The ID of the user that completed the assessment
Type VARCHAR
Size 100
Nullable true
Indexed true
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document