Greenhouse: Interview Enhanced

Description

• Table of scheduled interviews joined with interviewer scorecards. Each record is unique to the interview and interviewer and is enriched with data about the applicant and job.

Supported Data Sources

• Greenhouse

Columns

Type	Name	Description
DATETIME	_fivetran_synced
INTEGER	application_id	Foreign key referencing the APPLICATION that is being interviewed.
DATETIME	created_at	Timestamp of when the interview was created.
DATETIME	end_at	Timestamp of when the interview is scheduled to end. Will be a date if the interview is all-day.
INTEGER	scheduled_interview_id	Unique ID of the scheduled interview.
INTEGER	interview_id	Foreign key referencing the id of the generic INTERVIEW step that this scheduled interview maps to.
INTEGER	location	The location of the interview.
INTEGER	organizer_user_id	Foreign key referencing the USER who organized the interview.
DATETIME	start_at	Timestamp of when the interview is scheduled to start. Will be a date if the interview is all-day.
STRING	status	One of - scheduled, awaiting_feedback, complete.
DATETIME	last_updated_at	Timestamp of when the interview was last updated.
INTEGER	job_stage_id	Foreign key referencing the JOB_STAGE that this interview is associated with.
STRING	interview_name	Title of the interview step.
DECIMAL	duration_interview_minutes	From start the finish, the length of the interview in minutes.
INTEGER	scorecard_id	Unique ID of the scorecard.
INTEGER	candidate_id	Foreign key referencing the CANDIDATE who was interviewed and scored.
STRING	overall_recommendation	One of - definitely_not, no, yes, strong_yes, no_decision.
DATETIME	scorecard_submitted_at	Timestamp of when the scorecard was submitted.
INTEGER	scorecard_submitted_by_user_id	Foreign key referencing the USER who submitted the scorecard.
DATETIME	scorecard_last_updated_at	Timestamp of when the scorecard was last updated.
INTEGER	interviewer_user_id	Foreign key referencing the USER conducting the interview.
STRING	interview_scorecard_key	Key hashed on scheduled_interview_id and interviewer_user_id
STRING	interviewer_name	Full name of the interviewer user.
STRING	scorecard_submitter_name	Full name of the user who submitted the scorecard (either the interviewer or on behalf of the interviewer).
STRING	organizer_name	Full name of the user who organized the interview.
STRING	interviewer_email	Email(s) of the interviewer.
STRING	candidate_name	Full name of the interviewee.
STRING	job_stage	Name of the job stage step that this interview is associated with.
STRING	application_current_job_stage	Current job stage of the application. If this is diferent from job_stage, the candidate advanced after this interview.
STRING	current_application_status	Current status of the application - active, hired, rejected
STRING	job_title	Title of the job role the candidate is interviewing for.
INTEGER	job_id	Foreign key referencing the JOB being interviewed for.
BOOLEAN	interviewer_is_hiring_manager	Boolean that is true if the interviewer is one of the hiring managers for this job.
STRING	hiring_managers	Comma-separated list of the full names of the job's hiring managers.
STRING	recruiter_name	Full name of the interviewee's assigned recruiter.
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	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.