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

Request Approvers

Details

Table ID: h_sm_request_approvers

Contains a list of who has been chosen as a user that has been designated as an approver

Table Attributes

Name Value
Primary Key h_id

Columns

Name & ID Description Column Attributes Relationships
Approval Complete Flag
h_flg_approvers_completed
This flag determines if the approval processfor the request has been completed.
Type VARCHAR
Size 2
Nullable true
Approvers
h_approvers
The approvers of a Request. This information will be held as a JSON object.
Type LONGTEXT
Nullable true
Confirm Approvers Flag
h_flg_approvers_confirmed
This flag determines if a Request's approvers are confirmed.
Type VARCHAR
Size 2
Nullable true
Indexed true
Date Last Updated
h_last_updated_date
The last updated Date/Time of a Request's approvers record.
Type DATETIME
Nullable true
Id
h_id
Id of an approvers record.
Type INTEGER
Nullable false
Primary Key true
Auto Increment true
Request Id
h_request_id
Id of a Request that an approvers record relates to.
Type VARCHAR
Size 100
Nullable true
Indexed true
Weighting Type
h_weighting_type
The weighting type for approvers of a Request.
Type VARCHAR
Size 100
Nullable true
Indexed true
In This Document