opportunities


Description

A row in this table represents an opportunity, which is the process of considering a candidate for a job \(including general opportunities\).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
opportunity_id varchar 2147483647 null
email_events.opportunity_id emails_events_opportunity_id_fkeyC
external_messages.opportunity_id external_messages_opportunity_id_fkeyC
interview_panels.opportunity_id interview_panels_opportunity_id_fkeyC
nurture_campaign_events.opportunity_id nurture_campaign_events_opportunity_id_fkeyC
nurture_campaigns.opportunity_id nurture_campaigns_opportunity_id_fkeyC
offer_events.opportunity_id offer_events_opportunity_id_fkeyC
offers.opportunity_id offers_opportunity_id_fkeyC
opportunity_education.opportunity_id opportunity_education_opportunity_id_fkeyC
opportunity_eeo.opportunity_id opportunity_eeo_opportunity_id_fkeyC
opportunity_feedback_events.opportunity_id opportunities_feedback_events_opportunity_id_fkeyC
opportunity_form_events.opportunity_id opportunities_form_events_opportunity_id_fkeyC
opportunity_form_field_files.opportunity_id opportunity_form_field_files_opportunity_id_fkeyC
opportunity_form_field_scores.opportunity_id opportunity_form_field_scores_opportunity_id_fkeyC
opportunity_forms.opportunity_id opportunity_forms_opportunity_id_fkeyC
opportunity_progress_events.opportunity_id opportunities_progress_events_opportunity_id_fkeyC
opportunity_referrals.opportunity_id opportunity_referrals_opportunity_id_fkeyC
opportunity_sources.opportunity_id opportunity_sources_opportunity_id_fkeyC
opportunity_tags.opportunity_id opportunity_tags_opportunity_id_fkeyC
survey_responses.opportunity_id survey_responses_opportunity_id_fkeyC

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

created_at timestamp 29,6 null

Date the object referred to in this entity was created.

posting_id varchar 2147483647 null
postings.posting_id opportunities_posting_id_fkeyN

ID of the posting connected to this entity.

contact_id varchar 2147483647 null
contacts.contact_id opportunities_contact_id_fkeyN

ID of the contact associated with this record.

requisition_id varchar 2147483647 null
requisitions.requisition_id opportunities_requisition_id_fkeyN

ID of the requisition associated with this entity.

is_deleted bool 1 false

TRUE if the source of data for the current entity has been deleted.

origin_id varchar 2147483647 null
origin_enum.origin_id opportunities_origin_id_fkeyN

ID of the origin associated with this record.

origin varchar 2147483647 null

Origin of the candidate, can be Applied, Sourced, Referred, University, Internal, or Agency

owner_user_id varchar 2147483647 null
users.user_id opportunities_owner_user_id_fkeyN

ID of the owner of this record.

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.

sourced_by_user_id varchar 2147483647 null
users.user_id opportunities_sourced_by_user_id_fkeyN

ID of the user that sourced this opportunity.

account_stage_id varchar 2147483647 null
account_stages.account_stage_id opportunities_account_stage_id_fkeyN

ID of the stage associated with this record.

stage_entered_at timestamp 29,6 null

Date the stage was entered at.

last_advanced_at timestamp 29,6 null

Legacy value representing the last stage or archive change on an opportunity. Prefer events in opportunity_progress_events to this date.

last_story_at timestamp 29,6 null

Legacy value representing the last recruiting activity on an opportunity. Prefer events in opportunity related event tables to this date.

archive_reason_id varchar 2147483647 null
archive_reasons.archive_reason_id opportunities_archive_reason_id_fkeyN

ID of the archive reason for this opportunity.

archived_at timestamp 29,6 null

When the opportunity was archived.

archived_by_user_id varchar 2147483647 null
users.user_id opportunities_archived_by_user_id_fkeyN

ID of the user that archived the opportunity.

is_confidential bool 1 false

TRUE if a posting assigned to the opportunity is confidential.

is_hired bool 1 false

TRUE if the opportunity is hired

is_snoozing bool 1 null

State of last snooze, if applicable

snooze_started_at timestamp 29,6 null

Time when last snooze started

snooze_ended_at timestamp 29,6 null

Time when last snooze ended

preferred_location_id varchar 2147483647 null

The location the applicant picked as preferred for the opportunity.

Indexes

Constraint Name Type Sort Column(s)
opportunities_pkey Primary key Asc opportunity_id
opportunities_account_id_index Performance Asc account_id
opportunities_account_stage_id_index Performance Asc account_stage_id
opportunities_archive_reason_id_idx Performance Asc archive_reason_id
opportunities_archived_by_user_id_idx Performance Asc archived_by_user_id
opportunities_contact_id_index Performance Asc contact_id
opportunities_owner_user_id_idx Performance Asc owner_user_id
opportunities_posting_id_idx Performance Asc posting_id
opportunities_requisition_id_idx Performance Asc requisition_id
opportunities_sourced_by_user_id_idx Performance Asc sourced_by_user_id

Relationships