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.

유용한 링크와 지원되는 기능을 포함하여 이 커넥터에 대한 전반적인 내용을 살펴보겠습니다.

특징/기능	지원 세부 정보
지원되는 Qlik Talend Data Integration 프로젝트	복제 프로젝트에만 해당됩니다. 데이터 파이프라인 프로젝트는 지원되지 않습니다.
대상 업데이트 방법	복제 작업: 변경 내용 적용 변경 내용 저장 데이터 레이크 작업에 데이터 랜딩: 데이터 변경 내용 캡처(CDC)
메타데이터 관리	수동 메타데이터 생성이 필요하지 않습니다.
스키마 진화	열 데이터 유형 변경 작업만 지원됩니다.
LOB 열(NCLOB, CLOB 및 BLOB) 복제	지원되지 않음.
예정된 CDC	필수. 이렇게 하면 소스의 변경 내용이 대상에 최신 상태로 유지됩니다. 복제 작업의 경우 작업 예약 을 참조하십시오. 레이크 랜딩 작업의 경우 레이크 랜딩 작업을 위한 CDC 일정을 참조하십시오.
알림	부분적으로 지원됨 작업 변경 알림 설정
모니터링 중	CDC에만 해당되며, 이 커넥터의 경우 전체 로드가 적용되지 않습니다. 개별 데이터 작업 모니터링
JSON 열 페이로드의 자동 압축 해제	지원되지 않음. 소스 데이터 집합의 JSON 열 페이로드는 대상에서 자동으로 압축 해제되지 않습니다.

Preparing for authentication

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

사용하는 계정에 가져오려는 테이블에 대한 읽기 액세스 권한이 있는지 확인합니다.

Creating the connection

자세한 내용은 SaaS 응용 프로그램에 연결을 참조하십시오.

필요한 연결 속성을 입력합니다.
연결 이름에 연결 이름을 입력합니다.
연결이 만들어질 때 연결에 대한 메타데이터를 정의하려면 연결 메타데이터 열기를 선택합니다.
만들기를 클릭합니다.

Connection settings
Setting	Description
Data gateway	사용 사례에 필요한 경우 데이터 이동 게이트웨이를 선택합니다. 정보 메모 이 필드는 데이터 이동 게이트웨이를 지원하지 않으므로 Qlik Talend Cloud 시작 구독에서는 사용할 수 없습니다. 다른 구독 계층이 있고 데이터 이동 게이트웨이를 사용하지 않으려면 없음을 선택합니다. 데이터 이동 게이트웨이의 이점과 이를 필요로 하는 사용 사례에 대한 자세한 내용은 Qlik 데이터 게이트웨이 - 데이터 이동를 참조하십시오.
Start Date	데이터를 소스에서 대상으로 복제해야 하는 날짜를 `MM/DD/YYYY` 형식으로 입력합니다.
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

이 페이지가 도움이 되었습니까?

이 페이지 또는 해당 콘텐츠에서 오타, 누락된 단계 또는 기술적 오류와 같은 문제를 발견하면 알려 주십시오!

여기에 피드백을 남겨주십시오.