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.| Feature/Capability | Support details |
|---|---|
| Supported Qlik Talend Data Integration projects | Replication projects only. Data pipeline projects are not supported. |
Replication tasks:
Landing data in a data lake tasks:
| |
| Manual metadata generation is not required. | |
| Only the Change column data type operation is supported. | |
| Replication of LOB columns (NCLOB, CLOB, and BLOB) | Not supported. |
| Scheduled CDC | Required. This is how the target is kept up-to-date with changes to the source. For replication tasks, see Scheduling tasks For lake landing tasks, see Scheduling CDC for lake landing tasks |
| Notifications | Partially supported |
| Monitoring | CDC-only, as full load is not relevant for this connector. |
| Automatic denesting of JSON column payloads | Not supported. JSON column payloads in source datasets are not denested automatically on the target. |
Preparing for authentication
To access your data, you need to authenticate the connection with your account credentials.
Creating the connection
For more information, see Connecting to SaaS applications.
- Fill in the required connection properties.
Provide a name for the connection in Connection name.
Select Open connection metadata to define metadata for the connection when it has been created.
Click Create.
| Setting | Description |
|---|---|
| Data gateway | Select a Data Movement gateway if required by your use case. Information note This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway. If you have another subscription tier and do not want to use Data Movement gateway, select None. For information on the benefits of Data Movement gateway and use cases that require it, see Qlik Data Gateway - Data Movement. |
| Start Date | Enter the date, in the format |
| 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 | id |
| Useful links |
| 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 |
id STRING |
text STRING |
candidate_applications
The candidate_applications table contains info about candidate applications in your Lever account.
Replication Method | CDC |
Primary Key | id |
| Useful links |
| 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 |
STRING |
id 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 | id |
| Useful links |
| 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:
|
id STRING |
sentAt DATE-TIME |
signatures OBJECT This is a nested data structure:
|
status STRING |
candidate_referrals
The candidate_referrals table contains info about the referrals in your Lever account.
Replication Method | CDC |
Primary Key | id |
| Useful links |
| 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:
|
id 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 | id |
| Useful links |
| Join candidate_resumes with | on |
|---|---|
| opportunity_resumes | candidate_resumes.id = opportunity_resumes.id |
createdAt DATE-TIME |
file OBJECT This is a nested data structure. |
id 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 | id |
| Useful links |
| 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:
|
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 |
id 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:
|
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 | id |
| Useful links |
| 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:
|
contact STRING |
createdAt DATE-TIME |
dataProtection OBJECT This is a nested data structure. This is a nested data structure. |
emails ARRAY This is a nested data structure. |
followers ARRAY This is a nested data structure. |
headline STRING |
id 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:
|
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 | id |
| Useful links |
| 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 |
STRING |
id 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 |
| 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:
|
id STRING |
opportunityId STRING |
posting STRING |
sentAt DATE-TIME |
sentDocument OBJECT This is a nested data structure:
|
signatures OBJECT This is a nested data structure:
|
signedDocument OBJECT This is a nested data structure:
|
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 | id |
| Useful links |
| 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:
|
id 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 | id |
| Useful links |
| Join opportunity_resumes with | on |
|---|---|
| candidate_resumes | opportunity_resumes.id = candidate_resumes.id |
createdAt DATE-TIME |
file OBJECT This is a nested data structure. |
id 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 |
| 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:
|
content OBJECT This is a nested data structure:
|
createdAt DATE-TIME |
distributionChannels ARRAY This is a nested data structure. |
followers STRING |
hiringManager STRING |
id 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:
|
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 |
| 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 |
id 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 |
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 | id |
| Useful links |
| Join stages with | on |
|---|---|
| candidates | stages.id = candidates.stage stages.id = candidates.stageChanges.toStageId |
| opportunities | stages.id = opportunities.stage stages.id = opportunities.stageChanges.toStageId |
id 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 | id |
| Useful links |
accessRole STRING |
createdAt DATE-TIME |
deactivatedAt DATE-TIME |
STRING |
externalDirectoryId STRING |
id STRING |
name STRING |
photo STRING |
username STRING |