Lever

Lever is a Modern Recruiting Software that streamlines the hiring process and simplifies the Applicant Tracking System.

Features

Feature Name	Supported	Notes
Capture deletes		`ARCHIVE_REASON`, `FEEDBACK_FORM`, `NOTE`, `POSTING`, `POSTING_CONTENT_LIST`, `POSTING_TAG`, `PROFILE_FORM` , `REQUISITION`, `REQUISITION_FIELDS`, `REQUISITION_OFFER`, `REQUISITION_POSTING`, `STAGE` and `USER` tables
History mode		`CANDIDATE_STAGE_HISTORY` and `OPPORTUNITY_STAGE_HISTORY` tables
Custom data		`REQUISITION` table only
Data blocking		Column level
Column hashing
Re-sync		Connector level
API configurable		API configuration
Priority-first sync
Fivetran data models		Get the models: source / transform; Supports Quickstart data models
Private networking
Authorization via API

Setup guide

Follow our step-by-step Lever setup guide to connect Lever with your destination using Fivetran connectors.

Sync overview

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 information

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

This schema applies to all Lever connectors created on or after July 27, 2024.

To zoom, open ERD in new window

UTC conversion

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.

Limitations

For connectors created after July 29, 2024, you can disable the option to sync confidential data.