Lever

Lever is a cloud-based applicant tracking system (ATS) and candidate relationship management (CRM) platform.

Lever integration replicates data using the Lever API (v1).

See the Schema section for a list of objects available for replication.

Présentation générale de ce connecteur, y compris des liens utiles et les fonctions supportées.

Caractéristique/Fonctionnalité	Détails du support
Projets Qlik Talend Data Integration supportés	Projets de réplication uniquement. Les projets de pipeline de données ne sont pas supportés.
Méthodes de mise à jour de la cible	Tâches de réplication : Appliquer les modifications Stocker les modifications Tâches de dépôt temporaire de données dans un lac de données : Change Data Capture (CDC)
Gestion des métadonnées	La génération manuelle de métadonnées n'est pas nécessaire.
Évolution du schéma	Seule l'opération Modifier le type de données de la colonne est supportée.
Réplication de colonnes LOB (NCLOB, CLOB et BLOB)	Non supporté.
Opération CDC planifiée	Requis. C'est ainsi que la cible est mise à jour en fonction des modifications apportées à la source. Pour les tâches de réplication, consultez Planification de tâches . Pour les tâches de dépôt temporaire dans un lac, consultez Planification de CDC pour les tâches de dépôt temporaire dans un lac.
Notifications	Partiellement supporté Définition de notifications en cas de modifications du fonctionnement
Monitoring	CDC uniquement, car Chargement complet n'est pas pertinent pour ce connecteur. Surveillance d'une tâche de données individuelle
Désimbrication automatique des charges utiles des colonnes JSON	Non supporté. Les charges utiles des colonnes JSON des jeux de données sources ne sont pas automatiquement désimbriquées sur la cible.

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

Assurez-vous que le compte que vous utilisez dispose d'un accès en lecture sur les tables à récupérer.

Creating the connection

Pour plus d'informations, consultez Connexion à des applications SaaS.

Complétez les propriétés de connexion requises.
Fournissez un nom pour la connexion dans Nom de la connexion.
Sélectionnez Ouvrir les métadonnées de connexion pour définir les métadonnées de la connexion lors de sa création.
Cliquez sur Créer.

Connection settings
Setting	Description
Data gateway	Sélectionnez une Passerelle de déplacement des données si cela est nécessaire pour votre cas d'utilisation. Note Informations Ce champ n'est pas disponible avec l'abonnement Démarreur Qlik Talend Cloud, car il ne supporte pas Passerelle de déplacement des données. Si vous avez un autre niveau d'abonnement et si vous ne souhaitez pas utiliser Passerelle de déplacement des données, sélectionnez Aucune. Pour des informations sur les avantages de Passerelle de déplacement des données et les cas d'utilisation qui la nécessitent, consultez Passerelle de données Qlik - Déplacement des données.
Start Date	Saisissez la date, au format `MM/DD/YYYY`, à partir de laquelle les données doivent être répliquées de votre source vers votre cible.
Token	Token.

Schema

Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.

The schema and info displayed below is for version 1.

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

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

Lever API method

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

STRING

text

STRING

candidate_applications

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

Replication Method

CDC

Primary Key

Useful links

Lever documentation

Lever API method

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

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

CDC

Primary Key

Useful links

Lever documentation

Lever API method

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

approvedAt

DATE-TIME

createdAt

DATE-TIME

creator

STRING

fields

ARRAY

This is a nested data structure:

identifier: STRING
text: STRING
value: STRING

STRING

sentAt

DATE-TIME

signatures

OBJECT

This is a nested data structure:

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

CDC

Primary Key

Useful links

Lever documentation

Lever API method

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

baseTemplateId

STRING

completedAt

DATE-TIME

createdAt

DATE-TIME

fields

ARRAY

This is a nested data structure:

description: STRING
options: ARRAY, which is also a nested data structure.
- text: STRING
prompt: STRING
required: BOOLEAN
text: STRING
type: STRING
value: STRING

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

CDC

Primary Key

Useful links

Lever documentation

Lever API method

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

createdAt

DATE-TIME

file

OBJECT

This is a nested data structure.

STRING

parsedData

OBJECT

This is a nested data structure.

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

CDC

Primary Key

Useful links

Lever documentation

Lever API method

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

applications

ARRAY

This is a nested data structure.

archived

OBJECT

This is a nested data structure:

archivedAt: DATE-TIME
reason: STRING

contact

STRING

createdAt

DATE-TIME

dataProtection

OBJECT

This is a nested data structure.

emails

ARRAY

This is a nested data structure.

followers

ARRAY

This is a nested data structure.

headline

STRING

isAnonymized

BOOLEAN

lastAdvancedAt

DATE-TIME

lastInteractionAt

DATE-TIME

links

ARRAY

