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.

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_posting_id_idx Performance Asc posting_id

Relationships