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 | 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. |
| History mode | check | CANDIDATE_STAGE_HISTORY and OPPORTUNITY_STAGE_HISTORY tables |
| Custom data | check | REQUISITION table only |
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | check | |
| Private networking | ||
| Authorization via API | check |
Supported deployment models
We support the SaaS and Hybrid deployment models for the connector.
You must have an Enterprise or Business Critical plan to use the Hybrid Deployment model.
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:
APPLICATIONCONTACTCONTACT_EMAILCONTACT_LINKCONTACT_PHONEFEEDBACK_FORMFEEDBACK_FORM_FIELDFILEINTERVIEWINTERVIEW_FEEDBACKINTERVIEW_USERNOTENOTE_FIELDOFFEROFFER_FIELDOPPORTUNITY_POSITIONOPPORTUNITY_SCHOOLOPPORTUNITY_SOURCEOPPORTUNITY_STAGE_HISTORYOPPORTUNITY_TAGPANELSPANEL_APPLICATIONPANEL_INTERVIEWPOSTING_FORMPOSTING_FORM_FIELDPOSTING_INTERVIEWPROFILE_FORMPROFILE_FORM_FIELDREFERRAL_FORMREFERRAL_FORM_FIELDRESUMESCORE_CARD_SUB_FIELDTEMPLATE_FIELD
We re-import the following tables once a day to capture updates and deletes:
ARCHIVE REASONPOSTINGSTAGEUSER
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 connections 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.