posting_events


Description

A row in this table represents an event pertinent to a specific posting. Useful to answer questions like “how long does it take us on average to approve a posting”. The types of events tracked are in “posting_event_enum”.

Columns

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

ID of the account the record belongs to.
posting_id varchar 2147483647 null
postings.posting_id posting_events_posting_id_fkeyN

ID of the posting connected to this entity.
posting_status_id varchar 2147483647 null
posting_status_enum.posting_status_id posting_events_posting_status_id_fkeyN

ID of the status of this entity.
posting_event_id varchar 2147483647 null
posting_event_enum.posting_event_id posting_events_posting_event_id_fkeyN

ID of the event type represented by this entity. See connected “enum” table for a list of the possible types.
actor_id varchar 2147483647 null
users.user_id posting_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.
event_date_id varchar 2147483647 √ null
dates.date_id posting_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.
job_department_id varchar 2147483647 √ null
job_departments.job_department_id posting_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 posting_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 posting_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 posting_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 posting_events_job_location_id_fkeyN

ID of a possible location value for job postings and requisitions.
distribution_channel_id varchar 2147483647 null
distribution_channel_enum.distribution_channel_id posting_events_distribution_channel_id_fkeyN

ID of the distribution channel.
previous_posting_status_id varchar 2147483647 √ null
posting_status_enum.posting_status_id posting_events_previous_posting_status_id_fkeyN

ID of the previous status of this entity.
previous_posting_status_event_at timestamp 29,6 √ null

When the previous_posting_status_id was applied to the posting.
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.
is_confidential bool 1 √ false

TRUE if the posting related to the event is confidential.
event_key varchar 2147483647 null
previous_event_at timestamp 29,6 √ null

Date and time of the previous posting-status-changed event. Otherwise, is the same as event_at.
next_event_at timestamp 29,6 √ null

Date and time of the next posting-status-changed event. Otherwise, is 9999-09-09T12:00:00Z.
posting_location_type_id varchar 2147483647 √ null
posting_location_type_enum.posting_location_type_id posting_events_posting_location_type_id_fkeyN

Describes the type of location for the posting related to the event.

Indexes

Constraint Name Type Sort Column(s)
posting_events_pkey Primary key Asc event_key
posting_events_account_id_index Performance Asc account_id
posting_events_actor_id_idx Performance Asc actor_id
posting_events_posting_id_idx Performance Asc posting_id
posting_events_posting_location_type_id_index Performance Asc posting_location_type_id

Relationships

Close relationships within degrees of separation