Lever (v1) | Stitch Documentation

Lever integration summary
Lever feature snapshot
Connecting Lever
Lever table reference

Lever is supported by the Singer community
This integration is powered by Singer's Lever tap. For support, visit the GitHub repo or join the Singer Slack.

Lever integration summary

Stitch’s Lever integration replicates data using the Lever API (v1). Refer to the Schema section for a list of objects available for replication.

Lever feature snapshot

A high-level look at Stitch's Lever (v1) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status	Released on June 1, 2020	Supported by	Singer Community
Stitch plan	Standard	API availability	Available
Singer GitHub repository	singer-io/tap-lever
REPLICATION SETTINGS
Anchor Scheduling	Supported	Advanced Scheduling	Supported
Table-level reset	Unsupported	Configurable Replication Methods	Unsupported
DATA SELECTION
Table selection	Supported	Column selection	Supported
Select all	Supported
TRANSPARENCY
Extraction Logs	Supported	Loading Reports	Supported

Connecting Lever

Lever setup requirements

To set up Lever in Stitch, you need:

Super Admin privileges. Your role in Lever must be Super Admin in order to obtain an API Key.

Step 1: Obtain your API token

Login to your Lever account.
Hover over your account icon in the upper right corner of the page and click Settings.
On the settings page, click API Credentials.
On the API Credentials page, locate the Generate New Key link in the Lever API credentials section.
If you would like your key to access confidential information, click on the Allow access to confidential data toggle. If not, skip to the next step.
Click Done.

Keep your API key readily available for the next step.

Note: Once you save your API key, you cannot change its access settings. You’ll need to generate a new API key to change access settings.

Step 2: Add Lever as a Stitch data source

Sign into your Stitch account.
On the Stitch Dashboard page, click the Add Integration button.
Click the Lever icon.
Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

For example, the name “Stitch Lever” would create a schema called stitch_lever in the destination. Note: Schema names cannot be changed after you save the integration.
In the Token field, paste the API Key you obtained in Step 1.

Step 3: Define the historical replication start date

The Sync Historical Data setting defines the starting date for your Lever integration. This means that data equal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to replicate data beyond Lever’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.

Step 4: Create a replication schedule

Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the Replication Scheduling documentation for more information.

In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

Lever integrations support the following replication scheduling methods:

Replication Frequency
Anchor Scheduling
Advanced Scheduling using Cron (Advanced or Premium plans only)

To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 5: Set objects to replicate

Is an object missing or not replicating? Verify that the object meets the requirements for selection and replication.

The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.

Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.

For Lever integrations, you can select:

Individual tables and columns
All tables and columns

Click the tabs to view instructions for each selection method.

In the integration’s Tables to Replicate tab, locate a table you want to replicate.
To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.
To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.
Repeat this process for all the tables and columns you want to replicate.
When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.

Important: Using the Select All feature will overwrite any previous selections. However, selections aren’t final until Finalize Your Selections is clicked. Clicking Cancel will restore your previous selections. Refer to the Select All guide for more info about this feature.

Click into the integration from the Stitch Dashboard page.
Click the Tables to Replicate tab.
In the list of tables, click the box next to the Table Names column.
In the menu that displays, click Track all Tables and Fields:
Click the Finalize Your Selections button at the bottom of the page to save your data selections.

Initial and historical replication jobs

After you finish setting up Lever, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.

Initial replication jobs with Anchor Scheduling

If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.

Replication will continue after the seven days are over. If you’re no longer interested in this source, be sure to pause or delete the integration to prevent unwanted usage.

Lever table reference

Schemas and versioning

Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.

The schema and info displayed below is for version 1 of this integration.

This is the latest version of the Lever integration.

Table and column names in your destination

Depending on your destination, table and column names may not appear as they are outlined below.

For example: Object names are lowercased in Redshift (CusTomERs > customers), while case is maintained in PostgreSQL destinations (CusTomERs > CusTomERs). Refer to the Loading Guide for your destination for more info.

archive_reasons

The archive_reasons table contains info about the reasons candidates have exited your active hiring pipeline. Refer to Lever’s documentation for more info.

Replication Method

Full Table

Primary Key

Useful links

Lever documentation

archive_reasons schema on GitHub

Lever API method

archive_reasons table foreign keys

Join archive_reasons with	on
candidate_applications	archive_reasons.id = candidate_applications.archived.reason
candidates	archive_reasons.id = candidates.archived.reason
opportunity_applications	archive_reasons.id = opportunity_applications.archived.reason
opportunities	archive_reasons.id = opportunities.archived.reason

archive_reasons table schema

STRING

text

STRING

candidate_applications

The candidate_applications table contains info about candidate applications in your Lever account.

Replication Method

Key-based Incremental

Primary Key

Useful links

Lever documentation

candidate_applications schema on GitHub

Lever API method

candidate_applications table foreign keys

