postings


Description

A row in this table represents a job posting.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
posting_id varchar 2147483647 null
agency_jobs.posting_id agency_jobs_posting_id_fkeyN
email_events.posting_id emails_events_posting_id_fkeyN
nurture_campaign_events.posting_id nurture_campaign_events_posting_id_fkeyN
offer_events.posting_id offer_events_posting_id_fkeyN
offers.posting_id offers_posting_id_fkeyN
opportunities.posting_id opportunities_posting_id_fkeyN
opportunity_feedback_events.posting_id opportunities_feedback_events_posting_id_fkeyN
opportunity_form_events.posting_id opportunities_form_events_posting_id_fkeyN
opportunity_progress_events.posting_id opportunities_progress_events_posting_id_fkeyN
opportunity_referrals.posting_id opportunity_referrals_posting_id_fkeyN
posting_approvers.posting_id posting_approvers_posting_id_fkeyC
posting_distribution_channels.posting_id distribution_channels_posting_id_fkeyN
posting_events.posting_id posting_events_posting_id_fkeyN
posting_followers.posting_id posting_followers_posting_id_fkeyC
posting_lists.posting_id posting_lists_posting_id_fkeyC
posting_locations.posting_id posting_locations_posting_id_fkeyR
posting_tags.posting_id posting_tags_posting_id_fkeyC
requisition_events.posting_id requisition_events_posting_id_fkeyN
requisition_postings.posting_id requisition_postings_posting_id_fkeyC

Primary key.
account_id varchar 2147483647 √ null

ID of the account the record belongs to.
job_department_id varchar 2147483647 √ null
job_departments.job_department_id postings_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 postings_job_department_team_id_fkeyN

ID of the team associated with this record.
job_level_id varchar 2147483647 √ null
job_levels.job_level_id postings_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 postings_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 postings_job_location_id_fkeyN

ID of a possible location value for job postings and requisitions.
posting_text varchar 2147483647 √ null

Title of the posting.
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.
owner_user_id varchar 2147483647 √ null
users.user_id postings_owner_user_id_fkeyN

ID of the owner of this record.
hiring_manager_user_id varchar 2147483647 √ null
users.user_id postings_hiring_manager_user_id_fkeyN

ID of the user assigned as the hiring manager for this entity.
posting_status_id varchar 2147483647 √ null
posting_status_enum.posting_status_id postings_posting_status_id_fkeyR

ID of the status of this entity.
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 is confidential.
description varchar 2147483647 √ null

The description of the job.
additional varchar 2147483647 √ null

The closing of the job.
posting_location_type_id varchar 2147483647 √ null
posting_location_type_enum.posting_location_type_id postings_posting_location_type_id_fkeyN

Describes the type of location for the posting.
salary_range_min numeric 131089 √ null

The minimum amount of compensation.
salary_range_max numeric 131089 √ null

The maximum amount of compensation.
salary_range_interval varchar 2147483647 √ null

The time period for the amount of compensation.
salary_range_currency varchar 2147483647 √ null

The currency that applies to the compensation band.
salary_range_description varchar 2147483647 √ null

Salary description of the posting
last_closed_at timestamp 29,6 √ null

The max event_at where the status_id is closed
last_published_at timestamp 29,6 √ null

The max event_at where the status_id is published
last_unlisted_at timestamp 29,6 √ null

The max event_at where the status_id is unlisted and the event_id is status-changed
last_event_at timestamp 29,6 √ null

The max event_at
location_count int4 10 √ null

The location count will help determine the multiple location postings

Indexes

Constraint Name Type Sort Column(s)
postings_pkey Primary key Asc posting_id
posting_location_type_id_index Performance Asc posting_location_type_id
postings_account_id_index Performance Asc account_id
postings_account_posting_idx Performance Asc/Asc account_id + posting_id
postings_hiring_manager_user_id_idx Performance Asc hiring_manager_user_id
postings_job_department_id_idx Performance Asc job_department_id
postings_job_department_team_id_idx Performance Asc job_department_team_id
postings_job_level_id_idx Performance Asc job_level_id
postings_job_location_id_idx Performance Asc job_location_id
postings_job_work_type_id_idx Performance Asc job_work_type_id
postings_owner_user_id_idx Performance Asc owner_user_id

Relationships

Close relationships within degrees of separation