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

Employees Positions Information

  • Article
  • 1 minutes to read

Details

Table ID: h_employee_employee_positions

Stores position records

Table Attributes

Name Value
Primary Key h_id

Columns

Name & ID Description Column Attributes Relationships
Area of Work
h_area_of_work
 Area of Work
Nullable true
Type VARCHAR
Size 128
Cost Centre
h_cost_centre
 Cost Centre
Nullable true
Type VARCHAR
Size 160
DBS
h_dbs
 DBS
Nullable true
Type VARCHAR
Size 128
Department
h_department
 Group
Nullable true
Type VARCHAR
Size 160
Frequency
h_frequency
 Frequency
Nullable true
Type VARCHAR
Size 128
Funded Fte
h_funded_fte
 Funded Fte
Nullable true
Type DECIMAL
Precision 38
Scale 15
Grade
h_grade
 Grade
Nullable true
Type VARCHAR
Size 8
Hiring Status
h_hiring_status
 Simple List
Nullable true
Type VARCHAR
Size 128
Hours
h_hours
 Hours
Nullable true
Type DECIMAL
Precision 38
Scale 15
Id
h_id
 The unique Id of the position
Primary Key true
Auto Increment true
Nullable false
Type INTEGER
Size 11
Occupation Code
h_occupation_code
 Occupation Code
Nullable true
Type VARCHAR
Size 32
Position Effective End Date
h_position_effective_end_date
 Position Effective End Date
Nullable true
Type DATETIME
Position Effective Start Date
h_position_effective_start_date
 Position Effective Start Date
Nullable true
Type DATETIME
Position Number
h_position_number
 Position Number
Nullable true
Type INTEGER
Size 11
Indexed true
Position Title
h_position_title
 Position Title
Nullable true
Type VARCHAR
Size 128
Professional Body
h_professional_body
 Simple List
Nullable true
Type VARCHAR
Size 128
Role
h_role
 Role
Nullable true
Type VARCHAR
Size 256
Staff Group
h_staff_group
 Group
Nullable true
Type VARCHAR
Size 160
Subjective Code
h_subjective_code
 Subjective Code
Nullable true
Type VARCHAR
Size 32
User Id
h_payroll_name
 Simple List
Nullable true
Type VARCHAR
Size 128
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document