# HiBob schema ERD

Table and field reference for the Fivetran HiBob connector.

## Table & Field Reference

### employee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| manager | Unknown | FK |
| reports_to_id_in_company | Unknown | FK |
| second_level_manager | Unknown | FK |
| about | Unknown |  |
| actual_working_pattern | Unknown |  |
| address_1 | Unknown |  |
| address_2 | Unknown |  |
| adress_active_effective_date | Unknown |  |
| age | Unknown |  |
| age_risk_indicator | Unknown |  |
| at_risk_counter | Unknown |  |
| avatar | Unknown |  |
| avatar_url | Unknown |  |
| band_compa_ratio_ote | Unknown |  |
| band_max_ote | Unknown |  |
| band_mid_ote | Unknown |  |
| band_min_ote | Unknown |  |
| birth_date | Unknown |  |
| city | Unknown |  |
| company_car_amount | Unknown |  |
| company_id | Unknown |  |
| contract | Unknown |  |
| country | Unknown |  |
| cover_image_url | Unknown |  |
| creation_date_time | Unknown |  |
| current_active_status_start_date | Unknown |  |
| days_of_previous_service | Unknown |  |
| department | Unknown |  |
| direct_report | Unknown |  |
| display_name | Unknown |  |
| duration_of_employment | Unknown |  |
| eeo_job_category | Unknown |  |
| email | Unknown |  |
| employee_id_in_company | Unknown |  |
| employment_active_effective_date | Unknown |  |
| entitlement_lunch_voucher_amount | Unknown |  |
| ethnicity | Unknown |  |
| family_status | Unknown |  |
| financial_bank_name | Unknown |  |
| first_name | Unknown |  |
| food_preferences | Unknown |  |
| fte | Unknown |  |
| full_address | Unknown |  |
| full_name | Unknown |  |
| hobbies | Json |  |
| honorific | Unknown |  |
| hours_in_day_not_worked | Unknown |  |
| indirect_report | Unknown |  |
| is_manager | Unknown |  |
| is_manager_risk_indicator | Unknown |  |
| kids_risk_indicator | Unknown |  |
| legal_gender | Unknown |  |
| legal_sex | Unknown |  |
| lifecycle_status | Unknown |  |
| line_1 | Unknown |  |
| line_2 | Unknown |  |
| low_risk_counter | Unknown |  |
| manager_tenure_risk_indicator | Unknown |  |
| mobile_phone | Unknown |  |
| monthly_payment | Unknown |  |
| nationality | Unknown |  |
| num_of_direct_reports_risk_indicator | Unknown |  |
| num_with_same_title_risk_indicator | Unknown |  |
| number_of_kid | Unknown |  |
| original_start_date | Unknown |  |
| pay_frequency | Unknown |  |
| pay_period | Unknown |  |
| payment_currency | Unknown |  |
| post_code | Unknown |  |
| postal_code | Unknown |  |
| private_email | Unknown |  |
| probation_end_date | Unknown |  |
| recent_manager_change_risk_indicator | Unknown |  |
| reports_to | Unknown |  |
| salary_active_effective_date | Unknown |  |
| season_ticket_loan_amount | Unknown |  |
| second_name | Unknown |  |
| short_birth_date | Unknown |  |
| short_start_date | Unknown |  |
| site | Unknown |  |
| site_city | Unknown |  |
| site_country | Unknown |  |
| site_id | Unknown |  |
| site_state | Unknown |  |
| site_working_pattern | Unknown |  |
| some_risk_counter | Unknown |  |
| spouse_birth_date | Unknown |  |
| spouse_first_name | Unknown |  |
| spouse_gender | Unknown |  |
| spouse_short_birth_date | Unknown |  |
| spouse_surname | Unknown |  |
| ssn | Unknown |  |
| ssn_serial_number | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |
| superpowers | Unknown |  |
| surname | Unknown |  |
| team_recent_turnover_risk_indicator | Unknown |  |
| team_size_risk_indicator | Unknown |  |
| tenure_duration | Unknown |  |
| tenure_duration_year | Unknown |  |
| tenure_rank_risk_indicator | Unknown |  |
| tenure_year | Unknown |  |
| time_off_frequency_risk_indicator | Unknown |  |
| time_since_last_salary_change | Unknown |  |
| title | Unknown |  |
| usa_state | Unknown |  |
| veteran_status | Unknown |  |
| weekly_hour | Unknown |  |
| work_active_effective_date | Unknown |  |
| work_mobile | Unknown |  |
| work_phone | Unknown |  |
| yearly_payment | Unknown |  |
| years_of_service | Unknown |  |
| years_with_current_title_risk_indicator | Unknown |  |
| years_with_recent_salary_risk_indicator | Unknown |  |

