HiBob

Explore the interactive ERD

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	PKFK
`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	PKFK
`field_value`	Unknown

employee_custom_columns

Column	Type	Keys
`column_name`	Unknown	PK
`employee_id`	Unknown	PKFK
`column_value`	Unknown

employee_employment_custom_field

Column	Type	Keys
`field_name`	Unknown	PK
`employee_id`	Unknown	PKFK
`field_value`	Unknown

employee_payroll_custom_column

Column	Type	Keys
`column_name`	Unknown	PK
`employee_id`	Unknown	PKFK
`column_value`	Unknown

employee_salary_history

Column	Type	Keys
`id`	String	PK
`employee_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`employee_out_of_office_detail_request_id`	Unknown	PKFK
`cost`	Unknown
`day_duration`	Json

employee_out_of_office_detail

Column	Type	Keys
`employee_id`	Unknown	PKFK
`request_id`	Unknown	PKFK
`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	PKFK
`archived`	Unknown
`children`	Json
`name`	Unknown
`type`	Unknown
`value`	Unknown

employment_history

Column	Type	Keys
`id`	String	PK
`employee_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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