Join candidate_applications with	on
archive_reasons	candidate_applications.archived.reason = archive_reasons.id
candidates	candidate_applications.archived.reason = candidates.archived.reason candidate_applications.id = candidates.applications candidate_applications.candidateId = candidates.id candidate_applications.postingHiringManager = candidates.followers candidate_applications.postingOwner = candidates.followers candidate_applications.requisitionForHire.hiringManagerOnHire = candidates.followers candidate_applications.user = candidates.followers candidate_applications.postingHiringManager = candidates.owner candidate_applications.postingOwner = candidates.owner candidate_applications.requisitionForHire.hiringManagerOnHire = candidates.owner candidate_applications.user = candidates.owner candidate_applications.postingHiringManager = candidates.stageChanges.userId candidate_applications.postingOwner = candidates.stageChanges.userId candidate_applications.requisitionForHire.hiringManagerOnHire = candidates.stageChanges.userId candidate_applications.user = candidates.stageChanges.userId
opportunity_applications	candidate_applications.archived.reason = opportunity_applications.archived.reason candidate_applications.id = opportunity_applications.id candidate_applications.candidateId = opportunity_applications.candidateId candidate_applications.posting = opportunity_applications.posting candidate_applications.requisitionForHire.id = opportunity_applications.requisitionForHire.id candidate_applications.postingHiringManager = opportunity_applications.postingHiringManager candidate_applications.postingOwner = opportunity_applications.postingHiringManager candidate_applications.requisitionForHire.hiringManagerOnHire = opportunity_applications.postingHiringManager candidate_applications.user = opportunity_applications.postingHiringManager candidate_applications.postingHiringManager = opportunity_applications.postingOwner candidate_applications.postingOwner = opportunity_applications.postingOwner candidate_applications.requisitionForHire.hiringManagerOnHire = opportunity_applications.postingOwner candidate_applications.user = opportunity_applications.postingOwner candidate_applications.postingHiringManager = opportunity_applications.requisitionForHire.hiringManagerOnHire candidate_applications.postingOwner = opportunity_applications.requisitionForHire.hiringManagerOnHire candidate_applications.requisitionForHire.hiringManagerOnHire = opportunity_applications.requisitionForHire.hiringManagerOnHire candidate_applications.user = opportunity_applications.requisitionForHire.hiringManagerOnHire candidate_applications.postingHiringManager = opportunity_applications.user candidate_applications.postingOwner = opportunity_applications.user candidate_applications.requisitionForHire.hiringManagerOnHire = opportunity_applications.user candidate_applications.user = opportunity_applications.user
opportunities	candidate_applications.archived.reason = opportunities.archived.reason candidate_applications.id = opportunities.applications candidate_applications.candidateId = opportunities.id candidate_applications.postingHiringManager = opportunities.followers candidate_applications.postingOwner = opportunities.followers candidate_applications.requisitionForHire.hiringManagerOnHire = opportunities.followers candidate_applications.user = opportunities.followers candidate_applications.postingHiringManager = opportunities.owner candidate_applications.postingOwner = opportunities.owner candidate_applications.requisitionForHire.hiringManagerOnHire = opportunities.owner candidate_applications.user = opportunities.owner candidate_applications.postingHiringManager = opportunities.stageChanges.userId candidate_applications.postingOwner = opportunities.stageChanges.userId candidate_applications.requisitionForHire.hiringManagerOnHire = opportunities.stageChanges.userId candidate_applications.user = opportunities.stageChanges.userId
opportunity_offers	candidate_applications.candidateId = opportunity_offers.opportunityId candidate_applications.posting = opportunity_offers.posting candidate_applications.postingHiringManager = opportunity_offers.creator candidate_applications.postingOwner = opportunity_offers.creator candidate_applications.requisitionForHire.hiringManagerOnHire = opportunity_offers.creator candidate_applications.user = opportunity_offers.creator
postings	candidate_applications.posting = postings.id candidate_applications.postingHiringManager = postings.followers candidate_applications.postingOwner = postings.followers candidate_applications.requisitionForHire.hiringManagerOnHire = postings.followers candidate_applications.user = postings.followers candidate_applications.postingHiringManager = postings.hiringManager candidate_applications.postingOwner = postings.hiringManager candidate_applications.requisitionForHire.hiringManagerOnHire = postings.hiringManager candidate_applications.user = postings.hiringManager candidate_applications.postingHiringManager = postings.owner candidate_applications.postingOwner = postings.owner candidate_applications.requisitionForHire.hiringManagerOnHire = postings.owner candidate_applications.user = postings.owner candidate_applications.postingHiringManager = postings.user candidate_applications.postingOwner = postings.user candidate_applications.requisitionForHire.hiringManagerOnHire = postings.user candidate_applications.user = postings.user
requisitions	candidate_applications.posting = requisitions.postings candidate_applications.requisitionForHire.id = requisitions.id candidate_applications.postingHiringManager = requisitions.creator candidate_applications.postingOwner = requisitions.creator candidate_applications.requisitionForHire.hiringManagerOnHire = requisitions.creator candidate_applications.user = requisitions.creator candidate_applications.postingHiringManager = requisitions.hiringManager candidate_applications.postingOwner = requisitions.hiringManager candidate_applications.requisitionForHire.hiringManagerOnHire = requisitions.hiringManager candidate_applications.user = requisitions.hiringManager candidate_applications.postingHiringManager = requisitions.owner candidate_applications.postingOwner = requisitions.owner candidate_applications.requisitionForHire.hiringManagerOnHire = requisitions.owner candidate_applications.user = requisitions.owner
candidate_offers	candidate_applications.postingHiringManager = candidate_offers.creator candidate_applications.postingOwner = candidate_offers.creator candidate_applications.requisitionForHire.hiringManagerOnHire = candidate_offers.creator candidate_applications.user = candidate_offers.creator
candidate_referrals	candidate_applications.postingHiringManager = candidate_referrals.referrer candidate_applications.postingOwner = candidate_referrals.referrer candidate_applications.requisitionForHire.hiringManagerOnHire = candidate_referrals.referrer candidate_applications.user = candidate_referrals.referrer candidate_applications.postingHiringManager = candidate_referrals.user candidate_applications.postingOwner = candidate_referrals.user candidate_applications.requisitionForHire.hiringManagerOnHire = candidate_referrals.user candidate_applications.user = candidate_referrals.user
opportunity_referrals	candidate_applications.postingHiringManager = opportunity_referrals.referrer candidate_applications.postingOwner = opportunity_referrals.referrer candidate_applications.requisitionForHire.hiringManagerOnHire = opportunity_referrals.referrer candidate_applications.user = opportunity_referrals.referrer candidate_applications.postingHiringManager = opportunity_referrals.user candidate_applications.postingOwner = opportunity_referrals.user candidate_applications.requisitionForHire.hiringManagerOnHire = opportunity_referrals.user candidate_applications.user = opportunity_referrals.user

candidate_applications table schema

candidateId

STRING

createdAt

NUMBER

email

STRING

name

STRING

posting

STRING

type

STRING

user

STRING

candidate_offers

The candidate_offers table contains data sent to candidates about opportunities via Lever’s Offers feature.

Replication Method

Key-based Incremental

Primary Key

Useful links

Lever documentation

candidate_offers schema on GitHub

Lever API method

candidate_offers table foreign keys

Join candidate_offers with	on
opportunity_offers	candidate_offers.id = opportunity_offers.id candidate_offers.creator = opportunity_offers.creator
requisitions	candidate_offers.id = requisitions.offerIds candidate_offers.creator = requisitions.creator candidate_offers.creator = requisitions.hiringManager candidate_offers.creator = requisitions.owner
candidate_applications	candidate_offers.creator = candidate_applications.postingHiringManager candidate_offers.creator = candidate_applications.postingOwner candidate_offers.creator = candidate_applications.requisitionForHire.hiringManagerOnHire candidate_offers.creator = candidate_applications.user
candidate_referrals	candidate_offers.creator = candidate_referrals.referrer candidate_offers.creator = candidate_referrals.user
candidates	candidate_offers.creator = candidates.followers candidate_offers.creator = candidates.owner candidate_offers.creator = candidates.stageChanges.userId
opportunities	candidate_offers.creator = opportunities.followers candidate_offers.creator = opportunities.owner candidate_offers.creator = opportunities.stageChanges.userId
opportunity_applications	candidate_offers.creator = opportunity_applications.postingHiringManager candidate_offers.creator = opportunity_applications.postingOwner candidate_offers.creator = opportunity_applications.requisitionForHire.hiringManagerOnHire candidate_offers.creator = opportunity_applications.user
opportunity_referrals	candidate_offers.creator = opportunity_referrals.referrer candidate_offers.creator = opportunity_referrals.user
postings	candidate_offers.creator = postings.followers candidate_offers.creator = postings.hiringManager candidate_offers.creator = postings.owner candidate_offers.creator = postings.user

candidate_offers table schema

approvedAt

DATE-TIME

createdAt

DATE-TIME

creator

STRING

fields

ARRAY

Click to expand fields

identifier

STRING

text

STRING

value

STRING

sentAt

DATE-TIME

signatures

OBJECT

Click to expand signatures

email

STRING

firstOpenedAt

DATE-TIME

lastOpenedAt

DATE-TIME

name

STRING

role

STRING

signed

BOOLEAN

signedAt

DATE-TIME

status

STRING

candidate_referrals

The candidate_referrals table contains info about the referrals in your Lever account.

Replication Method

Key-based Incremental

Primary Key

Useful links

