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

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