This is a nested data structure.

location

STRING

name

STRING

origin

STRING

owner

STRING

phones

ARRAY

This is a nested data structure:

type: STRING
value: STRING

resume

OBJECT

This is a nested data structure.

snoozedUntil

DATE-TIME

sources

ARRAY

This is a nested data structure.

stage

STRING

stageChanges

ARRAY

This is a nested data structure.

tags

ARRAY

This is a nested data structure.

urls

OBJECT

This is a nested data structure.

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

CDC

Primary Key

Useful links

Lever documentation

Lever API method

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

applications

ARRAY

This is a nested data structure.

archived

OBJECT

This is a nested data structure:

archivedAt: DATE-TIME
reason: STRING

contact

STRING

createdAt

DATE-TIME

dataProtection

OBJECT

This is a nested data structure.

emails

ARRAY

This is a nested data structure.

followers

ARRAY

This is a nested data structure.

headline

STRING

isAnonymized

BOOLEAN

lastAdvancedAt

DATE-TIME

lastInteractionAt

DATE-TIME

links

ARRAY

This is a nested data structure.

location

STRING

name

STRING

origin

STRING

owner

STRING

phones

ARRAY

This is a nested data structure:

type: STRING
value: STRING

snoozedUntil

DATE-TIME

sources

ARRAY

This is a nested data structure.

stage

STRING

stageChanges

ARRAY

This is a nested data structure.

tags

ARRAY

This is a nested data structure.

urls

OBJECT

This is a nested data structure.

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

CDC

Primary Key

Useful links

Lever API method

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

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

CDC

Useful links

Lever documentation

Lever API method

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

approved

BOOLEAN

approvedAt

DATE-TIME

createdAt

DATE-TIME

creator

STRING

fields

ARRAY

This is a nested data structure:

identifier: STRING
text: STRING
value: STRING

STRING

opportunityId

STRING

posting

STRING

sentAt

DATE-TIME

sentDocument

OBJECT

This is a nested data structure:

downloadUrl: STRING
fileName: STRING
uploadedAt: DATE-TIME

signatures

OBJECT

This is a nested data structure:

candidate: OBJECT, which is also a nested data structure.
- 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

This is a nested data structure:

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

CDC

Primary Key

Useful links

Lever documentation

Lever API method

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

baseTemplateId

STRING

completedAt

DATE-TIME

createdAt

DATE-TIME

fields

ARRAY

This is a nested data structure:

description: STRING
options: ARRAY, which is also a nested data structure.
- text: STRING
prompt: STRING
required: BOOLEAN
text: STRING
type: STRING
value: STRING

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

CDC

Primary Key

Useful links

Lever documentation

Lever API method

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

createdAt

DATE-TIME

file

OBJECT

This is a nested data structure.

STRING

parsedData

OBJECT

This is a nested data structure.

postings

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

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Lever documentation Lever API method

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

categories

OBJECT

This is a nested data structure:

commitment: STRING
department: STRING
level: STRING
location: STRING
team: STRING

content

OBJECT

This is a nested data structure:

closing: STRING
customQuestions: ARRAY, which is also a nested data structure.
description: STRING
lists: ARRAY, which is also a nested data structure.
- content: STRING
- text: STRING

createdAt

DATE-TIME

distributionChannels

ARRAY

This is a nested data structure.

followers

STRING

hiringManager

STRING

owner

STRING

reqCode

STRING

state

STRING

tags

ARRAY

This is a nested data structure.

text

STRING

updatedAt

DATE-TIME

urls

OBJECT

This is a nested data structure:

apply: STRING
list: STRING
show: STRING

user

STRING

requisitions

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

Replication Method	CDC
Primary Key	id
Replication Key	createdAt
Useful links	Lever documentation Lever API method

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

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

This is a nested data structure.

owner

STRING

postings

ARRAY

This is a nested data structure.

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

Lever API method

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

Lever API method

Join stages with	on
candidates	stages.id = candidates.stage stages.id = candidates.stageChanges.toStageId
opportunities	stages.id = opportunities.stage stages.id = opportunities.stageChanges.toStageId

Join stages with

candidates

stages.id = candidates.stage

stages.id = candidates.stageChanges.toStageId

opportunities

stages.id = opportunities.stage

stages.id = opportunities.stageChanges.toStageId

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

Lever API method

accessRole

STRING

createdAt

DATE-TIME

deactivatedAt

DATE-TIME

email

STRING

externalDirectoryId

STRING

name

STRING

photo

STRING

username

STRING

Cette page vous a-t-elle aidé ?

Si vous rencontrez des problèmes sur cette page ou dans son contenu – une faute de frappe, une étape manquante ou une erreur technique – faites-le-nous savoir.

Laissez vos commentaires ici