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

Connect an AI assistant

Your AI assistant can read this documentation directly, so it answers from the current content instead of guessing. Add one of the servers below to your client — they use the Model Context Protocol (MCP). Each one covers a different body of content, so add the one you need.

The catalog did not load. Refresh the page to try again.

Loading…

How can we help?

{{docApp.searchError}}

Searching in {{docApp.searchFilterBySpecificBookTitle}}

 {{docApp.currentResultsSearchText}}  in {{docApp.searchFilterBySpecificBookTitle}}
Found {{docApp.searchResponse.totalResultsAvailable}} matches. Showing the top {{docApp.searchResponse.results ? docApp.searchResponse.results.length : 0}}. Use a more specific search to further narrow down the results.
No documentation pages match this search, so all content types are shown. Most matches are in {{docApp.searchDocTypeRescue.best.name}}.
There is no book with the ID "{{docApp.searchBookRescue.bid}}", so the book filter from this link was ignored and results from all books are shown.

You have an odd number of " characters in your search terms - each one needs closing with a matching " character!

  • {{resultItem.title}} {{resultItem.matchedBy === 'semantic' ? 'semantic' : (resultItem.matchedBy === 'both' ? 'keyword + semantic' : 'keyword')}}

    {{resultItem.url}}

{{docApp.libraryHomeViewProduct.title || docApp.libraryHomeViewProduct.id}}

{{docApp.libraryHomeViewProduct.description}}

  1. {{book.title}}

Employeess

  • Article
  • 1 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