Lever: Opportunity Enhanced

Description

• Table of unique opportunities.

Supported Data Sources

• 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.
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.