Release Noteslink

---

February 2021link

We have added a new table, POSTING_DISTRIBUTION_CHANNEL, which contains your postings' distribution channel information. The POSTING_DISTRIBUTION_CHANNEL table is a child table of the POSTING table.

---

January 2021link

We have released a pre-built dbt package for Lever. Find the package in Fivetran's dbt hub. Learn more about our dbt integration in our dbt Transformations documentation.

---

July 2020link

We now support Lever's Opportunity endpoint. The Opportunity endpoint replaces the deprecated Candidate endpoint. In addition to our existing access, grant Fivetran access to the Opportunity endpoint in your Lever dashboard, then add the regenerated API key to the connector setup form in your Fivetran dashboard. Fivetran automatically triggers a historical sync when we connect to this endpoint, so you do not need to manually re-sync your data.

We have made some schema changes to support the new Opportunity endpoint. Once you connect Fivetran to the Opportunity endpoint, we will add new tables to replace the following tables:

• OPPORTUNITY will replace CANDIDATE
• CONTACT_EMAIL will replace CANDIDATE_EMAIL
• CONTACT_LINK will replace CANDIDATE_LINK
• CONTACT_PHONE will replace CANDIDATE_PHONE
• OPPORTUNITY_POSITION will replace CANDIDATE_POSITION
• OPPORTUNITY_SCHOOL will replace CANDIDATE_SCHOOL
• OPPORTUNITY_SOURCE will replace CANDIDATE_SOURCE
• OPPORTUNITY_STAGE_HISTORY will replace CANDIDATE_STAGE_HISTORY
• OPPORTUNITY_TAG will replace CANDIDATE_TAG

---

June 2020link

We have fixed a bug where deleted records were incorrectly synced to your destination. Previously, deleted rows had false as their _fivetran_deleted value, but they now have true as their _fivetran_deleted value. Any previously synced deleted records will be corrected in your next sync.

---

October 2019link

We now sync the REQUISITION table during every data sync. Previously, we synced this table every 24 hours.

In the REQUISITION table, we have converted the target_hire_date column's data type from TIMESTAMP to INSTANT.

We have added a new field, to_stage_index, to the CANDIDATE_STAGE_HISTORY table.

---

April 2019link

• We have added three new tables:

  • PANEL
  • PANEL_APPLICATION
  • PANEL_INTERVIEW

• We have changed the data types of head_count_total, head_count_hired and head_count_infinite from Integer to String in the REQUISITION table because Lever's API returns that data type as a String.

---

November 2018link

Lever is a modern recruiting software that streamlines the hiring process and simplifies the applicant tracking system.

Link to Lever Documentation