### custom_table_column

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| custom_table_id | Unknown | PK, FK |
| list_id | Unknown | FK |
| description | Unknown |  |
| mandatory | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### custom_table

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |

### employee_custom_fields

| Column | Type | Keys |
| --- | --- | --- |
| field_name | Unknown | PK |
| employee_id | Unknown | PK, FK |
| field_value | Unknown |  |

### employee_custom_columns

| Column | Type | Keys |
| --- | --- | --- |
| column_name | Unknown | PK |
| employee_id | Unknown | PK, FK |
| column_value | Unknown |  |

### employee_employment_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| field_name | Unknown | PK |
| employee_id | Unknown | PK, FK |
| field_value | Unknown |  |

### employee_payroll_custom_column

| Column | Type | Keys |
| --- | --- | --- |
| column_name | Unknown | PK |
| employee_id | Unknown | PK, FK |
| column_value | Unknown |  |

### employee_salary_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| employee_id | Unknown | PK, FK |
| active_effective_date | Unknown |  |
| base_currency | String |  |
| base_value | Double |  |
| can_be_deleted | Unknown |  |
| change_changed_by | String |  |
| change_changed_by_id | String |  |
| change_reason | String |  |
| creation_date | Unknown |  |
| custom_columns | Json |  |
| effective_date | Unknown |  |
| end_effective_date | Unknown |  |
| is_current | Unknown |  |
| modification_date | Unknown |  |
| pay_frequency | String |  |
| pay_period | String |  |

### employee_training

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| employee_id | Unknown | PK, FK |
| cost_currency | String |  |
| cost_value | Double |  |
| description | String |  |
| document_id | String |  |
| effective_date | Unknown |  |
| end_date | Unknown |  |
| frequency | String |  |
| name | String |  |
| reason | String |  |
| start_date | Unknown |  |
| status | String |  |

### employee_out_of_office

| Column | Type | Keys |
| --- | --- | --- |
| request_id | String | PK |
| employee_id | String | PK, FK |
| date | Unknown |  |
| end_date | Unknown |  |
| end_portion | String |  |
| hours_on_date | Unknown |  |
| minutes | Unknown |  |
| policy_type | String |  |
| policy_type_display_name | String |  |
| start_date | Unknown |  |
| start_portion | String |  |
| status | String |  |
| type | String |  |

### employee_out_of_office_daily_duration

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| employee_out_of_office_detail_employee_id | Unknown | PK, FK |
| employee_out_of_office_detail_request_id | Unknown | PK, FK |
| cost | Unknown |  |
| day_duration | Json |  |

### employee_out_of_office_detail

| Column | Type | Keys |
| --- | --- | --- |
| employee_id | Unknown | PK, FK |
| request_id | Unknown | PK, FK |
| approved | Unknown |  |
| approved_at | Unknown |  |
| approved_by | Unknown |  |
| attachment_links | Json |  |
| created_on | LocalDateTime |  |
| decline_reason | Unknown |  |
| declined_at | Unknown |  |
| declined_by | Unknown |  |
| description | Unknown |  |
| duration_unit | Unknown |  |
| has_attachment | Unknown |  |
| original_request_id | Unknown |  |
| previous_request_id | Unknown |  |
| reason_code | Unknown |  |
| time_zone_offset | Unknown |  |
| total_cost | Unknown |  |
| total_duration | Unknown |  |
| visibility | Unknown |  |

### company_field

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| list_id | Unknown | FK |
| category | String |  |
| description | String |  |
| historical | Unknown |  |
| json_path | String |  |
| name | String |  |
| type | String |  |

### company_list

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |

