offers


Description

A row in this table represents an offer.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
offer_id varchar 2147483647 null
offer_approvers.offer_id offer_approvers_offer_id_fkeyC
offer_events.offer_id offer_events_offer_id_fkeyN
offer_revision_fields.offer_id offer_revision_fields_offer_id_fkeyN
offer_revisions.offer_id offer_revisions_offer_id_fkeyN

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.

is_deleted bool 1 false

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

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.

opportunity_id varchar 2147483647 null
opportunities.opportunity_id offers_opportunity_id_fkeyC

ID of the opportunity connected to this entity.

posting_id varchar 2147483647 null
postings.posting_id offers_posting_id_fkeyN

ID of the posting connected to this entity.

requisition_id varchar 2147483647 null
requisitions.requisition_id offers_requisition_id_fkeyN

ID of the requisition associated with this entity.

active_revision_key varchar 2147483647 null

ID of the active offer revision, currently sent out to the candidate.

offer_status_id varchar 2147483647 'NOT_APPLICABLE'::character varying
offer_status_enum.offer_status_id offers_offer_status_id_fkeyN

ID of the current status for this offer.

anticipated_start_date timestamp 29,6 null

A default offer date form field. Date the candidate is anticipated to start.

salary_amount numeric 131089 null

A default offer form field. Compensation amount the candidate is offered.

salary_interval varchar 2147483647 null

A default offer form field. The time period for the amount of compensation the candidate is offered.

compensation_currency varchar 2147483647 null

A default offer form field. The currency that applies to the compensation the candidate is offered.

last_sent_offer_revision_id varchar 2147483647 null
offer_revisions.offer_revision_id Implied ConstraintR

The revision id for the most recent sent revision.

last_sent_offer_revision_key varchar 2147483647 null

The revision key for the most recent sent revision.

last_sent_at timestamp 29,6 null

Timestamp of most recent sent event for this offer

last_signed_at timestamp 29,6 null

Timestamp of most recent signed event for this offer

last_declined_at timestamp 29,6 null

Timestamp of most recent declined event for this offer

Indexes

Constraint Name Type Sort Column(s)
offers_pkey Primary key Asc offer_id
offers_account_id_index Performance Asc account_id
offers_opportunity_id_idx Performance Asc opportunity_id
offers_posting_id_idx Performance Asc posting_id
offers_requisition_id_idx Performance Asc requisition_id

Relationships