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

Employeess

  • Article
  • 2 minutes to read

Details

Table ID: h_employee_employees

Stores extended information about users. Used exclusively by staff records functionality

Table Attributes

Name Value
Primary Key h_user_id

Columns

Name & ID Description Column Attributes Relationships
Age Band
h_age_band
 Age Band
Nullable true
Type VARCHAR
Size 8
Disability
h_disability
 Disability
Nullable true
Type VARCHAR
Size 512
Employee Number
h_employee_number
 Employee Number
Nullable true
Type INTEGER
Size 11
Ethnicity
h_ethnicity
 Simple List
Nullable true
Type VARCHAR
Size 128
Gender
h_gender
 Gender
Nullable true
Type VARCHAR
Size 8
Limited Leave To Remain Expiry
h_limited_leave_to_remain_expiry
 Limited Leave To Remain Expiry
Nullable true
Type DATETIME
Marital Status
h_marital_status
 Marital Status
Nullable true
Type VARCHAR
Size 128
Person Type
h_person_type
 Simple List
Nullable true
Type VARCHAR
Size 128
Person Type
h_system_person_type
 Person Type
Nullable true
Type VARCHAR
Size 128
Preferred Name
h_preferred_name
 Preferred Name
Nullable true
Type VARCHAR
Size 64
Religion
h_religion
 Religion
Nullable true
Type VARCHAR
Size 20
Residency Status
h_residency_status
 Residency Status
Nullable true
Type VARCHAR
Size 16
Sexual Orientation
h_sexual_orientation
 Sexual Orientation
Nullable true
Type VARCHAR
Size 128
Trust Date Started
h_trust_start_date
 This is the date the person has started working
Nullable true
Type DATETIME
Trust End Started
h_trust_end_date
 This is the date the person has stopped working
Nullable true
Type DATETIME
User Id
h_user_id
 The unique Id for the user
Primary Key true
Auto Increment true
Nullable false
Type VARCHAR
Size 64
Visa Expiry Date
h_visa_expiry_date
 Visa Expiry Date
Nullable true
Type DATETIME
Visa Issue Date
h_visa_issue_date
 Visa Issue Date
Nullable true
Type DATETIME
Visa Type
h_visa_type
 Visa Type
Nullable true
Type VARCHAR
Size 64
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document