HiBob schema

10 tables · 6 joins

About the connector Start free

10 tables

Loading diagram…

employee

employee_employment_history

time_off

employee

343

id

string

full_name

string

about_avatar_value

string

display_name

string

work_reports_to_email_value

string

root_first_name_value

string

work_tenure_duration_years_value

double

about_food_preferences_value

string

work_site_value

string

employee_custom_fields

5

employee_id

string

field_name

string

field_value

string

field_human_readable_value

string

_weld_synced

date

employee_payroll_custom_column

5

employee_id

string

column_name

string

column_value

string

column_human_readable_value

string

_weld_synced

date

employee_employment_history

125

id

string

employee_id

string

effective_date

date

end_effective_date

date

active_effective_date

date

is_current

boolean

contract

string

type

string

salary_pay_type

string

flsa_code

string

employee_employment_history_custom_field

5

employee_id

string

employment_id

string

field_name

string

field_value

string

_weld_synced

date

employee_lifecycle_history

21

id

string

employee_id

string

can_be_deleted

boolean

work_change_type

string

change_reason

string

change_changed_by

string

change_changed_by_id

string

creation_date

string

is_current

boolean

modification_date

date

employee_work_history

24

id

string

employee_id

string

can_be_deleted

boolean

work_change_type

string

change_reason

string

change_changed_by

string

change_changed_by_id

string

reports_to_id

string

reports_to_first_name

string

reports_to_surname

string

entity_names

7

id

string

entity_type

string

name

string

value

string

archived

boolean

parent_id

string

_weld_synced

date

time_off

16

employee_id

string

policy_type_display_name

string

visibility

string

request_id

long

minutes

long

policy_type

string

employee_display_name

string

hours_on_date

double

type

string

timeoff_durations

7

employee_id

string

request_id

long

date

string

day_duration_hours

long

day_duration_minutes

long

day_duration_type

string

_weld_synced

date