# 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)](https://hire.lever.co/developer/documentation).

See the [Schema](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#Schema) section for a list of objects available for replication.

## Preparing for authentication

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

Information noteMake sure that the account you use has read access to the tables you want to fetch.

To create the token:

1. Log into your [Lever](https://hire.lever.co/auth/login?continue=%2F) account.
2. Click your profile icon in the upper-right corner.
3. Go to Settings > API Credentials.
4. Locate the Generate New Key link in the Lever API credentials section.
5. If you want your key to access confidential information, turn the Allow access to confidential data toggle on. If not, skip to the next step.
6. Click Done.
7. Copy and paste your token into a secured file.

## Creating the connection

For more information, see [Connecting to SaaS applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Landing/connecting-web-applications.htm).

1. Fill in the required connection properties.

2. Provide a name for the connection in Connection name.

3. Select Open connection metadata to define metadata for the connection when it has been created.

4. Click Create.

Connection settings

| Setting | Description |
| --- | --- |
| Data gateway | Select a Data Movement gateway if required by your use case.<br><br>Information note<br><br>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.<br><br>For information on the benefits of Data Movement gateway and use cases that require it, see [Qlik Data Gateway - Data Movement](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/replication-gateway.htm). |
| Start Date | Enter the date, in the format `MM/DD/YYYY`, from which the data must be replicated from your source to your target. |
| Token | Token. |

## Schema

Information note

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

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](https://help.lever.co/hc/articles/204502125) for more info.

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Lever documentation](https://hire.lever.co/developer/documentation#archive-reasons)<br><br>[Lever API method](https://hire.lever.co/developer/documentation#list-all-archive-reasons "Opens in new tab: Lever API method") |

archive\_reasons table foreign keys

| Join archive\_reasons with | on |
| --- | --- |
| [candidate_applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-applications) | ```<br>archive_reasons.id = candidate_applications.archived.reason<br>``` |
| [candidates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidates) | ```<br>archive_reasons.id = candidates.archived.reason<br>``` |
| [opportunity_applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-applications) | ```<br>archive_reasons.id = opportunity_applications.archived.reason<br>``` |
| [opportunities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunities) | ```<br>archive_reasons.id = opportunities.archived.reason<br>``` |

archive\_reasons table schema

| **id**<br><br><br>STRING |
| --- |
| **text**<br><br><br>STRING |

### candidate\_applications

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

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Lever documentation](https://hire.lever.co/developer/documentation#applications)<br><br>[Lever API method](https://hire.lever.co/developer/documentation#list-all-applications "Opens in new tab: Lever API method") |

candidate\_applications table foreign keys

| Join candidate\_applications with | on |
| --- | --- |
| [archive_reasons](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#archive-reasons) | ```<br>candidate_applications.archived.reason = archive_reasons.id<br>``` |
| [candidates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidates) | ```<br>candidate_applications.archived.reason = candidates.archived.reason<br>```<br><br>```<br>candidate_applications.id = candidates.applications<br>```<br><br>```<br>candidate_applications.candidateId = candidates.id<br>```<br><br>```<br>candidate_applications.postingHiringManager = candidates.followers<br>```<br><br>```<br>candidate_applications.postingOwner = candidates.followers<br>```<br><br>```<br>candidate_applications.requisitionForHire.hiringManagerOnHire = candidates.followers<br>```<br><br>```<br>candidate_applications.user = candidates.followers<br>```<br><br>```<br>candidate_applications.postingHiringManager = candidates.owner<br>```<br><br>```<br>candidate_applications.postingOwner = candidates.owner<br>```<br><br>```<br>candidate_applications.requisitionForHire.hiringManagerOnHire = candidates.owner<br>```<br><br>```<br>candidate_applications.user = candidates.owner<br>```<br><br>```<br>candidate_applications.postingHiringManager = candidates.stageChanges.userId<br>```<br><br>```<br>candidate_applications.postingOwner = candidates.stageChanges.userId<br>```<br><br>```<br>candidate_applications.requisitionForHire.hiringManagerOnHire = candidates.stageChanges.userId<br>```<br><br>```<br>candidate_applications.user = candidates.stageChanges.userId<br>``` |
| [opportunity_applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-applications) | ```<br>candidate_applications.archived.reason = opportunity_applications.archived.reason<br>```<br><br>```<br>candidate_applications.id = opportunity_applications.id<br>```<br><br>```<br>candidate_applications.candidateId = opportunity_applications.candidateId<br>```<br><br>```<br>candidate_applications.posting = opportunity_applications.posting<br>```<br><br>```<br>candidate_applications.requisitionForHire.id = opportunity_applications.requisitionForHire.id<br>```<br><br>```<br>candidate_applications.postingHiringManager = opportunity_applications.postingHiringManager<br>```<br><br>```<br>candidate_applications.postingOwner = opportunity_applications.postingHiringManager<br>```<br><br>```<br>candidate_applications.requisitionForHire.hiringManagerOnHire = opportunity_applications.postingHiringManager<br>```<br><br>```<br>candidate_applications.user = opportunity_applications.postingHiringManager<br>```<br><br>```<br>candidate_applications.postingHiringManager = opportunity_applications.postingOwner<br>```<br><br>```<br>candidate_applications.postingOwner = opportunity_applications.postingOwner<br>```<br><br>```<br>candidate_applications.requisitionForHire.hiringManagerOnHire = opportunity_applications.postingOwner<br>```<br><br>```<br>candidate_applications.user = opportunity_applications.postingOwner<br>```<br><br>```<br>candidate_applications.postingHiringManager = opportunity_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>candidate_applications.postingOwner = opportunity_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>candidate_applications.requisitionForHire.hiringManagerOnHire = opportunity_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>candidate_applications.user = opportunity_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>candidate_applications.postingHiringManager = opportunity_applications.user<br>```<br><br>```<br>candidate_applications.postingOwner = opportunity_applications.user<br>```<br><br>```<br>candidate_applications.requisitionForHire.hiringManagerOnHire = opportunity_applications.user<br>```<br><br>```<br>candidate_applications.user = opportunity_applications.user<br>``` |
| [opportunities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunities) | ```<br>candidate_applications.archived.reason = opportunities.archived.reason<br>```<br><br>```<br>candidate_applications.id = opportunities.applications<br>```<br><br>```<br>candidate_applications.candidateId = opportunities.id<br>```<br><br>```<br>candidate_applications.postingHiringManager = opportunities.followers<br>```<br><br>```<br>candidate_applications.postingOwner = opportunities.followers<br>```<br><br>```<br>candidate_applications.requisitionForHire.hiringManagerOnHire = opportunities.followers<br>```<br><br>```<br>candidate_applications.user = opportunities.followers<br>```<br><br>```<br>candidate_applications.postingHiringManager = opportunities.owner<br>```<br><br>```<br>candidate_applications.postingOwner = opportunities.owner<br>```<br><br>```<br>candidate_applications.requisitionForHire.hiringManagerOnHire = opportunities.owner<br>```<br><br>```<br>candidate_applications.user = opportunities.owner<br>```<br><br>```<br>candidate_applications.postingHiringManager = opportunities.stageChanges.userId<br>```<br><br>```<br>candidate_applications.postingOwner = opportunities.stageChanges.userId<br>```<br><br>```<br>candidate_applications.requisitionForHire.hiringManagerOnHire = opportunities.stageChanges.userId<br>```<br><br>```<br>candidate_applications.user = opportunities.stageChanges.userId<br>``` |
| [opportunity_offers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-offers) | ```<br>candidate_applications.candidateId = opportunity_offers.opportunityId<br>```<br><br>```<br>candidate_applications.posting = opportunity_offers.posting<br>```<br><br>```<br>candidate_applications.postingHiringManager = opportunity_offers.creator<br>```<br><br>```<br>candidate_applications.postingOwner = opportunity_offers.creator<br>```<br><br>```<br>candidate_applications.requisitionForHire.hiringManagerOnHire = opportunity_offers.creator<br>```<br><br>```<br>candidate_applications.user = opportunity_offers.creator<br>``` |
| [postings](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#postings) | ```<br>candidate_applications.posting = postings.id<br>```<br><br>```<br>candidate_applications.postingHiringManager = postings.followers<br>```<br><br>```<br>candidate_applications.postingOwner = postings.followers<br>```<br><br>```<br>candidate_applications.requisitionForHire.hiringManagerOnHire = postings.followers<br>```<br><br>```<br>candidate_applications.user = postings.followers<br>```<br><br>```<br>candidate_applications.postingHiringManager = postings.hiringManager<br>```<br><br>```<br>candidate_applications.postingOwner = postings.hiringManager<br>```<br><br>```<br>candidate_applications.requisitionForHire.hiringManagerOnHire = postings.hiringManager<br>```<br><br>```<br>candidate_applications.user = postings.hiringManager<br>```<br><br>```<br>candidate_applications.postingHiringManager = postings.owner<br>```<br><br>```<br>candidate_applications.postingOwner = postings.owner<br>```<br><br>```<br>candidate_applications.requisitionForHire.hiringManagerOnHire = postings.owner<br>```<br><br>```<br>candidate_applications.user = postings.owner<br>```<br><br>```<br>candidate_applications.postingHiringManager = postings.user<br>```<br><br>```<br>candidate_applications.postingOwner = postings.user<br>```<br><br>```<br>candidate_applications.requisitionForHire.hiringManagerOnHire = postings.user<br>```<br><br>```<br>candidate_applications.user = postings.user<br>``` |
| [requisitions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#requisitions) | ```<br>candidate_applications.posting = requisitions.postings<br>```<br><br>```<br>candidate_applications.requisitionForHire.id = requisitions.id<br>```<br><br>```<br>candidate_applications.postingHiringManager = requisitions.creator<br>```<br><br>```<br>candidate_applications.postingOwner = requisitions.creator<br>```<br><br>```<br>candidate_applications.requisitionForHire.hiringManagerOnHire = requisitions.creator<br>```<br><br>```<br>candidate_applications.user = requisitions.creator<br>```<br><br>```<br>candidate_applications.postingHiringManager = requisitions.hiringManager<br>```<br><br>```<br>candidate_applications.postingOwner = requisitions.hiringManager<br>```<br><br>```<br>candidate_applications.requisitionForHire.hiringManagerOnHire = requisitions.hiringManager<br>```<br><br>```<br>candidate_applications.user = requisitions.hiringManager<br>```<br><br>```<br>candidate_applications.postingHiringManager = requisitions.owner<br>```<br><br>```<br>candidate_applications.postingOwner = requisitions.owner<br>```<br><br>```<br>candidate_applications.requisitionForHire.hiringManagerOnHire = requisitions.owner<br>```<br><br>```<br>candidate_applications.user = requisitions.owner<br>``` |
| [candidate_offers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-offers) | ```<br>candidate_applications.postingHiringManager = candidate_offers.creator<br>```<br><br>```<br>candidate_applications.postingOwner = candidate_offers.creator<br>```<br><br>```<br>candidate_applications.requisitionForHire.hiringManagerOnHire = candidate_offers.creator<br>```<br><br>```<br>candidate_applications.user = candidate_offers.creator<br>``` |
| [candidate_referrals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-referrals) | ```<br>candidate_applications.postingHiringManager = candidate_referrals.referrer<br>```<br><br>```<br>candidate_applications.postingOwner = candidate_referrals.referrer<br>```<br><br>```<br>candidate_applications.requisitionForHire.hiringManagerOnHire = candidate_referrals.referrer<br>```<br><br>```<br>candidate_applications.user = candidate_referrals.referrer<br>```<br><br>```<br>candidate_applications.postingHiringManager = candidate_referrals.user<br>```<br><br>```<br>candidate_applications.postingOwner = candidate_referrals.user<br>```<br><br>```<br>candidate_applications.requisitionForHire.hiringManagerOnHire = candidate_referrals.user<br>```<br><br>```<br>candidate_applications.user = candidate_referrals.user<br>``` |
| [opportunity_referrals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-referrals) | ```<br>candidate_applications.postingHiringManager = opportunity_referrals.referrer<br>```<br><br>```<br>candidate_applications.postingOwner = opportunity_referrals.referrer<br>```<br><br>```<br>candidate_applications.requisitionForHire.hiringManagerOnHire = opportunity_referrals.referrer<br>```<br><br>```<br>candidate_applications.user = opportunity_referrals.referrer<br>```<br><br>```<br>candidate_applications.postingHiringManager = opportunity_referrals.user<br>```<br><br>```<br>candidate_applications.postingOwner = opportunity_referrals.user<br>```<br><br>```<br>candidate_applications.requisitionForHire.hiringManagerOnHire = opportunity_referrals.user<br>```<br><br>```<br>candidate_applications.user = opportunity_referrals.user<br>``` |

candidate\_applications table schema

| **candidateId**<br><br><br>STRING |
| --- |
| **createdAt**<br><br><br>NUMBER |
| **email**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **name**<br><br><br>STRING |
| **posting**<br><br><br>STRING |
| **type**<br><br><br>STRING |
| **user**<br><br><br>STRING |

### candidate\_offers

The `candidate_offers` table contains data sent to candidates about [`opportunities`](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunities) via Lever’s Offers feature.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Lever documentation](https://hire.lever.co/developer/documentation#offers)<br><br>[Lever API method](https://hire.lever.co/developer/documentation#list-all-offers "Opens in new tab: Lever API method") |

candidate\_offers table foreign keys

| Join candidate\_offers with | on |
| --- | --- |
| [opportunity_offers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-offers) | ```<br>candidate_offers.id = opportunity_offers.id<br>```<br><br>```<br>candidate_offers.creator = opportunity_offers.creator<br>``` |
| [requisitions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#requisitions) | ```<br>candidate_offers.id = requisitions.offerIds<br>```<br><br>```<br>candidate_offers.creator = requisitions.creator<br>```<br><br>```<br>candidate_offers.creator = requisitions.hiringManager<br>```<br><br>```<br>candidate_offers.creator = requisitions.owner<br>``` |
| [candidate_applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-applications) | ```<br>candidate_offers.creator = candidate_applications.postingHiringManager<br>```<br><br>```<br>candidate_offers.creator = candidate_applications.postingOwner<br>```<br><br>```<br>candidate_offers.creator = candidate_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>candidate_offers.creator = candidate_applications.user<br>``` |
| [candidate_referrals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-referrals) | ```<br>candidate_offers.creator = candidate_referrals.referrer<br>```<br><br>```<br>candidate_offers.creator = candidate_referrals.user<br>``` |
| [candidates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidates) | ```<br>candidate_offers.creator = candidates.followers<br>```<br><br>```<br>candidate_offers.creator = candidates.owner<br>```<br><br>```<br>candidate_offers.creator = candidates.stageChanges.userId<br>``` |
| [opportunities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunities) | ```<br>candidate_offers.creator = opportunities.followers<br>```<br><br>```<br>candidate_offers.creator = opportunities.owner<br>```<br><br>```<br>candidate_offers.creator = opportunities.stageChanges.userId<br>``` |
| [opportunity_applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-applications) | ```<br>candidate_offers.creator = opportunity_applications.postingHiringManager<br>```<br><br>```<br>candidate_offers.creator = opportunity_applications.postingOwner<br>```<br><br>```<br>candidate_offers.creator = opportunity_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>candidate_offers.creator = opportunity_applications.user<br>``` |
| [opportunity_referrals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-referrals) | ```<br>candidate_offers.creator = opportunity_referrals.referrer<br>```<br><br>```<br>candidate_offers.creator = opportunity_referrals.user<br>``` |
| [postings](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#postings) | ```<br>candidate_offers.creator = postings.followers<br>```<br><br>```<br>candidate_offers.creator = postings.hiringManager<br>```<br><br>```<br>candidate_offers.creator = postings.owner<br>```<br><br>```<br>candidate_offers.creator = postings.user<br>``` |

candidate\_offers table schema

| **approvedAt**<br><br><br>DATE-TIME |
| --- |
| **createdAt**<br><br><br>DATE-TIME |
| **creator**<br><br><br>STRING |
| **fields**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>identifier: STRING</li><li>text: STRING</li><li>value: STRING</li></ul> |
| **id**<br><br><br>STRING |
| **sentAt**<br><br><br>DATE-TIME |
| **signatures**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>email: STRING</li><li>firstOpenedAt: DATE-TIME</li><li>lastOpenedAt: DATE-TIME</li><li>name: STRING</li><li>role: STRING</li><li>signed: BOOLEAN</li><li>signedAt: DATE-TIME</li></ul> |
| **status**<br><br><br>STRING |

### candidate\_referrals

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

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Lever documentation](https://hire.lever.co/developer/documentation#referrals)<br><br>[Lever API method](https://hire.lever.co/developer/documentation#list-all-referrals "Opens in new tab: Lever API method") |

candidate\_referrals table foreign keys

| Join candidate\_referrals with | on |
| --- | --- |
| [opportunity_referrals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-referrals) | ```<br>candidate_referrals.id = opportunity_referrals.id<br>```<br><br>```<br>candidate_referrals.referrer = opportunity_referrals.referrer<br>```<br><br>```<br>candidate_referrals.user = opportunity_referrals.referrer<br>```<br><br>```<br>candidate_referrals.referrer = opportunity_referrals.user<br>```<br><br>```<br>candidate_referrals.user = opportunity_referrals.user<br>``` |
| [candidate_applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-applications) | ```<br>candidate_referrals.referrer = candidate_applications.postingHiringManager<br>```<br><br>```<br>candidate_referrals.user = candidate_applications.postingHiringManager<br>```<br><br>```<br>candidate_referrals.referrer = candidate_applications.postingOwner<br>```<br><br>```<br>candidate_referrals.user = candidate_applications.postingOwner<br>```<br><br>```<br>candidate_referrals.referrer = candidate_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>candidate_referrals.user = candidate_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>candidate_referrals.referrer = candidate_applications.user<br>```<br><br>```<br>candidate_referrals.user = candidate_applications.user<br>``` |
| [candidate_offers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-offers) | ```<br>candidate_referrals.referrer = candidate_offers.creator<br>```<br><br>```<br>candidate_referrals.user = candidate_offers.creator<br>``` |
| [candidates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidates) | ```<br>candidate_referrals.referrer = candidates.followers<br>```<br><br>```<br>candidate_referrals.user = candidates.followers<br>```<br><br>```<br>candidate_referrals.referrer = candidates.owner<br>```<br><br>```<br>candidate_referrals.user = candidates.owner<br>```<br><br>```<br>candidate_referrals.referrer = candidates.stageChanges.userId<br>```<br><br>```<br>candidate_referrals.user = candidates.stageChanges.userId<br>``` |
| [opportunities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunities) | ```<br>candidate_referrals.referrer = opportunities.followers<br>```<br><br>```<br>candidate_referrals.user = opportunities.followers<br>```<br><br>```<br>candidate_referrals.referrer = opportunities.owner<br>```<br><br>```<br>candidate_referrals.user = opportunities.owner<br>```<br><br>```<br>candidate_referrals.referrer = opportunities.stageChanges.userId<br>```<br><br>```<br>candidate_referrals.user = opportunities.stageChanges.userId<br>``` |
| [opportunity_applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-applications) | ```<br>candidate_referrals.referrer = opportunity_applications.postingHiringManager<br>```<br><br>```<br>candidate_referrals.user = opportunity_applications.postingHiringManager<br>```<br><br>```<br>candidate_referrals.referrer = opportunity_applications.postingOwner<br>```<br><br>```<br>candidate_referrals.user = opportunity_applications.postingOwner<br>```<br><br>```<br>candidate_referrals.referrer = opportunity_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>candidate_referrals.user = opportunity_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>candidate_referrals.referrer = opportunity_applications.user<br>```<br><br>```<br>candidate_referrals.user = opportunity_applications.user<br>``` |
| [opportunity_offers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-offers) | ```<br>candidate_referrals.referrer = opportunity_offers.creator<br>```<br><br>```<br>candidate_referrals.user = opportunity_offers.creator<br>``` |
| [postings](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#postings) | ```<br>candidate_referrals.referrer = postings.followers<br>```<br><br>```<br>candidate_referrals.user = postings.followers<br>```<br><br>```<br>candidate_referrals.referrer = postings.hiringManager<br>```<br><br>```<br>candidate_referrals.user = postings.hiringManager<br>```<br><br>```<br>candidate_referrals.referrer = postings.owner<br>```<br><br>```<br>candidate_referrals.user = postings.owner<br>```<br><br>```<br>candidate_referrals.referrer = postings.user<br>```<br><br>```<br>candidate_referrals.user = postings.user<br>``` |
| [requisitions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#requisitions) | ```<br>candidate_referrals.referrer = requisitions.creator<br>```<br><br>```<br>candidate_referrals.user = requisitions.creator<br>```<br><br>```<br>candidate_referrals.referrer = requisitions.hiringManager<br>```<br><br>```<br>candidate_referrals.user = requisitions.hiringManager<br>```<br><br>```<br>candidate_referrals.referrer = requisitions.owner<br>```<br><br>```<br>candidate_referrals.user = requisitions.owner<br>``` |

candidate\_referrals table schema

| **baseTemplateId**<br><br><br>STRING |
| --- |
| **completedAt**<br><br><br>DATE-TIME |
| **createdAt**<br><br><br>DATE-TIME |
| **fields**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>description: STRING</li><li>options: ARRAY, which is also a nested data structure.											<ul><li>text: STRING</li></ul></li><li>prompt: STRING</li><li>required: BOOLEAN</li><li>text: STRING</li><li>type: STRING</li><li>value: STRING</li></ul> |
| **id**<br><br><br>STRING |
| **instructions**<br><br><br>STRING |
| **referrer**<br><br><br>STRING |
| **stage**<br><br><br>STRING |
| **text**<br><br><br>STRING |
| **type**<br><br><br>STRING |
| **user**<br><br><br>STRING |

### candidate\_resumes

The `candidate_resumes` table contains info about candidate resumes.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Lever documentation](https://hire.lever.co/developer/documentation#resumes)<br><br>[Lever API method](https://hire.lever.co/developer/documentation#list-all-resumes "Opens in new tab: Lever API method") |

candidate\_resumes table foreign keys

| Join candidate\_resumes with | on |
| --- | --- |
| [opportunity_resumes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-resumes) | ```<br>candidate_resumes.id = opportunity_resumes.id<br>``` |

candidate\_resumes table schema

| **createdAt**<br><br><br>DATE-TIME |
| --- |
| **file**<br><br><br>OBJECT<br><br>This is a nested data structure. |
| **id**<br><br><br>STRING |
| **parsedData**<br><br><br>OBJECT<br><br>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** | [Lever documentation](https://hire.lever.co/developer/documentation#candidates)<br><br>[Lever API method](https://hire.lever.co/developer/documentation#list-all-candidates "Opens in new tab: Lever API method") |

candidates table foreign keys

| Join candidates with | on |
| --- | --- |
| [archive_reasons](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#archive-reasons) | ```<br>candidates.archived.reason = archive_reasons.id<br>``` |
| [candidate_applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-applications) | ```<br>candidates.archived.reason = candidate_applications.archived.reason<br>```<br><br>```<br>candidates.applications = candidate_applications.id<br>```<br><br>```<br>candidates.id = candidate_applications.candidateId<br>```<br><br>```<br>candidates.followers = candidate_applications.postingHiringManager<br>```<br><br>```<br>candidates.owner = candidate_applications.postingHiringManager<br>```<br><br>```<br>candidates.stageChanges.userId = candidate_applications.postingHiringManager<br>```<br><br>```<br>candidates.followers = candidate_applications.postingOwner<br>```<br><br>```<br>candidates.owner = candidate_applications.postingOwner<br>```<br><br>```<br>candidates.stageChanges.userId = candidate_applications.postingOwner<br>```<br><br>```<br>candidates.followers = candidate_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>candidates.owner = candidate_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>candidates.stageChanges.userId = candidate_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>candidates.followers = candidate_applications.user<br>```<br><br>```<br>candidates.owner = candidate_applications.user<br>```<br><br>```<br>candidates.stageChanges.userId = candidate_applications.user<br>``` |
| [opportunity_applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-applications) | ```<br>candidates.archived.reason = opportunity_applications.archived.reason<br>```<br><br>```<br>candidates.applications = opportunity_applications.id<br>```<br><br>```<br>candidates.id = opportunity_applications.candidateId<br>```<br><br>```<br>candidates.followers = opportunity_applications.postingHiringManager<br>```<br><br>```<br>candidates.owner = opportunity_applications.postingHiringManager<br>```<br><br>```<br>candidates.stageChanges.userId = opportunity_applications.postingHiringManager<br>```<br><br>```<br>candidates.followers = opportunity_applications.postingOwner<br>```<br><br>```<br>candidates.owner = opportunity_applications.postingOwner<br>```<br><br>```<br>candidates.stageChanges.userId = opportunity_applications.postingOwner<br>```<br><br>```<br>candidates.followers = opportunity_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>candidates.owner = opportunity_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>candidates.stageChanges.userId = opportunity_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>candidates.followers = opportunity_applications.user<br>```<br><br>```<br>candidates.owner = opportunity_applications.user<br>```<br><br>```<br>candidates.stageChanges.userId = opportunity_applications.user<br>``` |
| [opportunities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunities) | ```<br>candidates.archived.reason = opportunities.archived.reason<br>```<br><br>```<br>candidates.applications = opportunities.applications<br>```<br><br>```<br>candidates.contact = opportunities.contact<br>```<br><br>```<br>candidates.id = opportunities.id<br>```<br><br>```<br>candidates.stage = opportunities.stage<br>```<br><br>```<br>candidates.stageChanges.toStageId = opportunities.stage<br>```<br><br>```<br>candidates.stage = opportunities.stageChanges.toStageId<br>```<br><br>```<br>candidates.stageChanges.toStageId = opportunities.stageChanges.toStageId<br>```<br><br>```<br>candidates.followers = opportunities.followers<br>```<br><br>```<br>candidates.owner = opportunities.followers<br>```<br><br>```<br>candidates.stageChanges.userId = opportunities.followers<br>```<br><br>```<br>candidates.followers = opportunities.owner<br>```<br><br>```<br>candidates.owner = opportunities.owner<br>```<br><br>```<br>candidates.stageChanges.userId = opportunities.owner<br>```<br><br>```<br>candidates.followers = opportunities.stageChanges.userId<br>```<br><br>```<br>candidates.owner = opportunities.stageChanges.userId<br>```<br><br>```<br>candidates.stageChanges.userId = opportunities.stageChanges.userId<br>``` |
| [opportunity_offers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-offers) | ```<br>candidates.id = opportunity_offers.opportunityId<br>```<br><br>```<br>candidates.followers = opportunity_offers.creator<br>```<br><br>```<br>candidates.owner = opportunity_offers.creator<br>```<br><br>```<br>candidates.stageChanges.userId = opportunity_offers.creator<br>``` |
| [stages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#stages) | ```<br>candidates.stage = stages.id<br>```<br><br>```<br>candidates.stageChanges.toStageId = stages.id<br>``` |
| [candidate_offers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-offers) | ```<br>candidates.followers = candidate_offers.creator<br>```<br><br>```<br>candidates.owner = candidate_offers.creator<br>```<br><br>```<br>candidates.stageChanges.userId = candidate_offers.creator<br>``` |
| [candidate_referrals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-referrals) | ```<br>candidates.followers = candidate_referrals.referrer<br>```<br><br>```<br>candidates.owner = candidate_referrals.referrer<br>```<br><br>```<br>candidates.stageChanges.userId = candidate_referrals.referrer<br>```<br><br>```<br>candidates.followers = candidate_referrals.user<br>```<br><br>```<br>candidates.owner = candidate_referrals.user<br>```<br><br>```<br>candidates.stageChanges.userId = candidate_referrals.user<br>``` |
| [opportunity_referrals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-referrals) | ```<br>candidates.followers = opportunity_referrals.referrer<br>```<br><br>```<br>candidates.owner = opportunity_referrals.referrer<br>```<br><br>```<br>candidates.stageChanges.userId = opportunity_referrals.referrer<br>```<br><br>```<br>candidates.followers = opportunity_referrals.user<br>```<br><br>```<br>candidates.owner = opportunity_referrals.user<br>```<br><br>```<br>candidates.stageChanges.userId = opportunity_referrals.user<br>``` |
| [postings](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#postings) | ```<br>candidates.followers = postings.followers<br>```<br><br>```<br>candidates.owner = postings.followers<br>```<br><br>```<br>candidates.stageChanges.userId = postings.followers<br>```<br><br>```<br>candidates.followers = postings.hiringManager<br>```<br><br>```<br>candidates.owner = postings.hiringManager<br>```<br><br>```<br>candidates.stageChanges.userId = postings.hiringManager<br>```<br><br>```<br>candidates.followers = postings.owner<br>```<br><br>```<br>candidates.owner = postings.owner<br>```<br><br>```<br>candidates.stageChanges.userId = postings.owner<br>```<br><br>```<br>candidates.followers = postings.user<br>```<br><br>```<br>candidates.owner = postings.user<br>```<br><br>```<br>candidates.stageChanges.userId = postings.user<br>``` |
| [requisitions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#requisitions) | ```<br>candidates.followers = requisitions.creator<br>```<br><br>```<br>candidates.owner = requisitions.creator<br>```<br><br>```<br>candidates.stageChanges.userId = requisitions.creator<br>```<br><br>```<br>candidates.followers = requisitions.hiringManager<br>```<br><br>```<br>candidates.owner = requisitions.hiringManager<br>```<br><br>```<br>candidates.stageChanges.userId = requisitions.hiringManager<br>```<br><br>```<br>candidates.followers = requisitions.owner<br>```<br><br>```<br>candidates.owner = requisitions.owner<br>```<br><br>```<br>candidates.stageChanges.userId = requisitions.owner<br>``` |

candidates table schema

| **applications**<br><br><br>ARRAY<br><br>This is a nested data structure. |
| --- |
| **archived**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>archivedAt: DATE-TIME</li><li>reason: STRING</li></ul> |
| **contact**<br><br><br>STRING |
| **createdAt**<br><br><br>DATE-TIME |
| **dataProtection**<br><br><br>OBJECT<br><br>This is a nested data structure. |
| **emails**<br><br><br>ARRAY<br><br>This is a nested data structure. |
| **followers**<br><br><br>ARRAY<br><br>This is a nested data structure. |
| **headline**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **isAnonymized**<br><br><br>BOOLEAN |
| **lastAdvancedAt**<br><br><br>DATE-TIME |
| **lastInteractionAt**<br><br><br>DATE-TIME |
| **links**<br><br><br>ARRAY<br><br>This is a nested data structure. |
| **location**<br><br><br>STRING |
| **name**<br><br><br>STRING |
| **origin**<br><br><br>STRING |
| **owner**<br><br><br>STRING |
| **phones**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>type: STRING</li><li>value: STRING</li></ul> |
| **resume**<br><br><br>OBJECT<br><br>This is a nested data structure. |
| **snoozedUntil**<br><br><br>DATE-TIME |
| **sources**<br><br><br>ARRAY<br><br>This is a nested data structure. |
| **stage**<br><br><br>STRING |
| **stageChanges**<br><br><br>ARRAY<br><br>This is a nested data structure. |
| **tags**<br><br><br>ARRAY<br><br>This is a nested data structure. |
| **urls**<br><br><br>OBJECT<br><br>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** | [Lever documentation](https://hire.lever.co/developer/documentation#opportunities)<br><br>[Lever API method](https://hire.lever.co/developer/documentation#list-all-opportunities "Opens in new tab: Lever API method") |

opportunities table foreign keys

| Join opportunities with | on |
| --- | --- |
| [archive_reasons](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#archive-reasons) | ```<br>opportunities.archived.reason = archive_reasons.id<br>``` |
| [candidate_applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-applications) | ```<br>opportunities.archived.reason = candidate_applications.archived.reason<br>```<br><br>```<br>opportunities.applications = candidate_applications.id<br>```<br><br>```<br>opportunities.id = candidate_applications.candidateId<br>```<br><br>```<br>opportunities.followers = candidate_applications.postingHiringManager<br>```<br><br>```<br>opportunities.owner = candidate_applications.postingHiringManager<br>```<br><br>```<br>opportunities.stageChanges.userId = candidate_applications.postingHiringManager<br>```<br><br>```<br>opportunities.followers = candidate_applications.postingOwner<br>```<br><br>```<br>opportunities.owner = candidate_applications.postingOwner<br>```<br><br>```<br>opportunities.stageChanges.userId = candidate_applications.postingOwner<br>```<br><br>```<br>opportunities.followers = candidate_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>opportunities.owner = candidate_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>opportunities.stageChanges.userId = candidate_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>opportunities.followers = candidate_applications.user<br>```<br><br>```<br>opportunities.owner = candidate_applications.user<br>```<br><br>```<br>opportunities.stageChanges.userId = candidate_applications.user<br>``` |
| [candidates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidates) | ```<br>opportunities.archived.reason = candidates.archived.reason<br>```<br><br>```<br>opportunities.applications = candidates.applications<br>```<br><br>```<br>opportunities.contact = candidates.contact<br>```<br><br>```<br>opportunities.id = candidates.id<br>```<br><br>```<br>opportunities.stage = candidates.stage<br>```<br><br>```<br>opportunities.stageChanges.toStageId = candidates.stage<br>```<br><br>```<br>opportunities.stage = candidates.stageChanges.toStageId<br>```<br><br>```<br>opportunities.stageChanges.toStageId = candidates.stageChanges.toStageId<br>```<br><br>```<br>opportunities.followers = candidates.followers<br>```<br><br>```<br>opportunities.owner = candidates.followers<br>```<br><br>```<br>opportunities.stageChanges.userId = candidates.followers<br>```<br><br>```<br>opportunities.followers = candidates.owner<br>```<br><br>```<br>opportunities.owner = candidates.owner<br>```<br><br>```<br>opportunities.stageChanges.userId = candidates.owner<br>```<br><br>```<br>opportunities.followers = candidates.stageChanges.userId<br>```<br><br>```<br>opportunities.owner = candidates.stageChanges.userId<br>```<br><br>```<br>opportunities.stageChanges.userId = candidates.stageChanges.userId<br>``` |
| [opportunity_applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-applications) | ```<br>opportunities.archived.reason = opportunity_applications.archived.reason<br>```<br><br>```<br>opportunities.applications = opportunity_applications.id<br>```<br><br>```<br>opportunities.id = opportunity_applications.candidateId<br>```<br><br>```<br>opportunities.followers = opportunity_applications.postingHiringManager<br>```<br><br>```<br>opportunities.owner = opportunity_applications.postingHiringManager<br>```<br><br>```<br>opportunities.stageChanges.userId = opportunity_applications.postingHiringManager<br>```<br><br>```<br>opportunities.followers = opportunity_applications.postingOwner<br>```<br><br>```<br>opportunities.owner = opportunity_applications.postingOwner<br>```<br><br>```<br>opportunities.stageChanges.userId = opportunity_applications.postingOwner<br>```<br><br>```<br>opportunities.followers = opportunity_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>opportunities.owner = opportunity_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>opportunities.stageChanges.userId = opportunity_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>opportunities.followers = opportunity_applications.user<br>```<br><br>```<br>opportunities.owner = opportunity_applications.user<br>```<br><br>```<br>opportunities.stageChanges.userId = opportunity_applications.user<br>``` |
| [opportunity_offers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-offers) | ```<br>opportunities.id = opportunity_offers.opportunityId<br>```<br><br>```<br>opportunities.followers = opportunity_offers.creator<br>```<br><br>```<br>opportunities.owner = opportunity_offers.creator<br>```<br><br>```<br>opportunities.stageChanges.userId = opportunity_offers.creator<br>``` |
| [stages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#stages) | ```<br>opportunities.stage = stages.id<br>```<br><br>```<br>opportunities.stageChanges.toStageId = stages.id<br>``` |
| [candidate_offers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-offers) | ```<br>opportunities.followers = candidate_offers.creator<br>```<br><br>```<br>opportunities.owner = candidate_offers.creator<br>```<br><br>```<br>opportunities.stageChanges.userId = candidate_offers.creator<br>``` |
| [candidate_referrals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-referrals) | ```<br>opportunities.followers = candidate_referrals.referrer<br>```<br><br>```<br>opportunities.owner = candidate_referrals.referrer<br>```<br><br>```<br>opportunities.stageChanges.userId = candidate_referrals.referrer<br>```<br><br>```<br>opportunities.followers = candidate_referrals.user<br>```<br><br>```<br>opportunities.owner = candidate_referrals.user<br>```<br><br>```<br>opportunities.stageChanges.userId = candidate_referrals.user<br>``` |
| [opportunity_referrals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-referrals) | ```<br>opportunities.followers = opportunity_referrals.referrer<br>```<br><br>```<br>opportunities.owner = opportunity_referrals.referrer<br>```<br><br>```<br>opportunities.stageChanges.userId = opportunity_referrals.referrer<br>```<br><br>```<br>opportunities.followers = opportunity_referrals.user<br>```<br><br>```<br>opportunities.owner = opportunity_referrals.user<br>```<br><br>```<br>opportunities.stageChanges.userId = opportunity_referrals.user<br>``` |
| [postings](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#postings) | ```<br>opportunities.followers = postings.followers<br>```<br><br>```<br>opportunities.owner = postings.followers<br>```<br><br>```<br>opportunities.stageChanges.userId = postings.followers<br>```<br><br>```<br>opportunities.followers = postings.hiringManager<br>```<br><br>```<br>opportunities.owner = postings.hiringManager<br>```<br><br>```<br>opportunities.stageChanges.userId = postings.hiringManager<br>```<br><br>```<br>opportunities.followers = postings.owner<br>```<br><br>```<br>opportunities.owner = postings.owner<br>```<br><br>```<br>opportunities.stageChanges.userId = postings.owner<br>```<br><br>```<br>opportunities.followers = postings.user<br>```<br><br>```<br>opportunities.owner = postings.user<br>```<br><br>```<br>opportunities.stageChanges.userId = postings.user<br>``` |
| [requisitions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#requisitions) | ```<br>opportunities.followers = requisitions.creator<br>```<br><br>```<br>opportunities.owner = requisitions.creator<br>```<br><br>```<br>opportunities.stageChanges.userId = requisitions.creator<br>```<br><br>```<br>opportunities.followers = requisitions.hiringManager<br>```<br><br>```<br>opportunities.owner = requisitions.hiringManager<br>```<br><br>```<br>opportunities.stageChanges.userId = requisitions.hiringManager<br>```<br><br>```<br>opportunities.followers = requisitions.owner<br>```<br><br>```<br>opportunities.owner = requisitions.owner<br>```<br><br>```<br>opportunities.stageChanges.userId = requisitions.owner<br>``` |

opportunities table schema

| **applications**<br><br><br>ARRAY<br><br>This is a nested data structure. |
| --- |
| **archived**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>archivedAt: DATE-TIME</li><li>reason: STRING</li></ul> |
| **contact**<br><br><br>STRING |
| **createdAt**<br><br><br>DATE-TIME |
| **dataProtection**<br><br><br>OBJECT<br><br>This is a nested data structure.<br><br>This is a nested data structure. |
| **emails**<br><br><br>ARRAY<br><br>This is a nested data structure. |
| **followers**<br><br><br>ARRAY<br><br>This is a nested data structure. |
| **headline**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **isAnonymized**<br><br><br>BOOLEAN |
| **lastAdvancedAt**<br><br><br>DATE-TIME |
| **lastInteractionAt**<br><br><br>DATE-TIME |
| **links**<br><br><br>ARRAY<br><br>This is a nested data structure. |
| **location**<br><br><br>STRING |
| **name**<br><br><br>STRING |
| **origin**<br><br><br>STRING |
| **owner**<br><br><br>STRING |
| **phones**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>type: STRING</li><li>value: STRING</li></ul> |
| **snoozedUntil**<br><br><br>DATE-TIME |
| **sources**<br><br><br>ARRAY<br><br>This is a nested data structure. |
| **stage**<br><br><br>STRING |
| **stageChanges**<br><br><br>ARRAY<br><br>This is a nested data structure. |
| **tags**<br><br><br>ARRAY<br><br>This is a nested data structure. |
| **urls**<br><br><br>OBJECT<br><br>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`](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunities) table must be set to replicate.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Lever API method](https://hire.lever.co/developer/documentation#list-all-opportunities "Opens in new tab: Lever API method") |

opportunity\_applications table foreign keys

| Join opportunity\_applications with | on |
| --- | --- |
| [archive_reasons](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#archive-reasons) | ```<br>opportunity_applications.archived.reason = archive_reasons.id<br>``` |
| [candidate_applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-applications) | ```<br>opportunity_applications.archived.reason = candidate_applications.archived.reason<br>```<br><br>```<br>opportunity_applications.id = candidate_applications.id<br>```<br><br>```<br>opportunity_applications.candidateId = candidate_applications.candidateId<br>```<br><br>```<br>opportunity_applications.posting = candidate_applications.posting<br>```<br><br>```<br>opportunity_applications.requisitionForHire.id = candidate_applications.requisitionForHire.id<br>```<br><br>```<br>opportunity_applications.postingHiringManager = candidate_applications.postingHiringManager<br>```<br><br>```<br>opportunity_applications.postingOwner = candidate_applications.postingHiringManager<br>```<br><br>```<br>opportunity_applications.requisitionForHire.hiringManagerOnHire = candidate_applications.postingHiringManager<br>```<br><br>```<br>opportunity_applications.user = candidate_applications.postingHiringManager<br>```<br><br>```<br>opportunity_applications.postingHiringManager = candidate_applications.postingOwner<br>```<br><br>```<br>opportunity_applications.postingOwner = candidate_applications.postingOwner<br>```<br><br>```<br>opportunity_applications.requisitionForHire.hiringManagerOnHire = candidate_applications.postingOwner<br>```<br><br>```<br>opportunity_applications.user = candidate_applications.postingOwner<br>```<br><br>```<br>opportunity_applications.postingHiringManager = candidate_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>opportunity_applications.postingOwner = candidate_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>opportunity_applications.requisitionForHire.hiringManagerOnHire = candidate_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>opportunity_applications.user = candidate_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>opportunity_applications.postingHiringManager = candidate_applications.user<br>```<br><br>```<br>opportunity_applications.postingOwner = candidate_applications.user<br>```<br><br>```<br>opportunity_applications.requisitionForHire.hiringManagerOnHire = candidate_applications.user<br>```<br><br>```<br>opportunity_applications.user = candidate_applications.user<br>``` |
| [candidates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidates) | ```<br>opportunity_applications.archived.reason = candidates.archived.reason<br>```<br><br>```<br>opportunity_applications.id = candidates.applications<br>```<br><br>```<br>opportunity_applications.candidateId = candidates.id<br>```<br><br>```<br>opportunity_applications.postingHiringManager = candidates.followers<br>```<br><br>```<br>opportunity_applications.postingOwner = candidates.followers<br>```<br><br>```<br>opportunity_applications.requisitionForHire.hiringManagerOnHire = candidates.followers<br>```<br><br>```<br>opportunity_applications.user = candidates.followers<br>```<br><br>```<br>opportunity_applications.postingHiringManager = candidates.owner<br>```<br><br>```<br>opportunity_applications.postingOwner = candidates.owner<br>```<br><br>```<br>opportunity_applications.requisitionForHire.hiringManagerOnHire = candidates.owner<br>```<br><br>```<br>opportunity_applications.user = candidates.owner<br>```<br><br>```<br>opportunity_applications.postingHiringManager = candidates.stageChanges.userId<br>```<br><br>```<br>opportunity_applications.postingOwner = candidates.stageChanges.userId<br>```<br><br>```<br>opportunity_applications.requisitionForHire.hiringManagerOnHire = candidates.stageChanges.userId<br>```<br><br>```<br>opportunity_applications.user = candidates.stageChanges.userId<br>``` |
| [opportunities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunities) | ```<br>opportunity_applications.archived.reason = opportunities.archived.reason<br>```<br><br>```<br>opportunity_applications.id = opportunities.applications<br>```<br><br>```<br>opportunity_applications.candidateId = opportunities.id<br>```<br><br>```<br>opportunity_applications.postingHiringManager = opportunities.followers<br>```<br><br>```<br>opportunity_applications.postingOwner = opportunities.followers<br>```<br><br>```<br>opportunity_applications.requisitionForHire.hiringManagerOnHire = opportunities.followers<br>```<br><br>```<br>opportunity_applications.user = opportunities.followers<br>```<br><br>```<br>opportunity_applications.postingHiringManager = opportunities.owner<br>```<br><br>```<br>opportunity_applications.postingOwner = opportunities.owner<br>```<br><br>```<br>opportunity_applications.requisitionForHire.hiringManagerOnHire = opportunities.owner<br>```<br><br>```<br>opportunity_applications.user = opportunities.owner<br>```<br><br>```<br>opportunity_applications.postingHiringManager = opportunities.stageChanges.userId<br>```<br><br>```<br>opportunity_applications.postingOwner = opportunities.stageChanges.userId<br>```<br><br>```<br>opportunity_applications.requisitionForHire.hiringManagerOnHire = opportunities.stageChanges.userId<br>```<br><br>```<br>opportunity_applications.user = opportunities.stageChanges.userId<br>``` |
| [opportunity_offers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-offers) | ```<br>opportunity_applications.candidateId = opportunity_offers.opportunityId<br>```<br><br>```<br>opportunity_applications.posting = opportunity_offers.posting<br>```<br><br>```<br>opportunity_applications.postingHiringManager = opportunity_offers.creator<br>```<br><br>```<br>opportunity_applications.postingOwner = opportunity_offers.creator<br>```<br><br>```<br>opportunity_applications.requisitionForHire.hiringManagerOnHire = opportunity_offers.creator<br>```<br><br>```<br>opportunity_applications.user = opportunity_offers.creator<br>``` |
| [postings](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#postings) | ```<br>opportunity_applications.posting = postings.id<br>```<br><br>```<br>opportunity_applications.postingHiringManager = postings.followers<br>```<br><br>```<br>opportunity_applications.postingOwner = postings.followers<br>```<br><br>```<br>opportunity_applications.requisitionForHire.hiringManagerOnHire = postings.followers<br>```<br><br>```<br>opportunity_applications.user = postings.followers<br>```<br><br>```<br>opportunity_applications.postingHiringManager = postings.hiringManager<br>```<br><br>```<br>opportunity_applications.postingOwner = postings.hiringManager<br>```<br><br>```<br>opportunity_applications.requisitionForHire.hiringManagerOnHire = postings.hiringManager<br>```<br><br>```<br>opportunity_applications.user = postings.hiringManager<br>```<br><br>```<br>opportunity_applications.postingHiringManager = postings.owner<br>```<br><br>```<br>opportunity_applications.postingOwner = postings.owner<br>```<br><br>```<br>opportunity_applications.requisitionForHire.hiringManagerOnHire = postings.owner<br>```<br><br>```<br>opportunity_applications.user = postings.owner<br>```<br><br>```<br>opportunity_applications.postingHiringManager = postings.user<br>```<br><br>```<br>opportunity_applications.postingOwner = postings.user<br>```<br><br>```<br>opportunity_applications.requisitionForHire.hiringManagerOnHire = postings.user<br>```<br><br>```<br>opportunity_applications.user = postings.user<br>``` |
| [requisitions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#requisitions) | ```<br>opportunity_applications.posting = requisitions.postings<br>```<br><br>```<br>opportunity_applications.requisitionForHire.id = requisitions.id<br>```<br><br>```<br>opportunity_applications.postingHiringManager = requisitions.creator<br>```<br><br>```<br>opportunity_applications.postingOwner = requisitions.creator<br>```<br><br>```<br>opportunity_applications.requisitionForHire.hiringManagerOnHire = requisitions.creator<br>```<br><br>```<br>opportunity_applications.user = requisitions.creator<br>```<br><br>```<br>opportunity_applications.postingHiringManager = requisitions.hiringManager<br>```<br><br>```<br>opportunity_applications.postingOwner = requisitions.hiringManager<br>```<br><br>```<br>opportunity_applications.requisitionForHire.hiringManagerOnHire = requisitions.hiringManager<br>```<br><br>```<br>opportunity_applications.user = requisitions.hiringManager<br>```<br><br>```<br>opportunity_applications.postingHiringManager = requisitions.owner<br>```<br><br>```<br>opportunity_applications.postingOwner = requisitions.owner<br>```<br><br>```<br>opportunity_applications.requisitionForHire.hiringManagerOnHire = requisitions.owner<br>```<br><br>```<br>opportunity_applications.user = requisitions.owner<br>``` |
| [candidate_offers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-offers) | ```<br>opportunity_applications.postingHiringManager = candidate_offers.creator<br>```<br><br>```<br>opportunity_applications.postingOwner = candidate_offers.creator<br>```<br><br>```<br>opportunity_applications.requisitionForHire.hiringManagerOnHire = candidate_offers.creator<br>```<br><br>```<br>opportunity_applications.user = candidate_offers.creator<br>``` |
| [candidate_referrals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-referrals) | ```<br>opportunity_applications.postingHiringManager = candidate_referrals.referrer<br>```<br><br>```<br>opportunity_applications.postingOwner = candidate_referrals.referrer<br>```<br><br>```<br>opportunity_applications.requisitionForHire.hiringManagerOnHire = candidate_referrals.referrer<br>```<br><br>```<br>opportunity_applications.user = candidate_referrals.referrer<br>```<br><br>```<br>opportunity_applications.postingHiringManager = candidate_referrals.user<br>```<br><br>```<br>opportunity_applications.postingOwner = candidate_referrals.user<br>```<br><br>```<br>opportunity_applications.requisitionForHire.hiringManagerOnHire = candidate_referrals.user<br>```<br><br>```<br>opportunity_applications.user = candidate_referrals.user<br>``` |
| [opportunity_referrals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-referrals) | ```<br>opportunity_applications.postingHiringManager = opportunity_referrals.referrer<br>```<br><br>```<br>opportunity_applications.postingOwner = opportunity_referrals.referrer<br>```<br><br>```<br>opportunity_applications.requisitionForHire.hiringManagerOnHire = opportunity_referrals.referrer<br>```<br><br>```<br>opportunity_applications.user = opportunity_referrals.referrer<br>```<br><br>```<br>opportunity_applications.postingHiringManager = opportunity_referrals.user<br>```<br><br>```<br>opportunity_applications.postingOwner = opportunity_referrals.user<br>```<br><br>```<br>opportunity_applications.requisitionForHire.hiringManagerOnHire = opportunity_referrals.user<br>```<br><br>```<br>opportunity_applications.user = opportunity_referrals.user<br>``` |

opportunity\_applications table schema

| **candidateId**<br><br><br>STRING |
| --- |
| **createdAt**<br><br><br>NUMBER |
| **email**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **name**<br><br><br>STRING |
| **posting**<br><br><br>STRING |
| **type**<br><br><br>STRING |
| **user**<br><br><br>STRING |

### opportunity\_offers

The `opportunity_offers` table contains info about

**Note**: To replicate this table, the [`opportunities`](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunities) table must be set to replicate.

| **Replication Method** | CDC |
| --- | --- |
| **Useful links** | [Lever documentation](https://hire.lever.co/developer/documentation#opportunities)<br><br>[Lever API method](https://hire.lever.co/developer/documentation#list-all-opportunities "Opens in new tab: Lever API method") |

opportunity\_offers table foreign keys

| Join opportunity\_offers with | on |
| --- | --- |
| [candidate_offers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-offers) | ```<br>opportunity_offers.id = candidate_offers.id<br>```<br><br>```<br>opportunity_offers.creator = candidate_offers.creator<br>``` |
| [requisitions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#requisitions) | ```<br>opportunity_offers.id = requisitions.offerIds<br>```<br><br>```<br>opportunity_offers.posting = requisitions.postings<br>```<br><br>```<br>opportunity_offers.creator = requisitions.creator<br>```<br><br>```<br>opportunity_offers.creator = requisitions.hiringManager<br>```<br><br>```<br>opportunity_offers.creator = requisitions.owner<br>``` |
| [candidate_applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-applications) | ```<br>opportunity_offers.opportunityId = candidate_applications.candidateId<br>```<br><br>```<br>opportunity_offers.posting = candidate_applications.posting<br>```<br><br>```<br>opportunity_offers.creator = candidate_applications.postingHiringManager<br>```<br><br>```<br>opportunity_offers.creator = candidate_applications.postingOwner<br>```<br><br>```<br>opportunity_offers.creator = candidate_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>opportunity_offers.creator = candidate_applications.user<br>``` |
| [candidates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidates) | ```<br>opportunity_offers.opportunityId = candidates.id<br>```<br><br>```<br>opportunity_offers.creator = candidates.followers<br>```<br><br>```<br>opportunity_offers.creator = candidates.owner<br>```<br><br>```<br>opportunity_offers.creator = candidates.stageChanges.userId<br>``` |
| [opportunity_applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-applications) | ```<br>opportunity_offers.opportunityId = opportunity_applications.candidateId<br>```<br><br>```<br>opportunity_offers.posting = opportunity_applications.posting<br>```<br><br>```<br>opportunity_offers.creator = opportunity_applications.postingHiringManager<br>```<br><br>```<br>opportunity_offers.creator = opportunity_applications.postingOwner<br>```<br><br>```<br>opportunity_offers.creator = opportunity_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>opportunity_offers.creator = opportunity_applications.user<br>``` |
| [opportunities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunities) | ```<br>opportunity_offers.opportunityId = opportunities.id<br>```<br><br>```<br>opportunity_offers.creator = opportunities.followers<br>```<br><br>```<br>opportunity_offers.creator = opportunities.owner<br>```<br><br>```<br>opportunity_offers.creator = opportunities.stageChanges.userId<br>``` |
| [postings](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#postings) | ```<br>opportunity_offers.posting = postings.id<br>```<br><br>```<br>opportunity_offers.creator = postings.followers<br>```<br><br>```<br>opportunity_offers.creator = postings.hiringManager<br>```<br><br>```<br>opportunity_offers.creator = postings.owner<br>```<br><br>```<br>opportunity_offers.creator = postings.user<br>``` |
| [candidate_referrals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-referrals) | ```<br>opportunity_offers.creator = candidate_referrals.referrer<br>```<br><br>```<br>opportunity_offers.creator = candidate_referrals.user<br>``` |
| [opportunity_referrals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-referrals) | ```<br>opportunity_offers.creator = opportunity_referrals.referrer<br>```<br><br>```<br>opportunity_offers.creator = opportunity_referrals.user<br>``` |

opportunity\_offers table schema

| **approved**<br><br><br>BOOLEAN |
| --- |
| **approvedAt**<br><br><br>DATE-TIME |
| **createdAt**<br><br><br>DATE-TIME |
| **creator**<br><br><br>STRING |
| **fields**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>identifier: STRING</li><li>text: STRING</li><li>value: STRING</li></ul> |
| **id**<br><br><br>STRING |
| **opportunityId**<br><br><br>STRING |
| **posting**<br><br><br>STRING |
| **sentAt**<br><br><br>DATE-TIME |
| **sentDocument**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>downloadUrl: STRING</li><li>fileName: STRING</li><li>uploadedAt: DATE-TIME</li></ul> |
| **signatures**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>candidate: OBJECT, which is also a nested data structure.											<ul><li>email: STRING</li><li>firstOpenedAt: DATE-TIME</li><li>lastOpenedAt: DATE-TIME</li><li>name: STRING</li><li>role: STRING</li><li>signed: BOOLEAN</li><li>signedAt: DATE-TIME</li></ul></li><li>email: STRING</li><li>firstOpenedAt: DATE-TIME</li><li>lastOpenedAt: DATE-TIME</li><li>name: STRING</li><li>role: STRING</li><li>signed: BOOLEAN</li><li>signedAt: DATE-TIME</li></ul> |
| **signedDocument**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>downloadUrl: STRING</li><li>fileName: STRING</li><li>uploadedAt: DATE-TIME</li></ul> |
| **status**<br><br><br>STRING |

### opportunity\_referrals

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

**Note**: To replicate this table, the [`opportunities`](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunities) table must be set to replicate.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Lever documentation](https://hire.lever.co/developer/documentation#opportunities)<br><br>[Lever API method](https://hire.lever.co/developer/documentation#list-all-opportunities "Opens in new tab: Lever API method") |

opportunity\_referrals table foreign keys

| Join opportunity\_referrals with | on |
| --- | --- |
| [candidate_referrals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-referrals) | ```<br>opportunity_referrals.id = candidate_referrals.id<br>```<br><br>```<br>opportunity_referrals.referrer = candidate_referrals.referrer<br>```<br><br>```<br>opportunity_referrals.user = candidate_referrals.referrer<br>```<br><br>```<br>opportunity_referrals.referrer = candidate_referrals.user<br>```<br><br>```<br>opportunity_referrals.user = candidate_referrals.user<br>``` |
| [candidate_applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-applications) | ```<br>opportunity_referrals.referrer = candidate_applications.postingHiringManager<br>```<br><br>```<br>opportunity_referrals.user = candidate_applications.postingHiringManager<br>```<br><br>```<br>opportunity_referrals.referrer = candidate_applications.postingOwner<br>```<br><br>```<br>opportunity_referrals.user = candidate_applications.postingOwner<br>```<br><br>```<br>opportunity_referrals.referrer = candidate_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>opportunity_referrals.user = candidate_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>opportunity_referrals.referrer = candidate_applications.user<br>```<br><br>```<br>opportunity_referrals.user = candidate_applications.user<br>``` |
| [candidate_offers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-offers) | ```<br>opportunity_referrals.referrer = candidate_offers.creator<br>```<br><br>```<br>opportunity_referrals.user = candidate_offers.creator<br>``` |
| [candidates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidates) | ```<br>opportunity_referrals.referrer = candidates.followers<br>```<br><br>```<br>opportunity_referrals.user = candidates.followers<br>```<br><br>```<br>opportunity_referrals.referrer = candidates.owner<br>```<br><br>```<br>opportunity_referrals.user = candidates.owner<br>```<br><br>```<br>opportunity_referrals.referrer = candidates.stageChanges.userId<br>```<br><br>```<br>opportunity_referrals.user = candidates.stageChanges.userId<br>``` |
| [opportunities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunities) | ```<br>opportunity_referrals.referrer = opportunities.followers<br>```<br><br>```<br>opportunity_referrals.user = opportunities.followers<br>```<br><br>```<br>opportunity_referrals.referrer = opportunities.owner<br>```<br><br>```<br>opportunity_referrals.user = opportunities.owner<br>```<br><br>```<br>opportunity_referrals.referrer = opportunities.stageChanges.userId<br>```<br><br>```<br>opportunity_referrals.user = opportunities.stageChanges.userId<br>``` |
| [opportunity_applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-applications) | ```<br>opportunity_referrals.referrer = opportunity_applications.postingHiringManager<br>```<br><br>```<br>opportunity_referrals.user = opportunity_applications.postingHiringManager<br>```<br><br>```<br>opportunity_referrals.referrer = opportunity_applications.postingOwner<br>```<br><br>```<br>opportunity_referrals.user = opportunity_applications.postingOwner<br>```<br><br>```<br>opportunity_referrals.referrer = opportunity_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>opportunity_referrals.user = opportunity_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>opportunity_referrals.referrer = opportunity_applications.user<br>```<br><br>```<br>opportunity_referrals.user = opportunity_applications.user<br>``` |
| [opportunity_offers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-offers) | ```<br>opportunity_referrals.referrer = opportunity_offers.creator<br>```<br><br>```<br>opportunity_referrals.user = opportunity_offers.creator<br>``` |
| [postings](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#postings) | ```<br>opportunity_referrals.referrer = postings.followers<br>```<br><br>```<br>opportunity_referrals.user = postings.followers<br>```<br><br>```<br>opportunity_referrals.referrer = postings.hiringManager<br>```<br><br>```<br>opportunity_referrals.user = postings.hiringManager<br>```<br><br>```<br>opportunity_referrals.referrer = postings.owner<br>```<br><br>```<br>opportunity_referrals.user = postings.owner<br>```<br><br>```<br>opportunity_referrals.referrer = postings.user<br>```<br><br>```<br>opportunity_referrals.user = postings.user<br>``` |
| [requisitions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#requisitions) | ```<br>opportunity_referrals.referrer = requisitions.creator<br>```<br><br>```<br>opportunity_referrals.user = requisitions.creator<br>```<br><br>```<br>opportunity_referrals.referrer = requisitions.hiringManager<br>```<br><br>```<br>opportunity_referrals.user = requisitions.hiringManager<br>```<br><br>```<br>opportunity_referrals.referrer = requisitions.owner<br>```<br><br>```<br>opportunity_referrals.user = requisitions.owner<br>``` |

opportunity\_referrals table schema

| **baseTemplateId**<br><br><br>STRING |
| --- |
| **completedAt**<br><br><br>DATE-TIME |
| **createdAt**<br><br><br>DATE-TIME |
| **fields**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>description: STRING</li><li>options: ARRAY, which is also a nested data structure.											<ul><li>text: STRING</li></ul></li><li>prompt: STRING</li><li>required: BOOLEAN</li><li>text: STRING</li><li>type: STRING</li><li>value: STRING</li></ul> |
| **id**<br><br><br>STRING |
| **instructions**<br><br><br>STRING |
| **referrer**<br><br><br>STRING |
| **stage**<br><br><br>STRING |
| **text**<br><br><br>STRING |
| **type**<br><br><br>STRING |
| **user**<br><br><br>STRING |

### opportunity\_resumes

The `opportunity_resumes` table contains info about candidate resumes.

**Note**: To replicate this table, the [`opportunities`](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunities) table must be set to replicate.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Lever documentation](https://hire.lever.co/developer/documentation#opportunities)<br><br>[Lever API method](https://hire.lever.co/developer/documentation#list-all-opportunities "Opens in new tab: Lever API method") |

opportunity\_resumes table foreign keys

| Join opportunity\_resumes with | on |
| --- | --- |
| [candidate_resumes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-resumes) | ```<br>opportunity_resumes.id = candidate_resumes.id<br>``` |

opportunity\_resumes table schema

| **createdAt**<br><br><br>DATE-TIME |
| --- |
| **file**<br><br><br>OBJECT<br><br>This is a nested data structure. |
| **id**<br><br><br>STRING |
| **parsedData**<br><br><br>OBJECT<br><br>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](https://hire.lever.co/developer/documentation#postings)<br><br>[Lever API method](https://hire.lever.co/developer/documentation#list-all-postings "Opens in new tab: Lever API method") |

postings table foreign keys

| Join postings with | on |
| --- | --- |
| [candidate_applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-applications) | ```<br>postings.id = candidate_applications.posting<br>```<br><br>```<br>postings.followers = candidate_applications.postingHiringManager<br>```<br><br>```<br>postings.hiringManager = candidate_applications.postingHiringManager<br>```<br><br>```<br>postings.owner = candidate_applications.postingHiringManager<br>```<br><br>```<br>postings.user = candidate_applications.postingHiringManager<br>```<br><br>```<br>postings.followers = candidate_applications.postingOwner<br>```<br><br>```<br>postings.hiringManager = candidate_applications.postingOwner<br>```<br><br>```<br>postings.owner = candidate_applications.postingOwner<br>```<br><br>```<br>postings.user = candidate_applications.postingOwner<br>```<br><br>```<br>postings.followers = candidate_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>postings.hiringManager = candidate_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>postings.owner = candidate_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>postings.user = candidate_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>postings.followers = candidate_applications.user<br>```<br><br>```<br>postings.hiringManager = candidate_applications.user<br>```<br><br>```<br>postings.owner = candidate_applications.user<br>```<br><br>```<br>postings.user = candidate_applications.user<br>``` |
| [opportunity_applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-applications) | ```<br>postings.id = opportunity_applications.posting<br>```<br><br>```<br>postings.followers = opportunity_applications.postingHiringManager<br>```<br><br>```<br>postings.hiringManager = opportunity_applications.postingHiringManager<br>```<br><br>```<br>postings.owner = opportunity_applications.postingHiringManager<br>```<br><br>```<br>postings.user = opportunity_applications.postingHiringManager<br>```<br><br>```<br>postings.followers = opportunity_applications.postingOwner<br>```<br><br>```<br>postings.hiringManager = opportunity_applications.postingOwner<br>```<br><br>```<br>postings.owner = opportunity_applications.postingOwner<br>```<br><br>```<br>postings.user = opportunity_applications.postingOwner<br>```<br><br>```<br>postings.followers = opportunity_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>postings.hiringManager = opportunity_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>postings.owner = opportunity_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>postings.user = opportunity_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>postings.followers = opportunity_applications.user<br>```<br><br>```<br>postings.hiringManager = opportunity_applications.user<br>```<br><br>```<br>postings.owner = opportunity_applications.user<br>```<br><br>```<br>postings.user = opportunity_applications.user<br>``` |
| [opportunity_offers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-offers) | ```<br>postings.id = opportunity_offers.posting<br>```<br><br>```<br>postings.followers = opportunity_offers.creator<br>```<br><br>```<br>postings.hiringManager = opportunity_offers.creator<br>```<br><br>```<br>postings.owner = opportunity_offers.creator<br>```<br><br>```<br>postings.user = opportunity_offers.creator<br>``` |
| [requisitions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#requisitions) | ```<br>postings.id = requisitions.postings<br>```<br><br>```<br>postings.followers = requisitions.creator<br>```<br><br>```<br>postings.hiringManager = requisitions.creator<br>```<br><br>```<br>postings.owner = requisitions.creator<br>```<br><br>```<br>postings.user = requisitions.creator<br>```<br><br>```<br>postings.followers = requisitions.hiringManager<br>```<br><br>```<br>postings.hiringManager = requisitions.hiringManager<br>```<br><br>```<br>postings.owner = requisitions.hiringManager<br>```<br><br>```<br>postings.user = requisitions.hiringManager<br>```<br><br>```<br>postings.followers = requisitions.owner<br>```<br><br>```<br>postings.hiringManager = requisitions.owner<br>```<br><br>```<br>postings.owner = requisitions.owner<br>```<br><br>```<br>postings.user = requisitions.owner<br>``` |
| [candidate_offers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-offers) | ```<br>postings.followers = candidate_offers.creator<br>```<br><br>```<br>postings.hiringManager = candidate_offers.creator<br>```<br><br>```<br>postings.owner = candidate_offers.creator<br>```<br><br>```<br>postings.user = candidate_offers.creator<br>``` |
| [candidate_referrals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-referrals) | ```<br>postings.followers = candidate_referrals.referrer<br>```<br><br>```<br>postings.hiringManager = candidate_referrals.referrer<br>```<br><br>```<br>postings.owner = candidate_referrals.referrer<br>```<br><br>```<br>postings.user = candidate_referrals.referrer<br>```<br><br>```<br>postings.followers = candidate_referrals.user<br>```<br><br>```<br>postings.hiringManager = candidate_referrals.user<br>```<br><br>```<br>postings.owner = candidate_referrals.user<br>```<br><br>```<br>postings.user = candidate_referrals.user<br>``` |
| [candidates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidates) | ```<br>postings.followers = candidates.followers<br>```<br><br>```<br>postings.hiringManager = candidates.followers<br>```<br><br>```<br>postings.owner = candidates.followers<br>```<br><br>```<br>postings.user = candidates.followers<br>```<br><br>```<br>postings.followers = candidates.owner<br>```<br><br>```<br>postings.hiringManager = candidates.owner<br>```<br><br>```<br>postings.owner = candidates.owner<br>```<br><br>```<br>postings.user = candidates.owner<br>```<br><br>```<br>postings.followers = candidates.stageChanges.userId<br>```<br><br>```<br>postings.hiringManager = candidates.stageChanges.userId<br>```<br><br>```<br>postings.owner = candidates.stageChanges.userId<br>```<br><br>```<br>postings.user = candidates.stageChanges.userId<br>``` |
| [opportunities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunities) | ```<br>postings.followers = opportunities.followers<br>```<br><br>```<br>postings.hiringManager = opportunities.followers<br>```<br><br>```<br>postings.owner = opportunities.followers<br>```<br><br>```<br>postings.user = opportunities.followers<br>```<br><br>```<br>postings.followers = opportunities.owner<br>```<br><br>```<br>postings.hiringManager = opportunities.owner<br>```<br><br>```<br>postings.owner = opportunities.owner<br>```<br><br>```<br>postings.user = opportunities.owner<br>```<br><br>```<br>postings.followers = opportunities.stageChanges.userId<br>```<br><br>```<br>postings.hiringManager = opportunities.stageChanges.userId<br>```<br><br>```<br>postings.owner = opportunities.stageChanges.userId<br>```<br><br>```<br>postings.user = opportunities.stageChanges.userId<br>``` |
| [opportunity_referrals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-referrals) | ```<br>postings.followers = opportunity_referrals.referrer<br>```<br><br>```<br>postings.hiringManager = opportunity_referrals.referrer<br>```<br><br>```<br>postings.owner = opportunity_referrals.referrer<br>```<br><br>```<br>postings.user = opportunity_referrals.referrer<br>```<br><br>```<br>postings.followers = opportunity_referrals.user<br>```<br><br>```<br>postings.hiringManager = opportunity_referrals.user<br>```<br><br>```<br>postings.owner = opportunity_referrals.user<br>```<br><br>```<br>postings.user = opportunity_referrals.user<br>``` |

postings table schema

| **categories**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>commitment: STRING</li><li>department: STRING</li><li>level: STRING</li><li>location: STRING</li><li>team: STRING</li></ul> |
| --- |
| **content**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>closing: STRING</li><li>customQuestions: ARRAY, which is also a nested data structure.</li><li>description: STRING</li><li>lists: ARRAY, which is also a nested data structure.											<ul><li>content: STRING</li><li>text: STRING</li></ul></li></ul> |
| **createdAt**<br><br><br>DATE-TIME |
| **distributionChannels**<br><br><br>ARRAY<br><br>This is a nested data structure. |
| **followers**<br><br><br>STRING |
| **hiringManager**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **owner**<br><br><br>STRING |
| **reqCode**<br><br><br>STRING |
| **state**<br><br><br>STRING |
| **tags**<br><br><br>ARRAY<br><br>This is a nested data structure. |
| **text**<br><br><br>STRING |
| **updatedAt**<br><br><br>DATE-TIME |
| **urls**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>apply: STRING</li><li>list: STRING</li><li>show: STRING</li></ul> |
| **user**<br><br><br>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](https://hire.lever.co/developer/documentation#requisitions)<br><br>[Lever API method](https://hire.lever.co/developer/documentation#list-all-requisitions "Opens in new tab: Lever API method") |

requisitions table foreign keys

| Join requisitions with | on |
| --- | --- |
| [candidate_offers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-offers) | ```<br>requisitions.offerIds = candidate_offers.id<br>```<br><br>```<br>requisitions.creator = candidate_offers.creator<br>```<br><br>```<br>requisitions.hiringManager = candidate_offers.creator<br>```<br><br>```<br>requisitions.owner = candidate_offers.creator<br>``` |
| [opportunity_offers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-offers) | ```<br>requisitions.offerIds = opportunity_offers.id<br>```<br><br>```<br>requisitions.postings = opportunity_offers.posting<br>```<br><br>```<br>requisitions.creator = opportunity_offers.creator<br>```<br><br>```<br>requisitions.hiringManager = opportunity_offers.creator<br>```<br><br>```<br>requisitions.owner = opportunity_offers.creator<br>``` |
| [candidate_applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-applications) | ```<br>requisitions.postings = candidate_applications.posting<br>```<br><br>```<br>requisitions.id = candidate_applications.requisitionForHire.id<br>```<br><br>```<br>requisitions.creator = candidate_applications.postingHiringManager<br>```<br><br>```<br>requisitions.hiringManager = candidate_applications.postingHiringManager<br>```<br><br>```<br>requisitions.owner = candidate_applications.postingHiringManager<br>```<br><br>```<br>requisitions.creator = candidate_applications.postingOwner<br>```<br><br>```<br>requisitions.hiringManager = candidate_applications.postingOwner<br>```<br><br>```<br>requisitions.owner = candidate_applications.postingOwner<br>```<br><br>```<br>requisitions.creator = candidate_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>requisitions.hiringManager = candidate_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>requisitions.owner = candidate_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>requisitions.creator = candidate_applications.user<br>```<br><br>```<br>requisitions.hiringManager = candidate_applications.user<br>```<br><br>```<br>requisitions.owner = candidate_applications.user<br>``` |
| [opportunity_applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-applications) | ```<br>requisitions.postings = opportunity_applications.posting<br>```<br><br>```<br>requisitions.id = opportunity_applications.requisitionForHire.id<br>```<br><br>```<br>requisitions.creator = opportunity_applications.postingHiringManager<br>```<br><br>```<br>requisitions.hiringManager = opportunity_applications.postingHiringManager<br>```<br><br>```<br>requisitions.owner = opportunity_applications.postingHiringManager<br>```<br><br>```<br>requisitions.creator = opportunity_applications.postingOwner<br>```<br><br>```<br>requisitions.hiringManager = opportunity_applications.postingOwner<br>```<br><br>```<br>requisitions.owner = opportunity_applications.postingOwner<br>```<br><br>```<br>requisitions.creator = opportunity_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>requisitions.hiringManager = opportunity_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>requisitions.owner = opportunity_applications.requisitionForHire.hiringManagerOnHire<br>```<br><br>```<br>requisitions.creator = opportunity_applications.user<br>```<br><br>```<br>requisitions.hiringManager = opportunity_applications.user<br>```<br><br>```<br>requisitions.owner = opportunity_applications.user<br>``` |
| [postings](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#postings) | ```<br>requisitions.postings = postings.id<br>```<br><br>```<br>requisitions.creator = postings.followers<br>```<br><br>```<br>requisitions.hiringManager = postings.followers<br>```<br><br>```<br>requisitions.owner = postings.followers<br>```<br><br>```<br>requisitions.creator = postings.hiringManager<br>```<br><br>```<br>requisitions.hiringManager = postings.hiringManager<br>```<br><br>```<br>requisitions.owner = postings.hiringManager<br>```<br><br>```<br>requisitions.creator = postings.owner<br>```<br><br>```<br>requisitions.hiringManager = postings.owner<br>```<br><br>```<br>requisitions.owner = postings.owner<br>```<br><br>```<br>requisitions.creator = postings.user<br>```<br><br>```<br>requisitions.hiringManager = postings.user<br>```<br><br>```<br>requisitions.owner = postings.user<br>``` |
| [candidate_referrals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidate-referrals) | ```<br>requisitions.creator = candidate_referrals.referrer<br>```<br><br>```<br>requisitions.hiringManager = candidate_referrals.referrer<br>```<br><br>```<br>requisitions.owner = candidate_referrals.referrer<br>```<br><br>```<br>requisitions.creator = candidate_referrals.user<br>```<br><br>```<br>requisitions.hiringManager = candidate_referrals.user<br>```<br><br>```<br>requisitions.owner = candidate_referrals.user<br>``` |
| [candidates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidates) | ```<br>requisitions.creator = candidates.followers<br>```<br><br>```<br>requisitions.hiringManager = candidates.followers<br>```<br><br>```<br>requisitions.owner = candidates.followers<br>```<br><br>```<br>requisitions.creator = candidates.owner<br>```<br><br>```<br>requisitions.hiringManager = candidates.owner<br>```<br><br>```<br>requisitions.owner = candidates.owner<br>```<br><br>```<br>requisitions.creator = candidates.stageChanges.userId<br>```<br><br>```<br>requisitions.hiringManager = candidates.stageChanges.userId<br>```<br><br>```<br>requisitions.owner = candidates.stageChanges.userId<br>``` |
| [opportunities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunities) | ```<br>requisitions.creator = opportunities.followers<br>```<br><br>```<br>requisitions.hiringManager = opportunities.followers<br>```<br><br>```<br>requisitions.owner = opportunities.followers<br>```<br><br>```<br>requisitions.creator = opportunities.owner<br>```<br><br>```<br>requisitions.hiringManager = opportunities.owner<br>```<br><br>```<br>requisitions.owner = opportunities.owner<br>```<br><br>```<br>requisitions.creator = opportunities.stageChanges.userId<br>```<br><br>```<br>requisitions.hiringManager = opportunities.stageChanges.userId<br>```<br><br>```<br>requisitions.owner = opportunities.stageChanges.userId<br>``` |
| [opportunity_referrals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunity-referrals) | ```<br>requisitions.creator = opportunity_referrals.referrer<br>```<br><br>```<br>requisitions.hiringManager = opportunity_referrals.referrer<br>```<br><br>```<br>requisitions.owner = opportunity_referrals.referrer<br>```<br><br>```<br>requisitions.creator = opportunity_referrals.user<br>```<br><br>```<br>requisitions.hiringManager = opportunity_referrals.user<br>```<br><br>```<br>requisitions.owner = opportunity_referrals.user<br>``` |

requisitions table schema

| **backfill**<br><br><br>BOOLEAN |
| --- |
| **createdAt**<br><br><br>DATE-TIME |
| **creator**<br><br><br>STRING |
| **department**<br><br><br>STRING |
| **employmentStatus**<br><br><br>STRING |
| **headcountHired**<br><br><br>INTEGER |
| **headcountTotal**<br><br><br>STRING |
| **hiringManager**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **internalNotes**<br><br><br>STRING |
| **location**<br><br><br>STRING |
| **name**<br><br><br>STRING |
| **offerIds**<br><br><br>ARRAY<br><br>This is a nested data structure. |
| **owner**<br><br><br>STRING |
| **postings**<br><br><br>ARRAY<br><br>This is a nested data structure. |
| **requisitionCode**<br><br><br>STRING |
| **status**<br><br><br>STRING |
| **team**<br><br><br>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](https://hire.lever.co/developer/documentation#sources)<br><br>[Lever API method](https://hire.lever.co/developer/documentation#list-all-sources "Opens in new tab: Lever API method") |

sources table schema

| **count**<br><br><br>INTEGER |
| --- |
| **text**<br><br><br>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** | [Lever documentation](https://hire.lever.co/developer/documentation#stages)<br><br>[Lever API method](https://hire.lever.co/developer/documentation#list-all-stages "Opens in new tab: Lever API method") |

stages table foreign keys

| Join stages with | on |
| --- | --- |
| [candidates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#candidates) | ```<br>stages.id = candidates.stage<br>```<br><br>```<br>stages.id = candidates.stageChanges.toStageId<br>``` |
| [opportunities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Lever.htm#opportunities) | ```<br>stages.id = opportunities.stage<br>```<br><br>```<br>stages.id = opportunities.stageChanges.toStageId<br>``` |

stages table schema

| **id**<br><br><br>STRING |
| --- |
| **text**<br><br><br>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** | [Lever documentation](https://hire.lever.co/developer/documentation#users)<br><br>[Lever API method](https://hire.lever.co/developer/documentation#list-all-users "Opens in new tab: Lever API method") |

users table schema

| **accessRole**<br><br><br>STRING |
| --- |
| **createdAt**<br><br><br>DATE-TIME |
| **deactivatedAt**<br><br><br>DATE-TIME |
| **email**<br><br><br>STRING |
| **externalDirectoryId**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **name**<br><br><br>STRING |
| **photo**<br><br><br>STRING |
| **username**<br><br><br>STRING |