Lever: Opportunity Stage History

Description

• Table capturing each stage that an opportunity has advanced too.

Supported Data Sources

• Lever

Columns

Type	Name	Description
STRING	opportunity_id	Foreign key referencing the id of the OPPORTUNITY.
STRING	opportunity_contact_name	Contact full name.
DATETIME	valid_from	Timestamp of when the opportunity was changed to this stage.
DATETIME	valid_ending_at	Timestamp of when the opportunity left this stage (either by advancing or being archived).
STRING	stage	Name of the stage.
STRING	stage_id	Foreign key referencing the STAGE that the opportunity was changed to.
INTEGER	stage_index_in_pipeline	The index of the stage in the pipeline at the time the stage change occurred.
STRING	updater_user_name	Full name of the user who updated the candidate to this stage.
STRING	archive_reason	Reason that the opportunity was ultimately archived.
STRING	job_title	Title of the job posting role.Title of the job posting role.
INTEGER	job_department	Tag for the department to which the job posting's team belongs, if present.
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	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	application_sources	Aggregated list of the channels through which this opportunity was sourced.
STRING	hiring_manager_name	Full name of the hiring manager of role for which the opportunity applied.
STRING	opportunity_owner_name	Full name of the user who owns the opportunity in Lever.
INTEGER	days_in_stage	The number of calendar days in which the opportunity has remained in this stage (ie until they advanced or were archived).