### company

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_list_name | Unknown | PK, FK |
| archived | Unknown |  |
| children | Json |  |
| name | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### employment_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| employee_id | Unknown | PK, FK |
| active_effective_date | Unknown |  |
| calendar_id | String |  |
| calendar_name | String |  |
| can_be_deleted | Unknown |  |
| change_changed_by | String |  |
| change_changed_by_id | String |  |
| change_reason | String |  |
| contract | String |  |
| creation_date | Unknown |  |
| custom_columns | Json |  |
| effective_date | Unknown |  |
| end_effective_date | Unknown |  |
| flsa_code | String |  |
| fte | Unknown |  |
| is_current | Unknown |  |
| modification_date | Unknown |  |
| salary_pay_type | String |  |
| site_working_pattern_friday | Unknown |  |
| site_working_pattern_hours_per_day | Unknown |  |
| site_working_pattern_monday | Unknown |  |
| site_working_pattern_saturday | Unknown |  |
| site_working_pattern_sunday | Unknown |  |
| site_working_pattern_thursday | Unknown |  |
| site_working_pattern_tuesday | Unknown |  |
| site_working_pattern_wednesday | Unknown |  |
| site_working_pattern_working_pattern_type | String |  |
| type | String |  |
| weekly_hours | Unknown |  |
| working_pattern | String |  |

### employee_work_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| employee_id | Unknown | PK, FK |
| reports_to_id | String | FK |
| active_effective_date | Unknown |  |
| can_be_deleted | Unknown |  |
| change_changed_by | String |  |
| change_changed_by_id | String |  |
| change_reason | String |  |
| creation_date | Unknown |  |
| custom_columns | Json |  |
| department | String |  |
| effective_date | Unknown |  |
| end_effective_date | Unknown |  |
| is_current | Unknown |  |
| modification_date | Unknown |  |
| reports_to_display_name | String |  |
| reports_to_email | String |  |
| reports_to_first_name | String |  |
| reports_to_surname | String |  |
| site | String |  |
| site_id | Unknown |  |
| title | String |  |
| work_change_type | String |  |

### employee_life_cycle_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| employee_id | Unknown | PK, FK |
| can_be_deleted | Unknown |  |
| change_changed_by | String |  |
| change_changed_by_id | String |  |
| change_reason | String |  |
| creation_date | Unknown |  |
| custom_columns | Json |  |
| effective_date | Unknown |  |
| employee_status | String |  |
| end_effective_date | Unknown |  |
| is_current | Unknown |  |
| leave_reason | String |  |
| modification_date | Unknown |  |
| reason_type | String |  |
| status | String |  |

### employee_variable_payment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| employee_id | Unknown | PK, FK |
| amount_currency | String |  |
| amount_value | Double |  |
| company_percent | Double |  |
| department_percent | Double |  |
| effective_date | Unknown |  |
| individual_percent | Unknown |  |
| payment_period | String |  |
| reason | String |  |
| type | String |  |

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| description | String |  |
| set | String |  |
| title | String |  |

### employee_equity_grant

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| employee_id | Unknown | PK, FK |
| consent_number | String |  |
| effective_date | Unknown |  |
| equity_type | String |  |
| exercise_price_currency | String |  |
| exercise_price_value | Double |  |
| grant_date | Unknown |  |
| grant_number | Unknown |  |
| grant_status | String |  |
| grant_type | String |  |
| option_expiration | Unknown |  |
| quantity | Unknown |  |
| reason | String |  |
| vesting_commencement_date | Unknown |  |
| vesting_schedule | Unknown |  |
| vesting_term | String |  |

## Relationships

- employee(second_level_manager) → employee(id)
- employee(manager) → employee(id)
- employee(reports_to_id_in_company) → employee(id)
- custom_table_column(list_id) → company_list(name)
- custom_table_column(custom_table_id) → custom_table(id)
- employee_custom_fields(employee_id) → employee(id)
- employee_custom_columns(employee_id) → employee(id)
- employee_employment_custom_field(employee_id) → employee(id)
- employee_payroll_custom_column(employee_id) → employee(id)
- employee_salary_history(employee_id) → employee(id)
- employee_training(employee_id) → employee(id)
- employee_out_of_office(employee_id) → employee(id)
- employee_out_of_office_daily_duration(employee_out_of_office_detail_employee_id) → employee_out_of_office_detail(employee_id)
- employee_out_of_office_daily_duration(employee_out_of_office_detail_request_id) → employee_out_of_office_detail(request_id)
- employee_out_of_office_detail(request_id) → employee_out_of_office(request_id)
- employee_out_of_office_detail(employee_id) → employee_out_of_office(employee_id)
- company_field(list_id) → company_list(name)
- company(company_list_name) → company_list(name)
- employment_history(employee_id) → employee(id)
- employee_work_history(reports_to_id) → employee(id)
- employee_work_history(employee_id) → employee(id)
- employee_life_cycle_history(employee_id) → employee(id)
- employee_variable_payment(employee_id) → employee(id)
- employee_equity_grant(employee_id) → employee(id)