offer_events


Description

A row in this table represents a change event regarding a specific offer. The types of events tracked are available in “offer_event_enum”.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
offer_id varchar 2147483647 null
offers.offer_id offer_events_offer_id_fkeyN

ID of a specific offer.

offer_event_id varchar 2147483647 null
offer_event_enum.offer_event_id offer_events_offer_event_id_fkeyN

ID of the event type represented by this entity. See connected “enum” table for a list of the possible types.

offer_status_id varchar 2147483647 null
offer_status_enum.offer_status_id offer_events_offer_status_id_fkeyN

ID of the status of this entity.

offer_revision_id varchar 2147483647 null
offer_revisions.offer_revision_id offer_events_offer_revision_id_fkeyC

ID of the specific offer revision this event related to.

actor_id varchar 2147483647 null
users.user_id offer_events_actor_id_fkeyN

The user or system responsible for performing the action.

event_at timestamp 29,6 null

Date and time when the event occurred.

account_id varchar 2147483647 null

ID of the account the record belongs to.

hiring_manager_user_id varchar 2147483647 null
users.user_id offer_events_hiring_manager_user_id_fkeyN

ID of the user assigned as the hiring manager for this entity.

posting_id varchar 2147483647 null
postings.posting_id offer_events_posting_id_fkeyN

ID of the posting connected to this entity.

requisition_id varchar 2147483647 null
requisitions.requisition_id offer_events_requisition_id_fkeyN

ID of the requisition associated with this entity.

opportunity_id varchar 2147483647 null
opportunities.opportunity_id offer_events_opportunity_id_fkeyC

ID of the opportunity connected to this entity.

archive_reason_id varchar 2147483647 null
archive_reasons.archive_reason_id offer_events_archive_reason_id_fkeyN

ID of the archive reason.

event_date_id varchar 2147483647 null
dates.date_id offer_events_event_date_id_fkeyN

ID of the date and time when the event occurred. It’s used in combination with the datetime dimension table to simplify the creation of temporal queries.

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.

job_department_id varchar 2147483647 null
job_departments.job_department_id offer_events_job_department_id_fkeyN

ID of the department associated with this record.

job_department_team_id varchar 2147483647 null
job_department_teams.job_department_team_id offer_events_job_department_team_id_fkeyN

ID of the team associated with this record.

job_level_id varchar 2147483647 null
job_levels.job_level_id offer_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 offer_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 offer_events_job_location_id_fkeyN

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

contact_id varchar 2147483647 null
contacts.contact_id offer_events_contact_id_fkeyN

ID of the contact connected to this entity.

is_confidential bool 1 false

TRUE if the profile related to the offer has a confidential posting.

event_key varchar 2147483647 null
previous_offer_status_id varchar 2147483647 null
offer_status_enum.offer_status_id Implied ConstraintR

The previous status of the offer for the same offer_id and offer_revision_id.

previous_event_at timestamp 29,6 null

Date and time of the previous event for the same offer_id. Is the same as event_at for the first event.

next_event_at timestamp 29,6 null

Date and time of the next event for the same offer_id. Is 9999-09-09T12:00:00Z if last event.

is_saved_internally bool 1 null

TRUE if the revision was saved for internal records.

Indexes

Constraint Name Type Sort Column(s)
offer_events_pkey Primary key Asc event_key
offer_events_account_id_index Performance Asc account_id
offer_events_actor_id_idx Performance Asc actor_id
offer_events_archive_reason_id_idx Performance Asc archive_reason_id
offer_events_contact_id_index Performance Asc contact_id
offer_events_hiring_manager_user_id_idx Performance Asc hiring_manager_user_id
offer_events_job_department_id_index Performance Asc job_department_id
offer_events_job_department_team_id_index Performance Asc job_department_team_id
offer_events_job_level_id_index Performance Asc job_level_id
offer_events_job_location_id_index Performance Asc job_location_id
offer_events_job_work_type_id_index Performance Asc job_work_type_id
offer_events_offer_id_idx Performance Asc offer_id
offer_events_offer_revision_id_index Performance Asc offer_revision_id
offer_events_posting_id_idx Performance Asc posting_id
offer_events_requisition_id_idx Performance Asc requisition_id

Relationships