opportunity_feedback_events


Description

A row in this table represents a feedback provided by a user in your Lever account \(could be an interview, a resume review…\).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
account_id varchar 2147483647 null

ID of the account the record belongs to.

opportunity_id varchar 2147483647 null
opportunities.opportunity_id opportunities_feedback_events_opportunity_id_fkeyC

ID of the opportunity connected to this entity.

opportunity_form_id varchar 2147483647 null
opportunity_forms.opportunity_form_id opportunities_feedback_events_opportunity_form_id_fkeyN

ID of the opportunity form record related to this entity.

opportunity_form_field_score_id varchar 2147483647 null
opportunity_form_field_scores.opportunity_form_field_score_id opportunities_feedback_events_opportunity_form_field_score_fkeyC

ID of the score record related to this feedback event.

actor_id varchar 2147483647 null
users.user_id opportunities_feedback_events_actor_id_fkeyN

The user or system responsible for performing the action.

posting_id varchar 2147483647 null
postings.posting_id opportunities_feedback_events_posting_id_fkeyN

ID of the posting connected to this entity.

requisition_id varchar 2147483647 null
requisitions.requisition_id opportunities_feedback_events_requisition_id_fkeyN

ID of the requisition associated with this entity.

form_template_id varchar 2147483647 null
form_templates.form_template_id opportunities_feedback_events_form_template_id_fkeyN

ID of form template used to create feedback form.

account_stage_id varchar 2147483647 null
account_stages.account_stage_id opportunities_feedback_events_account_stage_id_fkeyN

ID of the stage associated with this record.

interview_date_id varchar 2147483647 null
dates.date_id opportunities_feedback_events_interview_date_id_fkeyN

ID of the dates row related to the time of the interview.

feedback_date_id varchar 2147483647 null
dates.date_id opportunities_feedback_events_feedback_date_id_fkeyN

When the interviewer’s feedback was completed.

job_department_id varchar 2147483647 null
job_departments.job_department_id opportunities_feedback_events_job_department_id_fkeyN

ID of the department associated with this entity.

job_department_team_id varchar 2147483647 null
job_department_teams.job_department_team_id opportunities_feedback_events_job_department_team_id_fkeyN

ID of the team associated with this entity.

job_level_id varchar 2147483647 null
job_levels.job_level_id opportunities_feedback_events_job_level_id_fkeyN

ID of the level used to capture the seniority of a position.

job_work_type_id varchar 2147483647 null
job_work_types.job_work_type_id opportunities_feedback_events_job_work_type_id_fkeyN

ID of the work type. Can be any number of user configured values, defaults are Contract, Full-time, Intern, Part-time.

job_location_id varchar 2147483647 null
job_locations.job_location_id opportunities_feedback_events_job_location_id_fkeyN

ID of a possible location value for job postings and requisitions.

interview_at timestamp 29,6 null

When the interview was conducted, if applicable.

feedback_at timestamp 29,6 null

When the feedback was submitted.

feedback_score numeric 131089 null

Numeric score received along with the feedback.

interview_panel_interview_id varchar 2147483647 null
interview_panel_interviews.interview_panel_interview_id opportunities_feedback_events_interview_panel_interview_id_fkeyN

ID of the interview related to this feedback, if applicable.

row_updated_at timestamp 29,6 CURRENT_TIMESTAMP

Date this entity was updated in the database. Useful to setup incremental refreshes of the data in your periodic ETL job.

contact_id varchar 2147483647 null
contacts.contact_id opportunity_feedback_events_contact_id_fkeyN

ID of the contact associated with this record.

is_confidential bool 1 false

TRUE if the posting related to the opportunity is confidential.

event_key varchar 2147483647 null
previous_event_at timestamp 29,6 null

Date and time that the interview finished if interview feedback. Otherwise, will be the same Is the same as event_at for the first event.

event_at timestamp 29,6 null

Date and time that the feedback was submitted.

next_event_at timestamp 29,6 null

Is 9999-09-09T12:00:00Z to indicate that feedback always applies once submitted.

Indexes

Constraint Name Type Sort Column(s)
opportunity_feedback_events_pkey Primary key Asc event_key
opp_feedback_events_account_stage_id_idx Performance Asc account_stage_id
opp_feedback_events_form_id_idx Performance Asc opportunity_form_id
opp_feedback_events_job_department_id_idx Performance Asc job_department_id
opp_feedback_events_job_department_team_id_idx Performance Asc job_department_team_id
opp_feedback_events_job_level_id_idx Performance Asc job_level_id
opp_feedback_events_job_location_id_idx Performance Asc job_location_id
opp_feedback_events_job_work_type_id_idx Performance Asc job_work_type_id
opp_feedback_events_opportunity_id_idx Performance Asc opportunity_id
opportunities_feedback_events_account_id_index Performance Asc account_id
opportunity_feedback_events_contact_id_index Performance Asc contact_id
opportunity_feedback_events_interview_id_idx Performance Asc interview_panel_interview_id
opportunity_feedback_events_opportunity_form_field_score_id_idx Performance Asc opportunity_form_field_score_id

Relationships