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 Assignments Information

  • Article
  • 2 minutes to read

Details

Table ID: h_employee_employee_assignments

Stores employee assignment records

Table Attributes

Name Value
Primary Key h_id

Columns

Name & ID Description Column Attributes Relationships
Acting Up Start Date
h_acting_up_start_date
 This is the acting up start date
Nullable true
Type DATETIME
Actual Fte
h_actual_fte
 Actual full time employee
Nullable true
Type DECIMAL
Precision 38
Scale 15
Assignment Category
h_assignment_category
 Assignment Category
Nullable true
Type VARCHAR
Size 128
Assignment End Date
h_assignment_end_date
 This is the date assignment ends
Nullable true
Type DATETIME
Assignment Number
h_assignment_number
 Assignment Number
Nullable true
Type VARCHAR
Size 64
Indexed true
Assignment Start Date
h_assignment_start_date
 This is the date assignment starts
Nullable true
Type DATETIME
Assignment Status
h_assignment_status
 Assignment Status
Nullable true
Type VARCHAR
Size 128
Bank Post
h_bank_post
 Bank Post
Nullable true
Type VARCHAR
Size 32
Clinical Group
h_clinical_group
 Clinical Group
Nullable true
Type VARCHAR
Size 128
Continuous Service Date
h_continuous_service_date
 This is the date an employee started working with an NHS organisation
Nullable true
Type DATETIME
Contracted Hours
h_contracted_hours
 Contracted Hours
Nullable true
Type DECIMAL
Precision 38
Scale 15
Cost Centre
h_cost_centre
 Cost Centre
Nullable true
Type VARCHAR
Size 160
Department
h_department
 Department
Nullable true
Type VARCHAR
Size 160
Employee Number
h_employee_number
 Employee Number
Nullable true
Type INTEGER
Size 11
Fixed Term End Date
h_fixed_term_end_date
 This is the date fixed term ends
Nullable true
Type DATETIME
Fixed Terms End Reason
h_fixed_term_reason
 Fixed Terms End Reason
Nullable true
Type VARCHAR
Size 512
Frequency
h_frequency
 Frequency
Nullable true
Type VARCHAR
Size 128
Id
h_id
 The unique Id of the assignment
Primary Key true
Auto Increment true
Nullable false
Type INTEGER
Size 11
Increment Date
h_increment_date
 Increment Date
Nullable true
Type DATETIME
Pay Scale
h_payscale
 Pay Scale
Nullable true
Type VARCHAR
Size 128
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 256
Primary Assignment
h_primary_assignment
 Primary Assignment
Nullable true
Type VARCHAR
Size 2
Professional Registration Expiry Date
h_professional_registration_expiry_date
 Professional Registration Expiry Date
Nullable true
Type DATETIME
Professional Registration Number
h_professional_registration_number
 Professional Registration Number
Nullable true
Type VARCHAR
Size 16
Registration Membership Body
h_registration_membership_body
 Registration Membership Body
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 128
Supervisor Assignment Number
h_supervisor_assignment_number
 Supervisor Assignment Number
Nullable true
Type VARCHAR
Size 64
Indexed true
Supervisor Employee Number
h_supervisor_employee_number
 Supervisor Employee Number
Nullable true
Type INTEGER
Size 11
Supervisor Id
h_supervisor_id
 Supervisor Id
Nullable true
Type VARCHAR
Size 64
Indexed true
User Id
h_user_id
 Foreign key to relate this table to h_employee_employees table
Nullable true
Type VARCHAR
Size 64
Indexed true
One to One
Employees
h_employee_employees.h_user_id
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document