Greenhouse: Application Enhanced

Description

• Table capturing all candidate and prospect applications. Note that prospect applications can be associated with 0-many jobs. Also, a prospect that converts to a candidate application will have 2 records (the difference is is_prospect).

Supported Data Sources

• Greenhouse

Columns

Type	Name	Description
DATETIME	_fivetran_synced
DATETIME	applied_at	Timestamp of when the application was submitted.
INTEGER	candidate_id	Foreign key referencing the CANDIDATE who submitted the application.
INTEGER	credited_to_user_id	Foreign key referencing the USER who will receive credit for this application.
INTEGER	current_stage_id	Foreign key referencing the JOB_STAGE that the application is currently at in the pipeline.
INTEGER	application_id	Unique ID of the application.
DATETIME	last_activity_at	Timestamp of when the last activity was taken on this application.
INTEGER	location_address	The content of the address question on a job post.
BOOLEAN	is_prospect	Boolean that is true if this is a prospect application, which means that the associated person is a prospect and has not yet applied for this job.
INTEGER	prospect_owner_user_id	Foreign key referencing the USER ID of the prospect owner.
INTEGER	prospect_pool_id	Foreign key referencing the PROSPECT_POOL that the application came from.
INTEGER	prospect_stage_id	Foreign key referencing the ID of the application's PROSPECT_POOL_STAGE.
DATETIME	rejected_at	Timestamp of when the application was rejected.
INTEGER	rejected_reason_id	Foreign key referencing the REJECTION_REASON for the application.
INTEGER	source_id	Foreign key referencing the ID of the SOURCE of the application.
STRING	status	One of - active, rejected, hired.
INTEGER	custom_what_is_your_preferred_pronoun_
INTEGER	custom_how_did_you_hear_about_fivetran_
STRING	referrer_name	Full name of the user who is credited with referring this application.
STRING	prospect_owner_name	Full name of the prospect owner.
STRING	current_company	The company at which the candidate currently works.
INTEGER	coordinator_user_id	Foreign key referencing the USER who is responsible for coordinating this candidate.
STRING	full_name	First and last name of the candidate.
BOOLEAN	is_private	Boolean that is true if the candidate is private.
INTEGER	recruiter_user_id	Foreign key referencing the USER who is the recruiter assigned to this candidate.
INTEGER	current_title	The candidate's current title.
DATETIME	last_updated_at	Timestamp of when the candidate profile was last updated.
STRING	phone	Comma-separated aggregated list of the candidate's phone numbers and the type of phone they are.
STRING	email	Comma-separated list of the candidate's email addresses.
STRING	resume_url	URL of the candidate's most recently uploaded resume.
STRING	linkedin_url	URL of the candidate's most recently added LinkedIn link.
STRING	github_url	URL of the candidate's most recently added Github link.
STRING	coordinator_name	Full name of the user who is responsible for coordinating with this candidate.
STRING	recruiter_name	Full name of the candidate's assigned recruiter.
STRING	coordinator_email	Email of the user who is responsible for coordinating with this candidate.
STRING	recruiter_email	Email of the candidate's assigned recruiter.
DATETIME	candidate_created_at	Timestamp of when the candidate profile was created.
STRING	candidate_tags	Comma-separated list of tags attached to this candidate.
STRING	current_job_stage	Current stage that the application is at in the hiring pipeline.
STRING	sourced_from	Where the application was sourced from.
STRING	sourced_from_type	The category of source that the application came from.
INTEGER	count_activities	Total count of activities completed on this candidate's profile.
STRING	job_title	Title of the job role the candidate is applying for.
STRING	job_status	Current status of the job being applied for.
STRING	hiring_managers	Comma-separated list of the full names of the job's hiring managers.
INTEGER	job_id	Foreign key referencing the JOB being applied for.
INTEGER	job_requisition_id	The id of the requisition corresponding to this job posting, if applicable.
STRING	job_sourcers	Comma-separated list of the full names of the job's recruiting sourcers.
STRING	job_offices	Semicolon-separated list of the offices that the job is listed under.
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	prospect_pool	Name given to the applicant's prospect pool.
STRING	prospect_stage	Current stage of the applicant within its prospect pool, if applicable.
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.
STRING	application_job_key	Unique key hashed on application_id and job_id. This has to be done as the table contains both candidates and prospects.
BOOLEAN	has_interviewed_w_hiring_manager	Boolean that is true if the applicant has interviewed with one of the job's hiring managers.
INTEGER	count_interviews	Total number of interviews had (1 interview with a panel of 3 interviewers = 1).
INTEGER	count_interview_scorecards	Count of feedback scorecards given (1 interview with a panel of 3 interviewers = 3).
INTEGER	count_distinct_interviewers	Count of internal users that the candidate has interviewed with.
DATETIME	latest_interview_scheduled_at	The latest time that the candidate was scheduled to be interviewed at (can be in the future).