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

Employee Assignment Expiry Notification Targets

Details

Table ID: h_employee_employee_assignment_expiry_notification_targets

Stores target records for assignment expiry notifications. Used exclusively by staff records functionality

Table Attributes

Name Value
Primary Key h_id

Columns

Name & ID Description Column Attributes Relationships
Assignment Expiry Notification Id
h_assignment_expiry_notification_id
The primary key of the parent assignment expiry notification
Nullable true
Type INTEGER
Size 11
Autotask List
h_autotask_list
The assignment expiry notification target autotask list stored as a JSON string
Type LONGTEXT
Nullable true
Conditions
h_conditions
The conditions under which the assignment expiry notification target should fire
Type LONGTEXT
Nullable true
Created By
h_created_by
The user id of the user who created the assignment expiry notification target
Nullable true
Type VARCHAR
Size 64
Date Created
h_date_created
The date the assignment expiry notification target was created
Nullable true
Type DATETIME
Date Last Modified
h_date_last_modified
The last modified date of the assignment expiry notification target
Nullable true
Type DATETIME
Days From Expiry
h_days_from_expiry
The number of days from expiry that the assignment expiry notification target should trigger a notification
Nullable true
Type INTEGER
Size 11
Description
h_description
The assignment expiry notification target description
Type LONGTEXT
Nullable true
Expiry Type
h_expiry_type
The expiry type of the assignment expiry notification target
Nullable true
Type VARCHAR
Size 32
Id
h_id
The unique Id of the assignment expiry notification target
Primary Key true
Auto Increment true
Nullable false
Type INTEGER
Size 11
Last Modified By
h_last_modified_by
The user id of the user who last modified the assignment expiry notification target
Nullable true
Type VARCHAR
Size 64
Name
h_name
The assignment expiry notification target name
Nullable true
Type VARCHAR
Size 512
Target Date Column
h_target_date_column
The date column that the target is referencing
Nullable true
Type VARCHAR
Size 128
In This Document