Lever documentation

candidate_referrals schema on GitHub

Lever API method

candidate_referrals table foreign keys

Join candidate_referrals with	on
opportunity_referrals	candidate_referrals.id = opportunity_referrals.id candidate_referrals.referrer = opportunity_referrals.referrer candidate_referrals.user = opportunity_referrals.referrer candidate_referrals.referrer = opportunity_referrals.user candidate_referrals.user = opportunity_referrals.user
candidate_applications	candidate_referrals.referrer = candidate_applications.postingHiringManager candidate_referrals.user = candidate_applications.postingHiringManager candidate_referrals.referrer = candidate_applications.postingOwner candidate_referrals.user = candidate_applications.postingOwner candidate_referrals.referrer = candidate_applications.requisitionForHire.hiringManagerOnHire candidate_referrals.user = candidate_applications.requisitionForHire.hiringManagerOnHire candidate_referrals.referrer = candidate_applications.user candidate_referrals.user = candidate_applications.user
candidate_offers	candidate_referrals.referrer = candidate_offers.creator candidate_referrals.user = candidate_offers.creator
candidates	candidate_referrals.referrer = candidates.followers candidate_referrals.user = candidates.followers candidate_referrals.referrer = candidates.owner candidate_referrals.user = candidates.owner candidate_referrals.referrer = candidates.stageChanges.userId candidate_referrals.user = candidates.stageChanges.userId
opportunities	candidate_referrals.referrer = opportunities.followers candidate_referrals.user = opportunities.followers candidate_referrals.referrer = opportunities.owner candidate_referrals.user = opportunities.owner candidate_referrals.referrer = opportunities.stageChanges.userId candidate_referrals.user = opportunities.stageChanges.userId
opportunity_applications	candidate_referrals.referrer = opportunity_applications.postingHiringManager candidate_referrals.user = opportunity_applications.postingHiringManager candidate_referrals.referrer = opportunity_applications.postingOwner candidate_referrals.user = opportunity_applications.postingOwner candidate_referrals.referrer = opportunity_applications.requisitionForHire.hiringManagerOnHire candidate_referrals.user = opportunity_applications.requisitionForHire.hiringManagerOnHire candidate_referrals.referrer = opportunity_applications.user candidate_referrals.user = opportunity_applications.user
opportunity_offers	candidate_referrals.referrer = opportunity_offers.creator candidate_referrals.user = opportunity_offers.creator
postings	candidate_referrals.referrer = postings.followers candidate_referrals.user = postings.followers candidate_referrals.referrer = postings.hiringManager candidate_referrals.user = postings.hiringManager candidate_referrals.referrer = postings.owner candidate_referrals.user = postings.owner candidate_referrals.referrer = postings.user candidate_referrals.user = postings.user
requisitions	candidate_referrals.referrer = requisitions.creator candidate_referrals.user = requisitions.creator candidate_referrals.referrer = requisitions.hiringManager candidate_referrals.user = requisitions.hiringManager candidate_referrals.referrer = requisitions.owner candidate_referrals.user = requisitions.owner

candidate_referrals table schema

baseTemplateId

STRING

completedAt

DATE-TIME

createdAt

DATE-TIME

fields

ARRAY

Click to expand fields

description

STRING

options

ARRAY

Click to expand options

text

STRING

prompt

STRING

required

BOOLEAN

text

STRING

type

STRING

value

STRING

instructions

STRING

referrer

STRING

stage

STRING

text

STRING

type

STRING

user

STRING

candidate_resumes

The candidate_resumes table contains info about candidate resumes.

Replication Method

Key-based Incremental

Primary Key

Useful links

Lever documentation

candidate_resumes schema on GitHub

Lever API method

candidate_resumes table foreign keys

Join candidate_resumes with	on
opportunity_resumes	candidate_resumes.id = opportunity_resumes.id

candidate_resumes table schema

createdAt

DATE-TIME

file

OBJECT

STRING

parsedData

OBJECT

candidates

The candidates table contains info about candidates, or individuals who’ve been added to your Lever account as potential fits for job opportunities.

Note: This table must be set to replicate in order to replicate the candidate_applications, candidate_offers, candidate_referrals, and candidate_resumes tables.

During Extraction, this table will be replicated before any other selected candidate_* tables. Then, for every candidate, Stitch will query for every candidate’s applications, offers, referrals, and resumes.

For example: During Extraction, Stitch replicates a candidate with id: 12345 from Lever’s /candidates endpoint.

Using id: 12345, Stitch will then query for the rest of the candidate’s data:

/candidates/12345/applications
/candidates/12345/offers
/candidates/12345/referrals
/candidates/12345/resumes

Replication Method

Key-based Incremental

Primary Key

Useful links

Lever documentation

candidates schema on GitHub

Lever API method

candidates table foreign keys

Join candidates with	on
archive_reasons	candidates.archived.reason = archive_reasons.id
candidate_applications	candidates.archived.reason = candidate_applications.archived.reason candidates.applications = candidate_applications.id candidates.id = candidate_applications.candidateId candidates.followers = candidate_applications.postingHiringManager candidates.owner = candidate_applications.postingHiringManager candidates.stageChanges.userId = candidate_applications.postingHiringManager candidates.followers = candidate_applications.postingOwner candidates.owner = candidate_applications.postingOwner candidates.stageChanges.userId = candidate_applications.postingOwner candidates.followers = candidate_applications.requisitionForHire.hiringManagerOnHire candidates.owner = candidate_applications.requisitionForHire.hiringManagerOnHire candidates.stageChanges.userId = candidate_applications.requisitionForHire.hiringManagerOnHire candidates.followers = candidate_applications.user candidates.owner = candidate_applications.user candidates.stageChanges.userId = candidate_applications.user
opportunity_applications	candidates.archived.reason = opportunity_applications.archived.reason candidates.applications = opportunity_applications.id candidates.id = opportunity_applications.candidateId candidates.followers = opportunity_applications.postingHiringManager candidates.owner = opportunity_applications.postingHiringManager candidates.stageChanges.userId = opportunity_applications.postingHiringManager candidates.followers = opportunity_applications.postingOwner candidates.owner = opportunity_applications.postingOwner candidates.stageChanges.userId = opportunity_applications.postingOwner candidates.followers = opportunity_applications.requisitionForHire.hiringManagerOnHire candidates.owner = opportunity_applications.requisitionForHire.hiringManagerOnHire candidates.stageChanges.userId = opportunity_applications.requisitionForHire.hiringManagerOnHire candidates.followers = opportunity_applications.user candidates.owner = opportunity_applications.user candidates.stageChanges.userId = opportunity_applications.user
opportunities	candidates.archived.reason = opportunities.archived.reason candidates.applications = opportunities.applications candidates.contact = opportunities.contact candidates.id = opportunities.id candidates.stage = opportunities.stage candidates.stageChanges.toStageId = opportunities.stage candidates.stage = opportunities.stageChanges.toStageId candidates.stageChanges.toStageId = opportunities.stageChanges.toStageId candidates.followers = opportunities.followers candidates.owner = opportunities.followers candidates.stageChanges.userId = opportunities.followers candidates.followers = opportunities.owner candidates.owner = opportunities.owner candidates.stageChanges.userId = opportunities.owner candidates.followers = opportunities.stageChanges.userId candidates.owner = opportunities.stageChanges.userId candidates.stageChanges.userId = opportunities.stageChanges.userId
opportunity_offers	candidates.id = opportunity_offers.opportunityId candidates.followers = opportunity_offers.creator candidates.owner = opportunity_offers.creator candidates.stageChanges.userId = opportunity_offers.creator
stages	candidates.stage = stages.id candidates.stageChanges.toStageId = stages.id
candidate_offers	candidates.followers = candidate_offers.creator candidates.owner = candidate_offers.creator candidates.stageChanges.userId = candidate_offers.creator
candidate_referrals	candidates.followers = candidate_referrals.referrer candidates.owner = candidate_referrals.referrer candidates.stageChanges.userId = candidate_referrals.referrer candidates.followers = candidate_referrals.user candidates.owner = candidate_referrals.user candidates.stageChanges.userId = candidate_referrals.user
opportunity_referrals	candidates.followers = opportunity_referrals.referrer candidates.owner = opportunity_referrals.referrer candidates.stageChanges.userId = opportunity_referrals.referrer candidates.followers = opportunity_referrals.user candidates.owner = opportunity_referrals.user candidates.stageChanges.userId = opportunity_referrals.user
postings	candidates.followers = postings.followers candidates.owner = postings.followers candidates.stageChanges.userId = postings.followers candidates.followers = postings.hiringManager candidates.owner = postings.hiringManager candidates.stageChanges.userId = postings.hiringManager candidates.followers = postings.owner candidates.owner = postings.owner candidates.stageChanges.userId = postings.owner candidates.followers = postings.user candidates.owner = postings.user candidates.stageChanges.userId = postings.user
requisitions	candidates.followers = requisitions.creator candidates.owner = requisitions.creator candidates.stageChanges.userId = requisitions.creator candidates.followers = requisitions.hiringManager candidates.owner = requisitions.hiringManager candidates.stageChanges.userId = requisitions.hiringManager candidates.followers = requisitions.owner candidates.owner = requisitions.owner candidates.stageChanges.userId = requisitions.owner

