Release Noteslink
April 2024link
We have released a new April 2024 schema on April 17, 2024. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.
This schema change is required due to <REASON>. Connector admins should review the changes and update their downstream pipelines if necessary. Failing to do so may cause missing and/or incomplete data in your pipelines. 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.
This schema change is required due to <REASON>. Connector admins should review the changes and update their downstream pipelines if necessary. Failing to do so may cause missing and/or incomplete data in your pipelines. 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 | We are deprecating this table because we are combing it. | ||
COMPANY_LIST_VALUE | |||||
table | Deprecated Table | company_list_value | We are deprecating this table because we are combing it. | ||
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 2024link
We have renamed the following tables:
EMPLYOEE_NATIONALITY
toEMPLOYEE_NATIONALITY
EMPLYOEE_SUPER_POWER
toEMPLOYEE_SUPER_POWER
EMPLYOEE_HOBBY
toEMPLOYEE_HOBBY
December 2023link
We have added three new metadata tables:
COMPANY_LIST
CUSTOM_TABLE
POSITION_FIELD
July 2023link
Lite connectors are now available for the following sources: