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

Employees Organisation Information

  • Article
  • 1 minutes to read

Details

Table ID: h_employee_employee_organisations

Stores organisation records

Table Attributes

Name Value
Primary Key h_id

Columns

Name & ID Description Column Attributes Relationships
Budget Holder 1
h_budget_holder_1
 Budget Holder 1
Nullable true
Type VARCHAR
Size 64
Indexed true
Budget Holder 2
h_budget_holder_2
 Budget Holder 2
Nullable true
Type VARCHAR
Size 64
Indexed true
Budget Holder 3
h_budget_holder_3
 Budget Holder 3
Nullable true
Type VARCHAR
Size 64
Indexed true
Budget Holder 4
h_budget_holder_4
 Budget Holder 4
Nullable true
Type VARCHAR
Size 64
Indexed true
Clinical Group
h_clinical_group
 Group
Nullable true
Type VARCHAR
Size 160
Cost Centre
h_cost_centre
 Cost Centre
Nullable true
Type VARCHAR
Size 160
Date From
h_date_from
 Date From
Nullable true
Type DATETIME
Date To
h_date_to
 Date To
Nullable true
Type DATETIME
Department
h_department
 Department
Nullable true
Type VARCHAR
Size 160
Indexed true
Directorate
h_directorate
 Group
Nullable true
Type VARCHAR
Size 160
Finance Manager
h_finance_manager
 Finance Manager
Nullable true
Type VARCHAR
Size 64
Indexed true
Id
h_id
 The unique Id of the organisation
Primary Key true
Auto Increment true
Nullable false
Type INTEGER
Size 11
Location
h_location
 Location
Nullable true
Type VARCHAR
Size 128
Senior Finance Manager
h_senior_finance_manager
 Senior Finance Manager
Nullable true
Type VARCHAR
Size 64
Indexed true
Speciality
h_speciality
 Simple List
Nullable true
Type VARCHAR
Size 128
Sub Speciality
h_sub_speciality
 Sub Speciality
Nullable true
Type VARCHAR
Size 128
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document