candidates table schema

applications

ARRAY

archived

OBJECT

Click to expand archived

archivedAt

DATE-TIME

reason

STRING

contact

STRING

createdAt

DATE-TIME

dataProtection

OBJECT

emails

ARRAY

followers

ARRAY

headline

STRING

isAnonymized

BOOLEAN

lastAdvancedAt

DATE-TIME

lastInteractionAt

DATE-TIME

links

ARRAY

location

STRING

name

STRING

origin

STRING

owner

STRING

phones

ARRAY

Click to expand phones

type

STRING

value

STRING

resume

OBJECT

snoozedUntil

DATE-TIME

sources

ARRAY

stage

STRING

stageChanges

ARRAY

tags

ARRAY

urls

OBJECT

opportunities

The opportunities table contains info about opportunities. In Lever, an opportunity represents each of an individual candidate’s unique candidacies or journeys through your hiring pipeline for a position. A candidate can be associated with multiple opportunities.

Note: This table must be set to replicate in order to replicate the opportunity_applications, opportunity_offers, opportunity_referrals, and opportunity_resumes tables.

During Extraction, this table will be replicated before any other selected opportunity_* tables. Then, for every opportunity, Stitch will query for every opportunity’s applications, offers, referrals, and resumes.

For example: During Extraction, Stitch replicates an opportunity with id: 12345 from Lever’s /opportunities endpoint.

Using id: 12345, Stitch will then query for the rest of the opportunity’s data:

/opportunities/12345/applications
/opportunities/12345/offers
/opportunities/12345/referrals
/opportunities/12345/resumes

Replication Method

Key-based Incremental

Primary Key

Useful links

Lever documentation

opportunities schema on GitHub

Lever API method

opportunities table foreign keys

Join opportunities with	on
archive_reasons	opportunities.archived.reason = archive_reasons.id
candidate_applications	opportunities.archived.reason = candidate_applications.archived.reason opportunities.applications = candidate_applications.id opportunities.id = candidate_applications.candidateId opportunities.followers = candidate_applications.postingHiringManager opportunities.owner = candidate_applications.postingHiringManager opportunities.stageChanges.userId = candidate_applications.postingHiringManager opportunities.followers = candidate_applications.postingOwner opportunities.owner = candidate_applications.postingOwner opportunities.stageChanges.userId = candidate_applications.postingOwner opportunities.followers = candidate_applications.requisitionForHire.hiringManagerOnHire opportunities.owner = candidate_applications.requisitionForHire.hiringManagerOnHire opportunities.stageChanges.userId = candidate_applications.requisitionForHire.hiringManagerOnHire opportunities.followers = candidate_applications.user opportunities.owner = candidate_applications.user opportunities.stageChanges.userId = candidate_applications.user
candidates	opportunities.archived.reason = candidates.archived.reason opportunities.applications = candidates.applications opportunities.contact = candidates.contact opportunities.id = candidates.id opportunities.stage = candidates.stage opportunities.stageChanges.toStageId = candidates.stage opportunities.stage = candidates.stageChanges.toStageId opportunities.stageChanges.toStageId = candidates.stageChanges.toStageId opportunities.followers = candidates.followers opportunities.owner = candidates.followers opportunities.stageChanges.userId = candidates.followers opportunities.followers = candidates.owner opportunities.owner = candidates.owner opportunities.stageChanges.userId = candidates.owner opportunities.followers = candidates.stageChanges.userId opportunities.owner = candidates.stageChanges.userId opportunities.stageChanges.userId = candidates.stageChanges.userId
opportunity_applications	opportunities.archived.reason = opportunity_applications.archived.reason opportunities.applications = opportunity_applications.id opportunities.id = opportunity_applications.candidateId opportunities.followers = opportunity_applications.postingHiringManager opportunities.owner = opportunity_applications.postingHiringManager opportunities.stageChanges.userId = opportunity_applications.postingHiringManager opportunities.followers = opportunity_applications.postingOwner opportunities.owner = opportunity_applications.postingOwner opportunities.stageChanges.userId = opportunity_applications.postingOwner opportunities.followers = opportunity_applications.requisitionForHire.hiringManagerOnHire opportunities.owner = opportunity_applications.requisitionForHire.hiringManagerOnHire opportunities.stageChanges.userId = opportunity_applications.requisitionForHire.hiringManagerOnHire opportunities.followers = opportunity_applications.user opportunities.owner = opportunity_applications.user opportunities.stageChanges.userId = opportunity_applications.user
opportunity_offers	opportunities.id = opportunity_offers.opportunityId opportunities.followers = opportunity_offers.creator opportunities.owner = opportunity_offers.creator opportunities.stageChanges.userId = opportunity_offers.creator
stages	opportunities.stage = stages.id opportunities.stageChanges.toStageId = stages.id
candidate_offers	opportunities.followers = candidate_offers.creator opportunities.owner = candidate_offers.creator opportunities.stageChanges.userId = candidate_offers.creator
candidate_referrals	opportunities.followers = candidate_referrals.referrer opportunities.owner = candidate_referrals.referrer opportunities.stageChanges.userId = candidate_referrals.referrer opportunities.followers = candidate_referrals.user opportunities.owner = candidate_referrals.user opportunities.stageChanges.userId = candidate_referrals.user
opportunity_referrals	opportunities.followers = opportunity_referrals.referrer opportunities.owner = opportunity_referrals.referrer opportunities.stageChanges.userId = opportunity_referrals.referrer opportunities.followers = opportunity_referrals.user opportunities.owner = opportunity_referrals.user opportunities.stageChanges.userId = opportunity_referrals.user
postings	opportunities.followers = postings.followers opportunities.owner = postings.followers opportunities.stageChanges.userId = postings.followers opportunities.followers = postings.hiringManager opportunities.owner = postings.hiringManager opportunities.stageChanges.userId = postings.hiringManager opportunities.followers = postings.owner opportunities.owner = postings.owner opportunities.stageChanges.userId = postings.owner opportunities.followers = postings.user opportunities.owner = postings.user opportunities.stageChanges.userId = postings.user
requisitions	opportunities.followers = requisitions.creator opportunities.owner = requisitions.creator opportunities.stageChanges.userId = requisitions.creator opportunities.followers = requisitions.hiringManager opportunities.owner = requisitions.hiringManager opportunities.stageChanges.userId = requisitions.hiringManager opportunities.followers = requisitions.owner opportunities.owner = requisitions.owner opportunities.stageChanges.userId = requisitions.owner

