Greenhouse: Application History

Description

• If enabled, table capturing the history of applications as they advance through job stages.

Supported Data Sources

• Greenhouse

Columns

Type	Name	Description
INTEGER	application_id	Foreign key referencing the APPLICATION that was updated.
INTEGER	new_stage_id	Foreign key referencing the JOB_STAGE that the application was advanced to.
STRING	new_status	Status of the application as of this updated.
DATETIME	valid_from	Timestamp of when the application was advanced.
DATETIME	valid_until	Timestamp of when the application was moved to a further stage.
STRING	new_stage	Name of the newly advanced job stage.
STRING	full_name	Full name of the applicant.
STRING	current_status	Current status of the application. One of - active, rejected, hired.
STRING	recruiter_name	Full name of the application's recruiter.
STRING	hiring_managers	Hiring manager(s) for the pursued job.
STRING	sourced_from	Where the application was sourced from.
STRING	sourced_from_type	The category of source that the application came from.
STRING	job_title	Title of the job role the candidate is applying for.
INTEGER	job_id	Foreign key referencing the JOB being applied for.
INTEGER	candidate_id	Foreign key referencing the unique CANDIDATE associated with this application.
INTEGER	days_in_stage	Number of calendar days the application spent in this stage.
STRING	job_departments	Semicolon-separated list of the departments that the job is listed under.
STRING	job_parent_departments	Semicolon-separated list of the parent departments that the job is listed under.
STRING	job_offices	Semicolon-separated list of the offices that the job is listed under.
STRING	candidate_gender	Description of the applicant's gender identity.
STRING	candidate_disability_status	Description of the applicant's disability status.
STRING	candidate_race	Description of applicant's provided race.
STRING	candidate_veteran_status	Description of the applicant's veteran status.
INTEGER	count_activities_in_stage	Total count of the activities performed while the candidate was in this stage.