Lever: Interview Enhanced

Description

• Table in which each row is a unique interview-feedback combo. Interviews without feedback appear here as well.

Supported Data Sources

• Lever

Columns

Type	Name	Description
STRING	opportunity_id	Foreign key referencing the OPPORTUNITY being interviewed for.
DATETIME	_fivetran_synced
DATETIME	canceled_at	Timestamp of when the interview was canceled.
DATETIME	created_at	Timestamp of when the interview was created.
STRING	creator_user_id	Foreign key referencing the USER who created the interview in lever.
DATETIME	occurred_at	Date + time at which the interview was set to occur.
INTEGER	duration_minutes	Interview duration in minutes, minimum value is 1.
STRING	feedback_reminder_frequency	Frequency of feedback reminders (i.e. once, daily, frequently, none). Defaults to 'frequently' which is every 6 hours.
INTEGER	gcal_event_url	Google calendar event url.
STRING	interview_id	Unique ID of the interview.
STRING	location	Interview location. Usually the name of a booked conference room but can also be a phone number to call.
INTEGER	note	Interview note.
STRING	panel_id	Unique id of the PANEL this interview belongs to.
STRING	opportunity_stage_id	Foreign key referencing the STAGE that the candidate was in at the time the interview was scheduled.
STRING	subject	Subject of the interview.
STRING	timezone	Name of timezone in which interview was scheduled to occur.
STRING	feedback_form_id	Unique id of the feedback form.
STRING	feedback_completer_user_id	Foreign key referencing the USER who completed the feedback.
DATETIME	feedback_completed_at	Timestamp of when the feedback form was completed.
INTEGER	feedback_form_instructions	Guidelines given for how give a feedback score.
STRING	score_system_value	Overall rating (1-4 scale) to the candidate.
STRING	feedback_form_title	Form title. This can be edited in Feedback and Form Settings.
STRING	interviewer_user_id	Foreign key referencing the USER that interviewed the candidate.
STRING	inteviewer_name	Full name of the interviewer.
STRING	interviewer_email	Email associated with the interviewer.
STRING	feedback_completer_name	Full name of the user who completed the feedback form.
STRING	interview_coordinator_name	Full name of the user who created the interviewer in Lever.
DATETIME	ended_at	Timestamp of when the interview was scheduled to end.
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.
BOOLEAN	interviewer_is_hiring_manager	Boolean that is true if the interviewer is also the hiring manager of this position.
STRING	interviewee_name	Full name of the interviewee candidate.
INTEGER	interviewee_location
STRING	interviewee_origin	The way in which the interviewed opportunity was added to lever. Includes 'agency', 'applied', 'internal', 'referred', 'sourced', and 'university'.
STRING	interviewee_contact_id	CONTACT id of the opportunity.
INTEGER	days_between_opp_created_and_interview	Number of days that have passed between the creation of this opportunity and the beginning of this interview.
BOOLEAN	has_advanced_since_interview	Boolean that is true if the opportunity advanced to another stage after this interview ended.