opportunities table schema

applications

ARRAY

archived

OBJECT

Click to expand archived

archivedAt

DATE-TIME

reason

STRING

contact

STRING

createdAt

DATE-TIME

dataProtection

OBJECT

emails

ARRAY

followers

ARRAY

headline

STRING

isAnonymized

BOOLEAN

lastAdvancedAt

DATE-TIME

lastInteractionAt

DATE-TIME

links

ARRAY

location

STRING

name

STRING

origin

STRING

owner

STRING

phones

ARRAY

Click to expand phones

type

STRING

value

STRING

snoozedUntil

DATE-TIME

sources

ARRAY

stage

STRING

stageChanges

ARRAY

tags

ARRAY

urls

OBJECT

opportunity_applications

The opportunity_applications table contains info about candidate applications in your Lever account.

Note: To replicate this table, the opportunities table must be set to replicate.

Replication Method

Key-based Incremental

Primary Key

Useful links

opportunity_applications schema on GitHub

Lever API method

opportunity_applications table foreign keys

Join opportunity_applications with	on
archive_reasons	opportunity_applications.archived.reason = archive_reasons.id
candidate_applications	opportunity_applications.archived.reason = candidate_applications.archived.reason opportunity_applications.id = candidate_applications.id opportunity_applications.candidateId = candidate_applications.candidateId opportunity_applications.posting = candidate_applications.posting opportunity_applications.requisitionForHire.id = candidate_applications.requisitionForHire.id opportunity_applications.postingHiringManager = candidate_applications.postingHiringManager opportunity_applications.postingOwner = candidate_applications.postingHiringManager opportunity_applications.requisitionForHire.hiringManagerOnHire = candidate_applications.postingHiringManager opportunity_applications.user = candidate_applications.postingHiringManager opportunity_applications.postingHiringManager = candidate_applications.postingOwner opportunity_applications.postingOwner = candidate_applications.postingOwner opportunity_applications.requisitionForHire.hiringManagerOnHire = candidate_applications.postingOwner opportunity_applications.user = candidate_applications.postingOwner opportunity_applications.postingHiringManager = candidate_applications.requisitionForHire.hiringManagerOnHire opportunity_applications.postingOwner = candidate_applications.requisitionForHire.hiringManagerOnHire opportunity_applications.requisitionForHire.hiringManagerOnHire = candidate_applications.requisitionForHire.hiringManagerOnHire opportunity_applications.user = candidate_applications.requisitionForHire.hiringManagerOnHire opportunity_applications.postingHiringManager = candidate_applications.user opportunity_applications.postingOwner = candidate_applications.user opportunity_applications.requisitionForHire.hiringManagerOnHire = candidate_applications.user opportunity_applications.user = candidate_applications.user
candidates	opportunity_applications.archived.reason = candidates.archived.reason opportunity_applications.id = candidates.applications opportunity_applications.candidateId = candidates.id opportunity_applications.postingHiringManager = candidates.followers opportunity_applications.postingOwner = candidates.followers opportunity_applications.requisitionForHire.hiringManagerOnHire = candidates.followers opportunity_applications.user = candidates.followers opportunity_applications.postingHiringManager = candidates.owner opportunity_applications.postingOwner = candidates.owner opportunity_applications.requisitionForHire.hiringManagerOnHire = candidates.owner opportunity_applications.user = candidates.owner opportunity_applications.postingHiringManager = candidates.stageChanges.userId opportunity_applications.postingOwner = candidates.stageChanges.userId opportunity_applications.requisitionForHire.hiringManagerOnHire = candidates.stageChanges.userId opportunity_applications.user = candidates.stageChanges.userId
opportunities	opportunity_applications.archived.reason = opportunities.archived.reason opportunity_applications.id = opportunities.applications opportunity_applications.candidateId = opportunities.id opportunity_applications.postingHiringManager = opportunities.followers opportunity_applications.postingOwner = opportunities.followers opportunity_applications.requisitionForHire.hiringManagerOnHire = opportunities.followers opportunity_applications.user = opportunities.followers opportunity_applications.postingHiringManager = opportunities.owner opportunity_applications.postingOwner = opportunities.owner opportunity_applications.requisitionForHire.hiringManagerOnHire = opportunities.owner opportunity_applications.user = opportunities.owner opportunity_applications.postingHiringManager = opportunities.stageChanges.userId opportunity_applications.postingOwner = opportunities.stageChanges.userId opportunity_applications.requisitionForHire.hiringManagerOnHire = opportunities.stageChanges.userId opportunity_applications.user = opportunities.stageChanges.userId
opportunity_offers	opportunity_applications.candidateId = opportunity_offers.opportunityId opportunity_applications.posting = opportunity_offers.posting opportunity_applications.postingHiringManager = opportunity_offers.creator opportunity_applications.postingOwner = opportunity_offers.creator opportunity_applications.requisitionForHire.hiringManagerOnHire = opportunity_offers.creator opportunity_applications.user = opportunity_offers.creator
postings	opportunity_applications.posting = postings.id opportunity_applications.postingHiringManager = postings.followers opportunity_applications.postingOwner = postings.followers opportunity_applications.requisitionForHire.hiringManagerOnHire = postings.followers opportunity_applications.user = postings.followers opportunity_applications.postingHiringManager = postings.hiringManager opportunity_applications.postingOwner = postings.hiringManager opportunity_applications.requisitionForHire.hiringManagerOnHire = postings.hiringManager opportunity_applications.user = postings.hiringManager opportunity_applications.postingHiringManager = postings.owner opportunity_applications.postingOwner = postings.owner opportunity_applications.requisitionForHire.hiringManagerOnHire = postings.owner opportunity_applications.user = postings.owner opportunity_applications.postingHiringManager = postings.user opportunity_applications.postingOwner = postings.user opportunity_applications.requisitionForHire.hiringManagerOnHire = postings.user opportunity_applications.user = postings.user
requisitions	opportunity_applications.posting = requisitions.postings opportunity_applications.requisitionForHire.id = requisitions.id opportunity_applications.postingHiringManager = requisitions.creator opportunity_applications.postingOwner = requisitions.creator opportunity_applications.requisitionForHire.hiringManagerOnHire = requisitions.creator opportunity_applications.user = requisitions.creator opportunity_applications.postingHiringManager = requisitions.hiringManager opportunity_applications.postingOwner = requisitions.hiringManager opportunity_applications.requisitionForHire.hiringManagerOnHire = requisitions.hiringManager opportunity_applications.user = requisitions.hiringManager opportunity_applications.postingHiringManager = requisitions.owner opportunity_applications.postingOwner = requisitions.owner opportunity_applications.requisitionForHire.hiringManagerOnHire = requisitions.owner opportunity_applications.user = requisitions.owner
candidate_offers	opportunity_applications.postingHiringManager = candidate_offers.creator opportunity_applications.postingOwner = candidate_offers.creator opportunity_applications.requisitionForHire.hiringManagerOnHire = candidate_offers.creator opportunity_applications.user = candidate_offers.creator
candidate_referrals	opportunity_applications.postingHiringManager = candidate_referrals.referrer opportunity_applications.postingOwner = candidate_referrals.referrer opportunity_applications.requisitionForHire.hiringManagerOnHire = candidate_referrals.referrer opportunity_applications.user = candidate_referrals.referrer opportunity_applications.postingHiringManager = candidate_referrals.user opportunity_applications.postingOwner = candidate_referrals.user opportunity_applications.requisitionForHire.hiringManagerOnHire = candidate_referrals.user opportunity_applications.user = candidate_referrals.user
opportunity_referrals	opportunity_applications.postingHiringManager = opportunity_referrals.referrer opportunity_applications.postingOwner = opportunity_referrals.referrer opportunity_applications.requisitionForHire.hiringManagerOnHire = opportunity_referrals.referrer opportunity_applications.user = opportunity_referrals.referrer opportunity_applications.postingHiringManager = opportunity_referrals.user opportunity_applications.postingOwner = opportunity_referrals.user opportunity_applications.requisitionForHire.hiringManagerOnHire = opportunity_referrals.user opportunity_applications.user = opportunity_referrals.user

