Release Notes
June 2024
Effective June 10, 2024 we use a new June 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.
These schema changes are necessary because the source API was updated.
You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.75 total changes • 1 possible breaking changes
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
EMPLOYEE | |||||
column | Rename Column | active_effective_date | work_active_effective_date | We've renamed the column due to updates in the source. | |
column | New Column | actual_working_pattern | We've added a new column to the EMPLOYEE table. | ||
column | New Column | address_1 | We've added a new column to the EMPLOYEE table. | ||
column | New Column | address_2 | We've added a new column to the EMPLOYEE table. | ||
column | New Column | adress_active_effective_date | We've added a new column to the EMPLOYEE table. | ||
column | New Column | age | We've added a new column to the EMPLOYEE table. | ||
column | New Column | age_risk_indicator | We've added a new column to the EMPLOYEE table. | ||
column | New Column | at_risk_counter | We've added a new column to the EMPLOYEE table. | ||
column | New Column | avatar | We've added a new column to the EMPLOYEE table. | ||
column | New Column | birth_date | We've added a new column to the EMPLOYEE table. | ||
column | New Column | city | We've added a new column to the EMPLOYEE table. | ||
column | New Column | company_car_amount | We've added a new column to the EMPLOYEE table. | ||
column | New Column | contract | We've added a new column to the EMPLOYEE table. | ||
column | New Column | country | We've added a new column to the EMPLOYEE table. | ||
column | New Column | current_active_status_start_date | We've added a new column to the EMPLOYEE table. | ||
column | New Column | employment_active_effective_date | We've added a new column to the EMPLOYEE table. | ||
column | New Column | entitlement_lunch_voucher_amount | We've added a new column to the EMPLOYEE table. | ||
column | New Column | family_status | We've added a new column to the EMPLOYEE table. | ||
column | New Column | financial_bank_name | We've added a new column to the EMPLOYEE table. | ||
column | New Column | fte | We've added a new column to the EMPLOYEE table. | ||
column | New Column | full_address | We've added a new column to the EMPLOYEE table. | ||
column | New Column | honorific | We've added a new column to the EMPLOYEE table. | ||
column | New Column | hours_in_day_not_worked | We've added a new column to the EMPLOYEE table. | ||
column | New Column | is_manager_risk_indicator | We've added a new column to the EMPLOYEE table. | ||
column | New Column | kids_risk_indicator | We've added a new column to the EMPLOYEE table. | ||
column | New Column | legal_gender | We've added a new column to the EMPLOYEE table. | ||
column | New Column | lifecycle_status | We've added a new column to the EMPLOYEE table. | ||
column | New Column | line_1 | We've added a new column to the EMPLOYEE table. | ||
column | New Column | line_2 | We've added a new column to the EMPLOYEE table. | ||
column | New Column | low_risk_counter | We've added a new column to the EMPLOYEE table. | ||
column | New Column | manager_tenure_risk_indicator | We've added a new column to the EMPLOYEE table. | ||
column | New Column | mobile_phone | We've added a new column to the EMPLOYEE table. | ||
column | New Column | monthly_payment | We've added a new column to the EMPLOYEE table. | ||
column | New Column | nationality | We've added a new column to the EMPLOYEE table. | ||
column | New Column | num_of_direct_reports_risk_indicator | We've added a new column to the EMPLOYEE table. | ||
column | New Column | num_with_same_title_risk_indicator | We've added a new column to the EMPLOYEE table. | ||
column | New Column | number_of_kid | We've added a new column to the EMPLOYEE table. | ||
column | New Column | pay_frequency | We've added a new column to the EMPLOYEE table. | ||
column | New Column | pay_period | We've added a new column to the EMPLOYEE table. | ||
column | New Column | payment_currency | We've added a new column to the EMPLOYEE table. | ||
column | New Column | post_code | We've added a new column to the EMPLOYEE table. | ||
column | New Column | postal_code | We've added a new column to the EMPLOYEE table. | ||
column | New Column | private_email | We've added a new column to the EMPLOYEE table. | ||
column | New Column | probation_end_date | We've added a new column to the EMPLOYEE table. | ||
column | New Column | recent_manager_change_risk_indicator | We've added a new column to the EMPLOYEE table. | ||
column | New Column | salary_active_effective_date | We've added a new column to the EMPLOYEE table. | ||
column | New Column | season_ticket_loan_amount | We've added a new column to the EMPLOYEE table. | ||
column | New Column | short_birth_date | We've added a new column to the EMPLOYEE table. | ||
column | New Column | site_city | We've added a new column to the EMPLOYEE table. | ||
column | New Column | site_country | We've added a new column to the EMPLOYEE table. | ||
column | New Column | site_state | We've added a new column to the EMPLOYEE table. | ||
column | New Column | site_working_pattern | We've added a new column to the EMPLOYEE table. | ||
column | New Column | some_risk_counter | We've added a new column to the EMPLOYEE table. | ||
column | New Column | spouse_birth_date | We've added a new column to the EMPLOYEE table. | ||
column | New Column | spouse_first_name | We've added a new column to the EMPLOYEE table. | ||
column | New Column | spouse_gender | We've added a new column to the EMPLOYEE table. | ||
column | New Column | spouse_short_birth_date | We've added a new column to the EMPLOYEE table. | ||
column | New Column | spouse_surname | We've added a new column to the EMPLOYEE table. | ||
column | New Column | ssn | We've added a new column to the EMPLOYEE table. | ||
column | New Column | ssn_serial_number | We've added a new column to the EMPLOYEE table. | ||
column | New Column | status | We've added a new column to the EMPLOYEE table. | ||
column | New Column | team_recent_turnover_risk_indicator | We've added a new column to the EMPLOYEE table. | ||
column | New Column | team_size_risk_indicator | We've added a new column to the EMPLOYEE table. | ||
column | New Column | tenure_rank_risk_indicator | We've added a new column to the EMPLOYEE table. | ||
column | New Column | time_off_frequency_risk_indicator | We've added a new column to the EMPLOYEE table. | ||
column | New Column | time_since_last_salary_change | We've added a new column to the EMPLOYEE table. | ||
column | New Column | usa_state | We've added a new column to the EMPLOYEE table. | ||
column | New Column | veteran_status | We've added a new column to the EMPLOYEE table. | ||
column | New Column | weekly_hour | We've added a new column to the EMPLOYEE table. | ||
column | New Column | work_active_effective_date | We've added a new column to the EMPLOYEE table. | ||
column | New Column | work_mobile | We've added a new column to the EMPLOYEE table. | ||
column | New Column | work_phone | We've added a new column to the EMPLOYEE table. | ||
column | New Column | yearly_payment | We've added a new column to the EMPLOYEE table. | ||
column | New Column | years_with_current_title_risk_indicator | We've added a new column to the EMPLOYEE table. | ||
column | New Column | years_with_recent_salary_risk_indicator | We've added a new column to the EMPLOYEE table. |
Effective June 21, 2024 we use a new June 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.
We have removed tables to avoid data redundancy.
You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.2 total changes • 2 possible breaking changes
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
ONBOARDING_WIZARDS | |||||
table | Deprecated Table | ONBOARDING_WIZARDS | |||
PUBLIC_PROFILE | |||||
table | Deprecated Table | PUBLIC_PROFILE |
April 2024
Effective April 17, 2024 we use a new April 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.
We are making these schema changes because we updated the authentication method and HiBob deprecated the `PEOPLE` endpoint.
You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.235 total changes • 210 possible breaking changes
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
COMPANY_LIST_ITEM | |||||
table | Deprecated Table | COMPANY_LIST_ITEM | Data available in the `COMPANY` table. | ||
COMPANY_LIST_VALUE | |||||
table | Deprecated Table | COMPANY_LIST_VALUE | Data available in the `COMPANY` table. | ||
EMPLOYEE | |||||
column | Deprecated Column | about_about | We are deprecating this column because the corresponding table from the source has been deprecated. As a result, we are now utilizing the /people/search POST endpoint to retrieve employee data. | ||
column | Deprecated Column | about_avatar | |||
column | Deprecated Column | about_food_preferences | |||
column | Deprecated Column | about_social_data_facebook | |||
column | Deprecated Column | about_social_data_linkedin | |||
column | Deprecated Column | about_social_data_twitter | |||
column | Deprecated Column | address_active_effective_date | |||
column | Deprecated Column | address_city | |||
column | Deprecated Column | address_country | |||
column | Deprecated Column | address_full_address | |||
column | Deprecated Column | address_line_1 | |||
column | Deprecated Column | address_line_2 | |||
column | Deprecated Column | address_post_code | |||
column | Deprecated Column | address_site_address_1 | |||
column | Deprecated Column | address_site_address_2 | |||
column | Deprecated Column | address_site_city | |||
column | Deprecated Column | address_site_country | |||
column | Deprecated Column | address_site_postal_code | |||
column | Deprecated Column | address_site_state | |||
column | Deprecated Column | address_usa_state | |||
column | Deprecated Column | address_zip_code | |||
column | Deprecated Column | creation_date | |||
column | Deprecated Column | eeo_ethnicity | |||
column | Deprecated Column | eeo_job_category | |||
column | Deprecated Column | emergency_address | |||
column | Deprecated Column | emergency_city | |||
column | Deprecated Column | emergency_country | |||
column | Deprecated Column | emergency_email | |||
column | Deprecated Column | emergency_first_name | |||
column | Deprecated Column | emergency_mobile_phone | |||
column | Deprecated Column | emergency_phone | |||
column | Deprecated Column | emergency_post_code | |||
column | Deprecated Column | emergency_relation | |||
column | Deprecated Column | emergency_second_name | |||
column | Deprecated Column | emergency_surname | |||
column | Deprecated Column | employee_job_level_id | |||
column | Deprecated Column | employee_position_id | |||
column | Deprecated Column | financial_account_name | |||
column | Deprecated Column | financial_account_number | |||
column | Deprecated Column | financial_account_type | |||
column | Deprecated Column | financial_bank_account_type | |||
column | Deprecated Column | financial_bank_address | |||
column | Deprecated Column | financial_bank_name | |||
column | Deprecated Column | financial_iban | |||
column | Deprecated Column | financial_identification_number | |||
column | Deprecated Column | financial_passport_number | |||
column | Deprecated Column | financial_right_to_work_expiry_date | |||
column | Deprecated Column | financial_routing_number | |||
column | Deprecated Column | financial_sort_code | |||
column | Deprecated Column | financial_swift | |||
column | Deprecated Column | home_family_status | |||
column | Deprecated Column | home_legal_gender | |||
column | Deprecated Column | home_mobile_phone | |||
column | Deprecated Column | home_number_of_kid | |||
column | Deprecated Column | home_private_email | |||
column | Deprecated Column | home_private_phone | |||
column | Deprecated Column | home_spouse_birth_date | |||
column | Deprecated Column | home_spouse_first_name | |||
column | Deprecated Column | home_spouse_gender | |||
column | Deprecated Column | home_spouse_short_birth_date | |||
column | Deprecated Column | home_spouse_surname | |||
column | Deprecated Column | identification_ssn | |||
column | Deprecated Column | identification_ssn_serial_number | |||
column | Deprecated Column | internal_current_active_status_start_date | |||
column | Deprecated Column | internal_lifecycle_status | |||
column | Deprecated Column | internal_notice | |||
column | Deprecated Column | internal_period_since_termination | |||
column | Deprecated Column | internal_probation_end_date | |||
column | Deprecated Column | internal_status | |||
column | Deprecated Column | internal_termination_date | |||
column | Deprecated Column | internal_termination_reason | |||
column | Deprecated Column | internal_years_since_termination | |||
column | Deprecated Column | payroll_additional_pension_contribution | |||
column | Deprecated Column | payroll_deduction_childcare_vouchers_amount_currency | |||
column | Deprecated Column | payroll_deduction_childcare_vouchers_amount_value | |||
column | Deprecated Column | payroll_deduction_company_car_amount_currency | |||
column | Deprecated Column | payroll_deduction_company_car_amount_value | |||
column | Deprecated Column | payroll_deduction_cycle_to_work_amount_currency | |||
column | Deprecated Column | payroll_deduction_cycle_to_work_amount_value | |||
column | Deprecated Column | payroll_deduction_lunch_vouchers_amount_currency | |||
column | Deprecated Column | payroll_deduction_lunch_vouchers_amount_value | |||
column | Deprecated Column | payroll_deduction_season_ticket_loans_amount_currency | |||
column | Deprecated Column | payroll_deduction_season_ticket_loans_amount_value | |||
column | Deprecated Column | payroll_employment_active_effective_date | |||
column | Deprecated Column | payroll_employment_actual_working_pattern_friday | |||
column | Deprecated Column | payroll_employment_actual_working_pattern_hours_per_day | |||
column | Deprecated Column | payroll_employment_actual_working_pattern_monday | |||
column | Deprecated Column | payroll_employment_actual_working_pattern_saturday | |||
column | Deprecated Column | payroll_employment_actual_working_pattern_sunday | |||
column | Deprecated Column | payroll_employment_actual_working_pattern_thursday | |||
column | Deprecated Column | payroll_employment_actual_working_pattern_tuesday | |||
column | Deprecated Column | payroll_employment_actual_working_pattern_wednesday | |||
column | Deprecated Column | payroll_employment_actual_working_pattern_working_pattern_type | |||
column | Deprecated Column | payroll_employment_calendar_id | |||
column | Deprecated Column | payroll_employment_contract | |||
column | Deprecated Column | payroll_employment_flsa_code | |||
column | Deprecated Column | payroll_employment_fte | |||
column | Deprecated Column | payroll_employment_salary_pay_type | |||
column | Deprecated Column | payroll_employment_site_working_pattern_friday | |||
column | Deprecated Column | payroll_employment_site_working_pattern_hours_per_day | |||
column | Deprecated Column | payroll_employment_site_working_pattern_monday | |||
column | Deprecated Column | payroll_employment_site_working_pattern_saturday | |||
column | Deprecated Column | payroll_employment_site_working_pattern_sunday | |||
column | Deprecated Column | payroll_employment_site_working_pattern_thursday | |||
column | Deprecated Column | payroll_employment_site_working_pattern_tuesday | |||
column | Deprecated Column | payroll_employment_site_working_pattern_wednesday | |||
column | Deprecated Column | payroll_employment_site_working_pattern_working_pattern_type | |||
column | Deprecated Column | payroll_employment_type | |||
column | Deprecated Column | payroll_employment_weekly_hours | |||
column | Deprecated Column | payroll_employment_working_pattern | |||
column | Deprecated Column | payroll_entitlement_childcare_vouchers_amount_currency | |||
column | Deprecated Column | payroll_entitlement_childcare_vouchers_amount_value | |||
column | Deprecated Column | payroll_entitlement_company_car_amount_currency | |||
column | Deprecated Column | payroll_entitlement_company_car_amount_value | |||
column | Deprecated Column | payroll_entitlement_cycle_to_work_amount_currency | |||
column | Deprecated Column | payroll_entitlement_cycle_to_work_amount_value | |||
column | Deprecated Column | payroll_entitlement_lunch_vouchers_amount_currency | |||
column | Deprecated Column | payroll_entitlement_lunch_vouchers_amount_value | |||
column | Deprecated Column | payroll_entitlement_season_ticket_loans_amount_currency | |||
column | Deprecated Column | payroll_entitlement_season_ticket_loans_amount_value | |||
column | Deprecated Column | payroll_nin | |||
column | Deprecated Column | payroll_salary_active_effective_date | |||
column | Deprecated Column | payroll_salary_monthly_payment_currency | |||
column | Deprecated Column | payroll_salary_monthly_payment_value | |||
column | Deprecated Column | payroll_salary_pay_frequency | |||
column | Deprecated Column | payroll_salary_pay_period | |||
column | Deprecated Column | payroll_salary_payment_currency | |||
column | Deprecated Column | payroll_salary_payment_value | |||
column | Deprecated Column | payroll_salary_yearly_payment_currency | |||
column | Deprecated Column | payroll_salary_yearly_payment_value | |||
column | Deprecated Column | payroll_tax_code | |||
column | Deprecated Column | payroll_time_since_salary_change_humanize | |||
column | Deprecated Column | payroll_time_since_salary_change_period_iso | |||
column | Deprecated Column | payroll_time_since_salary_change_sort_factor | |||
column | Deprecated Column | payroll_variable_bonus_amount | |||
column | Deprecated Column | payroll_variable_bonus_company_percent | |||
column | Deprecated Column | payroll_variable_bonus_department_percent | |||
column | Deprecated Column | payroll_variable_bonus_individual_percent | |||
column | Deprecated Column | payroll_variable_bonus_payment_period | |||
column | Deprecated Column | payroll_variable_commission_amount | |||
column | Deprecated Column | payroll_variable_commission_company_percent | |||
column | Deprecated Column | payroll_variable_commission_department_percent | |||
column | Deprecated Column | payroll_variable_commission_individual_percent | |||
column | Deprecated Column | payroll_variable_commission_payment_period | |||
column | Deprecated Column | payroll_variable_executive_bonus_amount | |||
column | Deprecated Column | payroll_variable_executive_bonus_company_percent | |||
column | Deprecated Column | payroll_variable_executive_bonus_department_percent | |||
column | Deprecated Column | payroll_variable_executive_bonus_individual_percent | |||
column | Deprecated Column | payroll_variable_executive_bonus_payment_period | |||
column | Deprecated Column | people_analytics_age_risk_indicator | |||
column | Deprecated Column | people_analytics_at_risk_counter | |||
column | Deprecated Column | people_analytics_is_manager_risk_indicator | |||
column | Deprecated Column | people_analytics_kids_risk_indicator | |||
column | Deprecated Column | people_analytics_low_risk_counter | |||
column | Deprecated Column | people_analytics_manager_tenure_risk_indicator | |||
column | Deprecated Column | people_analytics_num_of_direct_reports_risk_indicator | |||
column | Deprecated Column | people_analytics_num_with_same_title_risk_indicator | |||
column | Deprecated Column | people_analytics_recent_manager_change_risk_indicator | |||
column | Deprecated Column | people_analytics_some_risk_counter | |||
column | Deprecated Column | people_analytics_team_recent_turnover_risk_indicator | |||
column | Deprecated Column | people_analytics_team_size_risk_indicator | |||
column | Deprecated Column | people_analytics_tenure_rank_risk_indicator | |||
column | Deprecated Column | people_analytics_time_off_frequency_risk_indicator | |||
column | Deprecated Column | people_analytics_years_with_current_title_risk_indicator | |||
column | Deprecated Column | people_analytics_years_with_recent_salary_risk_indicator | |||
column | Deprecated Column | personal_age | |||
column | Deprecated Column | personal_birth_date | |||
column | Deprecated Column | personal_communication_skype_username | |||
column | Deprecated Column | personal_communication_slack_username | |||
column | Deprecated Column | personal_honorific | |||
column | Deprecated Column | personal_pronouns | |||
column | Deprecated Column | personal_short_birth_date | |||
column | Deprecated Column | state | |||
column | Deprecated Column | work_active_effective_date | |||
column | Deprecated Column | work_days_of_previous_service | |||
column | Deprecated Column | work_department | |||
column | Deprecated Column | work_direct_reports | |||
column | Deprecated Column | work_duration_of_employment_humanize | |||
column | Deprecated Column | work_duration_of_employment_period_iso | |||
column | Deprecated Column | work_duration_of_employment_sort_factor | |||
column | Deprecated Column | work_employee_id_in_company | |||
column | Deprecated Column | work_indirect_reports | |||
column | Deprecated Column | work_is_manager | |||
column | Deprecated Column | work_manager | |||
column | Deprecated Column | work_reports_to_display_name | |||
column | Deprecated Column | work_reports_to_email | |||
column | Deprecated Column | work_reports_to_first_name | |||
column | Deprecated Column | work_reports_to_id | |||
column | Deprecated Column | work_reports_to_id_in_company | |||
column | Deprecated Column | work_reports_to_surname | |||
column | Deprecated Column | work_second_level_manager | |||
column | Deprecated Column | work_short_start_date | |||
column | Deprecated Column | work_site | |||
column | Deprecated Column | work_site_id | |||
column | Deprecated Column | work_start_date | |||
column | Deprecated Column | work_tenure_duration_humanize | |||
column | Deprecated Column | work_tenure_duration_period_iso | |||
column | Deprecated Column | work_tenure_duration_sort_factor | |||
column | Deprecated Column | work_tenure_duration_years | |||
column | Deprecated Column | work_tenure_years | |||
column | Deprecated Column | work_title | |||
column | Deprecated Column | work_work_mobile | |||
column | Deprecated Column | work_work_phone | |||
column | Deprecated Column | work_years_of_service | |||
column | New Column | about | |||
column | New Column | active_effective_date | |||
column | New Column | cover_image_url | |||
column | New Column | days_of_previous_service | |||
column | New Column | department | |||
column | New Column | direct_report | |||
column | New Column | duration_of_employment | |||
column | New Column | employee_id_in_company | |||
column | New Column | food_preferences | |||
column | New Column | hobbies | |||
column | New Column | indirect_report | |||
column | New Column | is_manager | |||
column | New Column | original_start_date | |||
column | New Column | reports_to | |||
column | New Column | reports_to_id_in_company | |||
column | New Column | short_start_date | |||
column | New Column | site | |||
column | New Column | site_id | |||
column | New Column | start_date | |||
column | New Column | superpowers | |||
column | New Column | tenure_duration | |||
column | New Column | tenure_duration_year | |||
column | New Column | tenure_year | |||
column | New Column | title | |||
column | New Column | years_of_service | |||
EMPLOYEE_HOBBY | |||||
table | Deprecated Table | EMPLOYEE_HOBBY | |||
EMPLOYEE_NATIONALITY | |||||
table | Deprecated Table | EMPLOYEE_NATIONALITY | |||
EMPLOYEE_SUPER_POWER | |||||
table | Deprecated Table | EMPLOYEE_SUPER_POWER | |||
POSITION_FIELD | |||||
table | Deprecated Table | POSITION_FIELD | We are deprecating this table because it does not provide significant value. |
January 2024
We have renamed the following tables:
EMPLYOEE_HOBBY
toEMPLOYEE_HOBBY
EMPLYOEE_NATIONALITY
toEMPLOYEE_NATIONALITY
EMPLYOEE_SUPER_POWER
toEMPLOYEE_SUPER_POWER
December 2023
We have added three new metadata tables:
COMPANY_LIST
CUSTOM_TABLE
POSITION_FIELD
July 2023
Lite connectors are now available for the following sources: