Lever link
Lever is a Modern Recruiting Software that streamlines the hiring process and simplifies the Applicant Tracking System.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | ARCHIVE_REASON , FEEDBACK_FORM , NOTE , POSTING , POSTING_CONTENT_LIST , POSTING_TAG , PROFILE_FORM , REQUISITION , REQUISITION_FIELDS , REQUISITION_OFFER , REQUISITION_POSTING , STAGE and USER tables |
Custom data | check | REQUISITION table only |
Data blocking | check | Column level |
Column hashing | check | |
Re-sync | check | Connector level |
History | check | CANDIDATE_STAGE_HISTORY table and OPPORTUNITY_STAGE_HISTORY table only |
API configurable | check | API configuration |
Priority-first sync | ||
Fivetran data models | check | Get the models: source / transform |
Private networking |
Setup guidelink
Follow our step-by-step Lever setup guide to connect Lever with your destination using Fivetran connectors.
Sync overviewlink
To capture new records, we incrementally sync the OPPORTUNITY
table and the following child tables:
APPLICATION
CONTACT
CONTACT_EMAIL
CONTACT_LINK
CONTACT_PHONE
FEEDBACK_FORM
FEEDBACK_FORM_FIELD
FILE
INTERVIEW
INTERVIEW_FEEDBACK
INTERVIEW_USER
NOTE
NOTE_FIELD
OFFER
OFFER_FIELD
OPPORTUNITY_POSITION
OPPORTUNITY_SCHOOL
OPPORTUNITY_SOURCE
OPPORTUNITY_STAGE_HISTORY
OPPORTUNITY_TAG
PANELS
PANEL_APPLICATION
PANEL_INTERVIEW
POSTING_FORM
POSTING_FORM_FIELD
POSTING_INTERVIEW
PROFILE_FORM
PROFILE_FORM_FIELD
REFERRAL_FORM
REFERRAL_FORM_FIELD
RESUME
SCORE_CARD_SUB_FIELD
TEMPLATE_FIELD
We re-import the following tables once a day to capture updates and deletes:
USER
POSTING
STAGE
ARCHIVE REASON
Schema informationlink
This schema applies to Lever connectors that connect to the Opportunity endpoint.
To zoom, open the ERD in a new window.This schema applies to Lever connectors that still connect to the deprecated Candidate endpoint. We highly recommend that you switch to the Opportunity endpoint.
To zoom, open ERD in new window
UTC conversionlink
We don't convert source timestamps to Universal Time Coordinated (UTC) but use the Lever account's time zone or INSTANT data type to store the data in your destination.