opportunity_applications table schema

candidateId

STRING

createdAt

NUMBER

email

STRING

name

STRING

posting

STRING

type

STRING

user

STRING

opportunity_offers

The opportunity_offers table contains info about

Note: To replicate this table, the opportunities table must be set to replicate.

Replication Method

Key-based Incremental

Useful links

Lever documentation

opportunity_offers schema on GitHub

Lever API method

opportunity_offers table foreign keys

Join opportunity_offers with	on
candidate_offers	opportunity_offers.id = candidate_offers.id opportunity_offers.creator = candidate_offers.creator
requisitions	opportunity_offers.id = requisitions.offerIds opportunity_offers.posting = requisitions.postings opportunity_offers.creator = requisitions.creator opportunity_offers.creator = requisitions.hiringManager opportunity_offers.creator = requisitions.owner
candidate_applications	opportunity_offers.opportunityId = candidate_applications.candidateId opportunity_offers.posting = candidate_applications.posting opportunity_offers.creator = candidate_applications.postingHiringManager opportunity_offers.creator = candidate_applications.postingOwner opportunity_offers.creator = candidate_applications.requisitionForHire.hiringManagerOnHire opportunity_offers.creator = candidate_applications.user
candidates	opportunity_offers.opportunityId = candidates.id opportunity_offers.creator = candidates.followers opportunity_offers.creator = candidates.owner opportunity_offers.creator = candidates.stageChanges.userId
opportunity_applications	opportunity_offers.opportunityId = opportunity_applications.candidateId opportunity_offers.posting = opportunity_applications.posting opportunity_offers.creator = opportunity_applications.postingHiringManager opportunity_offers.creator = opportunity_applications.postingOwner opportunity_offers.creator = opportunity_applications.requisitionForHire.hiringManagerOnHire opportunity_offers.creator = opportunity_applications.user
opportunities	opportunity_offers.opportunityId = opportunities.id opportunity_offers.creator = opportunities.followers opportunity_offers.creator = opportunities.owner opportunity_offers.creator = opportunities.stageChanges.userId
postings	opportunity_offers.posting = postings.id opportunity_offers.creator = postings.followers opportunity_offers.creator = postings.hiringManager opportunity_offers.creator = postings.owner opportunity_offers.creator = postings.user
candidate_referrals	opportunity_offers.creator = candidate_referrals.referrer opportunity_offers.creator = candidate_referrals.user
opportunity_referrals	opportunity_offers.creator = opportunity_referrals.referrer opportunity_offers.creator = opportunity_referrals.user

opportunity_offers table schema

approved

BOOLEAN

approvedAt

DATE-TIME

createdAt

DATE-TIME

creator

STRING

fields

ARRAY

Click to expand fields

identifier

STRING

text

STRING

value

STRING

opportunityId

STRING

posting

STRING

sentAt

DATE-TIME

sentDocument

OBJECT

Click to expand sentDocument

downloadUrl

STRING

fileName

STRING

uploadedAt

DATE-TIME

signatures

OBJECT

Click to expand signatures

candidate

OBJECT

Click to expand candidate

email

STRING

firstOpenedAt

DATE-TIME

lastOpenedAt

DATE-TIME

name

STRING

role

STRING

signed

BOOLEAN

signedAt

DATE-TIME

email

STRING

firstOpenedAt

DATE-TIME

lastOpenedAt

DATE-TIME

name

STRING

role

STRING

signed

BOOLEAN

signedAt

DATE-TIME

signedDocument

OBJECT

Click to expand signedDocument

downloadUrl

STRING

fileName

STRING

uploadedAt

DATE-TIME

status

STRING

opportunity_referrals

The opportunity_referrals table contains info about the referrals in your Lever account.

Note: To replicate this table, the opportunities table must be set to replicate.

Replication Method

Key-based Incremental

Primary Key

Useful links

Lever documentation

opportunity_referrals schema on GitHub

Lever API method

opportunity_referrals table foreign keys

