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