Lever
## Columns
| Type | Name | Description |
| -------- | ---------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| STRING | opportunity\_id | Unique ID of the opportunity. |
| DATETIME | \_fivetran\_synced | |
| DATETIME | archived\_at | Timestamp of when the opportunity was archived. |
| STRING | archived\_reason\_id | Foreign key referencing the ARCHIVE\_REASON for which the opportunity was archived. |
| STRING | contact\_id | Foreign key referencing the CONTACT info of the candidate applying in this opportunity. |
| DATETIME | created\_at | Timestamp of when the opportunity was created (ie when the candidate clicked "apply" on your company website). |
| BOOLEAN | is\_data\_protection\_contact\_allowed | Boolean that is true if relevant data policy regulations allow for contacting this opportunity's candidate. |
| DATETIME | data\_protection\_contact\_expires\_at | Timestamp of when this permission/data policy expires. |
| BOOLEAN | is\_data\_protection\_store\_allowed | Boolean that is true if relevant data policy regulations allow for storing this opportunity record. |
| DATETIME | data\_protection\_store\_expires\_at | Timestamp of when this permission/data policy expires. |
| STRING | contact\_headline | Contact headline, typically a list of previous companies where the contact has worked or schools that the contact has attended. |
| BOOLEAN | is\_anonymized | Boolean that is true if the opportunity has been anonymized (therefore fully anonymizing the contact and removing their *personal* information). |
| DATETIME | last\_advanced\_at | Timestamp of when the candidate advanced to their current stage in the hiring pipeline. |
| DATETIME | last\_interaction\_at | Timestamp of when the Opportunity profile was last interacted with. See interactions [here](https://help.lever.co/hc/en-us/articles/205697619). |
| INTEGER | contact\_location | Current contact location of the candidate. |
| STRING | contact\_name | Contact full name. |
| STRING | origin | The way in which the opportunity was added to lever. Includes 'agency', 'applied', 'internal', 'referred', 'sourced', and 'university'. |
| STRING | owner\_user\_id | Foreign key referencing the id of the USER who owns this opportunity. |
| DATETIME | snoozed\_until | Timestamp of when the current snooze period of this opportunity ends (if snoozed). |
| STRING | stage\_id | Foreign key referencing the ID of the current stage of the opportunity. |
| DATETIME | updated\_at | Timestamp of when the opportunity was last updated in lever. |
| STRING | application\_id | Unique ID of the application. |
| INTEGER | comments | Any additional comments from the candidate included in the job application. |
| INTEGER | company | The candidate's current company or organization. |
| STRING | posting\_hiring\_manager\_user\_id | Foreign key referencing the id of the USER who is the job posting's hiring manager, at the time the application was submitted. |
| STRING | posting\_id | Foreign key referencing the job POSTING for which the candidate applied. |
| STRING | posting\_owner\_user\_id | Foreign key referencing the id of the USER who owns this posting at the time the candidate applied. |
| STRING | referrer\_user\_id | The user ID of the candidate's referrer. |
| INTEGER | requisition\_id | If the application was archived as hired against a requisition, a foreign key referencing the id of the REQUISITION against which the application was hired. |
| STRING | application\_type | Type of the application. An application can be of type referral, user, or posting. Applications of type referral are created when a user refers a candidate for a job posting. Applications have type user when they are applied manually to a posting in Lever. Applications have type posting when a candidate applies to a job posting through your company's jobs page. |
| STRING | opportunity\_owner\_name | Full name of the user who owns the opportunity in Lever. |
| STRING | referrer\_name | Full name of the user who referred the candidate for this opportunity. |
| STRING | hiring\_manager\_name | Full name of the hiring manager of role for which the opportunity applied. |
| STRING | sources | Aggregated list of the channels through which this opportunity was sourced. |
| STRING | resume\_download\_url | Resume file download URL. |
| STRING | phones | Aggregated list of the contact's phone numbers (with phone types). |
| STRING | emails | Aggregated list of email addresses associated with this contact. |
| STRING | linkedin\_link | Contact URL that contains 'linkedin.com' in it. |
| STRING | github\_link | Contact URL that contains 'github.com' in it. |
| STRING | current\_stage | The stage that the opportunity is currently at in the pipeline. |
| STRING | tags | Aggregated coma-separated list of the tags associated with this opportunity. |
| STRING | archive\_reason | Reason given for archiving this opportunity. |
| STRING | job\_title | Title of the job posting role.Title of the job posting role. |
| STRING | job\_commitment | Tag for job position work type (e.g. Full-time, Part-time, Internship). |
| INTEGER | job\_department | Tag for the department to which the job posting's team belongs, if present. |
| INTEGER | job\_level | Tag for job posting level (e.g. Senior, Junior). Note - this has been deprecated by Lever but is currently maintained for backward compatibility. |
| STRING | job\_location | Tag for job position location. |
| STRING | job\_team | Tag for the team to which the job posting belongs (a sub-category of department). |
| STRING | current\_state\_of\_job\_posting | Current status of the posting, which may include 'published', 'internal' (called 'unlisted' in the UI), 'closed', 'draft', 'pending' (awaiting approval), and 'rejected'. |
| INTEGER | opp\_created\_n\_days\_after\_first\_app | How many days this opportunity was created after the first application was sent to this posting. |
| BOOLEAN | has\_offer | Boolean that is true if the opportunity has been extended an offer. |
| STRING | current\_offer\_status | A string describing the current status of the offer. Can include: draft - the offer is still under construction approval-sent - the offer needs approval approved - the offer has been approved sent - the offer has been sent through Lever sent-manually - the offer has been sent to the candidate outside of Lever opened - the candidate has opened the offer denied - the candidate denied the offer signed - the candidate signed the offer |
| INTEGER | count\_interviews | The number of interviews that have been scheduled for this opportunity. |
| INTEGER | count\_interviewers | Count of how many internal users the opportunity has spoken to via interview. |
| DATETIME | latest\_interview\_scheduled\_at | Timestamp of when the opportunity's most recent (or perhaps future) interview was scheduled for. |
| BOOLEAN | has\_interviewed\_w\_hiring\_manager | Boolean that is true if the opportunity has interviewed with the hiring manager. |
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/lever-opportunity-enhanced.md?ask=