Join opportunity_referrals with	on
candidate_referrals	opportunity_referrals.id = candidate_referrals.id opportunity_referrals.referrer = candidate_referrals.referrer opportunity_referrals.user = candidate_referrals.referrer opportunity_referrals.referrer = candidate_referrals.user opportunity_referrals.user = candidate_referrals.user
candidate_applications	opportunity_referrals.referrer = candidate_applications.postingHiringManager opportunity_referrals.user = candidate_applications.postingHiringManager opportunity_referrals.referrer = candidate_applications.postingOwner opportunity_referrals.user = candidate_applications.postingOwner opportunity_referrals.referrer = candidate_applications.requisitionForHire.hiringManagerOnHire opportunity_referrals.user = candidate_applications.requisitionForHire.hiringManagerOnHire opportunity_referrals.referrer = candidate_applications.user opportunity_referrals.user = candidate_applications.user
candidate_offers	opportunity_referrals.referrer = candidate_offers.creator opportunity_referrals.user = candidate_offers.creator
candidates	opportunity_referrals.referrer = candidates.followers opportunity_referrals.user = candidates.followers opportunity_referrals.referrer = candidates.owner opportunity_referrals.user = candidates.owner opportunity_referrals.referrer = candidates.stageChanges.userId opportunity_referrals.user = candidates.stageChanges.userId
opportunities	opportunity_referrals.referrer = opportunities.followers opportunity_referrals.user = opportunities.followers opportunity_referrals.referrer = opportunities.owner opportunity_referrals.user = opportunities.owner opportunity_referrals.referrer = opportunities.stageChanges.userId opportunity_referrals.user = opportunities.stageChanges.userId
opportunity_applications	opportunity_referrals.referrer = opportunity_applications.postingHiringManager opportunity_referrals.user = opportunity_applications.postingHiringManager opportunity_referrals.referrer = opportunity_applications.postingOwner opportunity_referrals.user = opportunity_applications.postingOwner opportunity_referrals.referrer = opportunity_applications.requisitionForHire.hiringManagerOnHire opportunity_referrals.user = opportunity_applications.requisitionForHire.hiringManagerOnHire opportunity_referrals.referrer = opportunity_applications.user opportunity_referrals.user = opportunity_applications.user
opportunity_offers	opportunity_referrals.referrer = opportunity_offers.creator opportunity_referrals.user = opportunity_offers.creator
postings	opportunity_referrals.referrer = postings.followers opportunity_referrals.user = postings.followers opportunity_referrals.referrer = postings.hiringManager opportunity_referrals.user = postings.hiringManager opportunity_referrals.referrer = postings.owner opportunity_referrals.user = postings.owner opportunity_referrals.referrer = postings.user opportunity_referrals.user = postings.user
requisitions	opportunity_referrals.referrer = requisitions.creator opportunity_referrals.user = requisitions.creator opportunity_referrals.referrer = requisitions.hiringManager opportunity_referrals.user = requisitions.hiringManager opportunity_referrals.referrer = requisitions.owner opportunity_referrals.user = requisitions.owner

opportunity_referrals table schema

baseTemplateId

STRING

completedAt

DATE-TIME

createdAt

DATE-TIME

fields

ARRAY

Click to expand fields

description

STRING

options

ARRAY

Click to expand options

text

STRING

prompt

STRING

required

BOOLEAN

text

STRING

type

STRING

value

STRING

instructions

STRING

referrer

STRING

stage

STRING

text

STRING

type

STRING

user

STRING

opportunity_resumes

The opportunity_resumes table contains info about candidate resumes.

Note: To replicate this table, the opportunities table must be set to replicate.

Replication Method

Key-based Incremental

Primary Key

Useful links

Lever documentation

opportunity_resumes schema on GitHub

Lever API method

opportunity_resumes table foreign keys

Join opportunity_resumes with	on
candidate_resumes	opportunity_resumes.id = candidate_resumes.id

opportunity_resumes table schema

createdAt

DATE-TIME

file

OBJECT

STRING

parsedData

OBJECT

postings

The postings table contains info about job postings in your Lever account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	updatedAt
Useful links	Lever documentation postings schema on GitHub Lever API method

postings table foreign keys

Join postings with	on
candidate_applications	postings.id = candidate_applications.posting postings.followers = candidate_applications.postingHiringManager postings.hiringManager = candidate_applications.postingHiringManager postings.owner = candidate_applications.postingHiringManager postings.user = candidate_applications.postingHiringManager postings.followers = candidate_applications.postingOwner postings.hiringManager = candidate_applications.postingOwner postings.owner = candidate_applications.postingOwner postings.user = candidate_applications.postingOwner postings.followers = candidate_applications.requisitionForHire.hiringManagerOnHire postings.hiringManager = candidate_applications.requisitionForHire.hiringManagerOnHire postings.owner = candidate_applications.requisitionForHire.hiringManagerOnHire postings.user = candidate_applications.requisitionForHire.hiringManagerOnHire postings.followers = candidate_applications.user postings.hiringManager = candidate_applications.user postings.owner = candidate_applications.user postings.user = candidate_applications.user
opportunity_applications	postings.id = opportunity_applications.posting postings.followers = opportunity_applications.postingHiringManager postings.hiringManager = opportunity_applications.postingHiringManager postings.owner = opportunity_applications.postingHiringManager postings.user = opportunity_applications.postingHiringManager postings.followers = opportunity_applications.postingOwner postings.hiringManager = opportunity_applications.postingOwner postings.owner = opportunity_applications.postingOwner postings.user = opportunity_applications.postingOwner postings.followers = opportunity_applications.requisitionForHire.hiringManagerOnHire postings.hiringManager = opportunity_applications.requisitionForHire.hiringManagerOnHire postings.owner = opportunity_applications.requisitionForHire.hiringManagerOnHire postings.user = opportunity_applications.requisitionForHire.hiringManagerOnHire postings.followers = opportunity_applications.user postings.hiringManager = opportunity_applications.user postings.owner = opportunity_applications.user postings.user = opportunity_applications.user
opportunity_offers	postings.id = opportunity_offers.posting postings.followers = opportunity_offers.creator postings.hiringManager = opportunity_offers.creator postings.owner = opportunity_offers.creator postings.user = opportunity_offers.creator
requisitions	postings.id = requisitions.postings postings.followers = requisitions.creator postings.hiringManager = requisitions.creator postings.owner = requisitions.creator postings.user = requisitions.creator postings.followers = requisitions.hiringManager postings.hiringManager = requisitions.hiringManager postings.owner = requisitions.hiringManager postings.user = requisitions.hiringManager postings.followers = requisitions.owner postings.hiringManager = requisitions.owner postings.owner = requisitions.owner postings.user = requisitions.owner
candidate_offers	postings.followers = candidate_offers.creator postings.hiringManager = candidate_offers.creator postings.owner = candidate_offers.creator postings.user = candidate_offers.creator
candidate_referrals	postings.followers = candidate_referrals.referrer postings.hiringManager = candidate_referrals.referrer postings.owner = candidate_referrals.referrer postings.user = candidate_referrals.referrer postings.followers = candidate_referrals.user postings.hiringManager = candidate_referrals.user postings.owner = candidate_referrals.user postings.user = candidate_referrals.user
candidates	postings.followers = candidates.followers postings.hiringManager = candidates.followers postings.owner = candidates.followers postings.user = candidates.followers postings.followers = candidates.owner postings.hiringManager = candidates.owner postings.owner = candidates.owner postings.user = candidates.owner postings.followers = candidates.stageChanges.userId postings.hiringManager = candidates.stageChanges.userId postings.owner = candidates.stageChanges.userId postings.user = candidates.stageChanges.userId
opportunities	postings.followers = opportunities.followers postings.hiringManager = opportunities.followers postings.owner = opportunities.followers postings.user = opportunities.followers postings.followers = opportunities.owner postings.hiringManager = opportunities.owner postings.owner = opportunities.owner postings.user = opportunities.owner postings.followers = opportunities.stageChanges.userId postings.hiringManager = opportunities.stageChanges.userId postings.owner = opportunities.stageChanges.userId postings.user = opportunities.stageChanges.userId
opportunity_referrals	postings.followers = opportunity_referrals.referrer postings.hiringManager = opportunity_referrals.referrer postings.owner = opportunity_referrals.referrer postings.user = opportunity_referrals.referrer postings.followers = opportunity_referrals.user postings.hiringManager = opportunity_referrals.user postings.owner = opportunity_referrals.user postings.user = opportunity_referrals.user

