HiBob Tables and Scopes
The HiBob integration uses the following tables and scopes
Tables
HiBobCompanyDepartments
| Name | Type | Description |
|---|---|---|
| CompanyDepartmentId | string | A unique identifier for the department within the company |
| ID | integer | A numerical identifier for the record within the department table |
| Value | string | A value representing the department (e.g., a code or abbreviation) |
| Name | string | The name of the department (e.g., Human Resources, Engineering) |
| Archived | bit | A flag indicating whether the department is archived (1 for archived, 0 for active) |
| ConfigID | integer | A configuration identifier that might link the department to specific configurations or settings |
| BatchDate | datetime | The date and time when the record was last updated or processed in the system |
HiBobEmployeeHistory
| Name | Type | Description |
|---|---|---|
| EmployeeHistoryID | bigint | A unique identifier for the employee history record |
| ID | integer | A numerical identifier for the record within the employee history table |
| CanBeDeleted | bit | A flag indicating whether the employee history record can be deleted (1 for yes, 0 for no) |
| WeeklyHours | integer | The number of hours the employee works per week |
| Contract | string | The contract type associated with the employee (e.g., permanent, temporary) |
| CreationDate | datetime | The date and time when the employee history record was created |
| Type | string | The type of employee history (e.g., promotion, transfer, change in contract) |
| FlsaCode | string | The Fair Labor Standards Act (FLSA) code related to the employee's classification |
| CalendarName | string | The name of the calendar associated with the employee (e.g., fiscal year, work schedule) |
| IsCurrent | bit | A flag indicating whether the employee history record is the current record (1 for current, 0 for not) |
| ModificationDate | string | The date and time when the employee history record was last modified |
| WorkingPattern | string | The working pattern or schedule for the employee (e.g., full-time, part-time, shift pattern) |
| CalendarId | string | The calendar identifier associated with the employee's working schedule |
| SalaryPayType | string | The type of salary payment (e.g., hourly, monthly, annual) |
| Fte | integer | The full-time equivalent (FTE) value representing the employee's work commitment (e.g., 1 for full-time) |
| EndEffectiveDate | datetime | The date when the employee's work history ended or became effective |
| ActiveEffectiveDate | string | The date when the employee's current status became effective |
| StandardWorkingPattern | string | The standard working pattern or schedule the employee follows (e.g., 9-5, flex-time) |
| EffectiveDate | string | The effective date of the employee history record (e.g., date when changes were applied) |
| ConfigID | integer | The configuration identifier for the employee history record |
| BatchDate | datetime | The date and time when the employee history record was last processed or updated |
| EmployeeID | string | A unique identifier for the employee associated with this history record |
HiBobEmployees
| Name | Type | Description |
|---|---|---|
| EmployeeID | string | A unique identifier for the employee |
| ID | integer | A numerical identifier for the record within the employee table |
| string | The email address associated with the employee | |
| SurName | string | The surname or last name of the employee |
| FirstName | string | The first name of the employee |
| ConfigID | integer | The configuration identifier for the employee's data |
| BatchDate | datetime | The date and time when the employee record was last updated or processed in the system |
HiBobEmployeeTrainings
| Name | Type | Description |
|---|---|---|
| EmployeeTrainingID | integer | A unique identifier for the employee training record |
| ID | integer | A numerical identifier for the record within the employee training table |
| Reason | string | The reason for the training (e.g., required, voluntary, development) |
| EffectiveDate | string | The effective date when the training record becomes valid |
| Name | string | The name or title of the training course or program |
| Description | string | A description providing more details about the training |
| Status | string | The current status of the training (e.g., completed, in-progress, scheduled) |
| Frequency | string | The frequency at which the training occurs (e.g., one-time, annually, monthly) |
| StartDate | string | The start date of the training program or course |
| EndDate | string | The end date of the training program or course |
| DocumentId | integer | The unique identifier for the document associated with the training (e.g., certificate) |
| ConfigID | integer | The configuration identifier for the training record |
| BatchDate | datetime | The date and time when the employee training record was last updated or processed in the system |
HiBobEmployeeWorkHistory
| Name | Type | Description |
|---|---|---|
| EmployeeWorkHistoryID | bigint | A unique identifier for the employee work history record |
| ID | integer | A numerical identifier for the record within the employee work history table |
| CanBeDeleted | bit | A flag indicating whether the employee work history record can be deleted (1 for yes, 0 for no) |
| WorkChangeType | string | The type of work change (e.g., promotion, transfer, termination) |
| CreationDate | string | The date and time when the employee work history record was created |
| Title | string | The title or position the employee held during the work history record |
| IsCurrent | bit | A flag indicating whether the work history record is the current one (1 for current, 0 for not) |
| ModificationDate | string | The date and time when the employee work history record was last modified |
| Site | string | The site or location where the employee worked during the period of this work history |
| SiteId | integer | A unique identifier for the site where the employee worked |
| EndEffectiveDate | string | The date when the employee's work history ended or became effective |
| ActiveEffectiveDate | string | The date when the employee's current work history status became effective |
| Department | string | The department the employee worked in during the period of the work history |
| EffectiveDate | string | The effective date when the work history record was created or modified |
| ConfigID | integer | The configuration identifier for the employee work history record |
| BatchDate | datetime | The date and time when the employee work history record was last updated or processed |
| EmployeeID | string | A unique identifier for the employee associated with this work history record |
Scopes
Permission Scopes
| Permission Scopes |
|---|
| View Employee's Basic Info Section |
| View Employees Employment section histories |
| View Employee's Training History |
| View Employees' Employment section histories |
| View Company Configuration Settings |
Updated over 1 year ago
Learn more...
Did this page help you?