postings table schema

categories

OBJECT

Click to expand categories

commitment

STRING

department

STRING

level

STRING

location

STRING

team

STRING

content

OBJECT

Click to expand content

closing

STRING

customQuestions

ARRAY

description

STRING

lists

ARRAY

Click to expand lists

content

STRING

text

STRING

createdAt

DATE-TIME

distributionChannels

ARRAY

followers

STRING

hiringManager

STRING

owner

STRING

reqCode

STRING

state

STRING

tags

ARRAY

text

STRING

updatedAt

DATE-TIME

urls

OBJECT

Click to expand urls

apply

STRING

list

STRING

show

STRING

user

STRING

requisitions

The requisitions table contains info about requisitions in your Lever account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	createdAt
Useful links	Lever documentation requisitions schema on GitHub Lever API method

requisitions table foreign keys

Join requisitions with	on
candidate_offers	requisitions.offerIds = candidate_offers.id requisitions.creator = candidate_offers.creator requisitions.hiringManager = candidate_offers.creator requisitions.owner = candidate_offers.creator
opportunity_offers	requisitions.offerIds = opportunity_offers.id requisitions.postings = opportunity_offers.posting requisitions.creator = opportunity_offers.creator requisitions.hiringManager = opportunity_offers.creator requisitions.owner = opportunity_offers.creator
candidate_applications	requisitions.postings = candidate_applications.posting requisitions.id = candidate_applications.requisitionForHire.id requisitions.creator = candidate_applications.postingHiringManager requisitions.hiringManager = candidate_applications.postingHiringManager requisitions.owner = candidate_applications.postingHiringManager requisitions.creator = candidate_applications.postingOwner requisitions.hiringManager = candidate_applications.postingOwner requisitions.owner = candidate_applications.postingOwner requisitions.creator = candidate_applications.requisitionForHire.hiringManagerOnHire requisitions.hiringManager = candidate_applications.requisitionForHire.hiringManagerOnHire requisitions.owner = candidate_applications.requisitionForHire.hiringManagerOnHire requisitions.creator = candidate_applications.user requisitions.hiringManager = candidate_applications.user requisitions.owner = candidate_applications.user
opportunity_applications	requisitions.postings = opportunity_applications.posting requisitions.id = opportunity_applications.requisitionForHire.id requisitions.creator = opportunity_applications.postingHiringManager requisitions.hiringManager = opportunity_applications.postingHiringManager requisitions.owner = opportunity_applications.postingHiringManager requisitions.creator = opportunity_applications.postingOwner requisitions.hiringManager = opportunity_applications.postingOwner requisitions.owner = opportunity_applications.postingOwner requisitions.creator = opportunity_applications.requisitionForHire.hiringManagerOnHire requisitions.hiringManager = opportunity_applications.requisitionForHire.hiringManagerOnHire requisitions.owner = opportunity_applications.requisitionForHire.hiringManagerOnHire requisitions.creator = opportunity_applications.user requisitions.hiringManager = opportunity_applications.user requisitions.owner = opportunity_applications.user
postings	requisitions.postings = postings.id requisitions.creator = postings.followers requisitions.hiringManager = postings.followers requisitions.owner = postings.followers requisitions.creator = postings.hiringManager requisitions.hiringManager = postings.hiringManager requisitions.owner = postings.hiringManager requisitions.creator = postings.owner requisitions.hiringManager = postings.owner requisitions.owner = postings.owner requisitions.creator = postings.user requisitions.hiringManager = postings.user requisitions.owner = postings.user
candidate_referrals	requisitions.creator = candidate_referrals.referrer requisitions.hiringManager = candidate_referrals.referrer requisitions.owner = candidate_referrals.referrer requisitions.creator = candidate_referrals.user requisitions.hiringManager = candidate_referrals.user requisitions.owner = candidate_referrals.user
candidates	requisitions.creator = candidates.followers requisitions.hiringManager = candidates.followers requisitions.owner = candidates.followers requisitions.creator = candidates.owner requisitions.hiringManager = candidates.owner requisitions.owner = candidates.owner requisitions.creator = candidates.stageChanges.userId requisitions.hiringManager = candidates.stageChanges.userId requisitions.owner = candidates.stageChanges.userId
opportunities	requisitions.creator = opportunities.followers requisitions.hiringManager = opportunities.followers requisitions.owner = opportunities.followers requisitions.creator = opportunities.owner requisitions.hiringManager = opportunities.owner requisitions.owner = opportunities.owner requisitions.creator = opportunities.stageChanges.userId requisitions.hiringManager = opportunities.stageChanges.userId requisitions.owner = opportunities.stageChanges.userId
opportunity_referrals	requisitions.creator = opportunity_referrals.referrer requisitions.hiringManager = opportunity_referrals.referrer requisitions.owner = opportunity_referrals.referrer requisitions.creator = opportunity_referrals.user requisitions.hiringManager = opportunity_referrals.user requisitions.owner = opportunity_referrals.user

requisitions table schema

backfill

BOOLEAN

createdAt

DATE-TIME

creator

STRING

department

STRING

employmentStatus

STRING

headcountHired

INTEGER

headcountTotal

STRING

hiringManager

STRING

internalNotes

STRING

location

STRING

name

STRING

offerIds

ARRAY

owner

STRING

postings

ARRAY

requisitionCode

STRING

status

STRING

team

STRING

sources

The sources table contains info about sources, or the ways that candidates enter into your Lever account.

Replication Method

Full Table

Primary Key

text

Useful links

Lever documentation

sources schema on GitHub

Lever API method

sources table schema

count

INTEGER

text

STRING

stages

The stages table contains info about stages, or the steps in the recruiting workflow in your hiring pipeline.

Replication Method

Full Table

Primary Key

Useful links

Lever documentation

stages schema on GitHub

Lever API method

stages table foreign keys

Join stages with

candidates

stages.id = candidates.stage

stages.id = candidates.stageChanges.toStageId

opportunities

stages.id = opportunities.stage

stages.id = opportunities.stageChanges.toStageId

stages table schema

STRING

text

STRING

users

The users table contains info about the users in your Lever account. A user includes anyone who has been invited to Lever to collaborate on recruiting efforts.

Replication Method

Full Table

Primary Key

Useful links

Lever documentation

users schema on GitHub

Lever API method

users table schema

accessRole

STRING

createdAt

DATE-TIME

deactivatedAt

DATE-TIME

email

STRING

externalDirectoryId

STRING

name

STRING

photo

STRING

username

STRING

Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.

Related	Troubleshooting
Destination & Integration Compatibility Replication Scheduling Syncing Historical SaaS Data Resetting Replication Keys Nested Data Structures & Row Count Impact	Third-Party Downtime Understanding & Reducing Your Usage Re-Authorizing Integrations Replication Issues