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_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.

Indexes

Constraint Name Type Sort Column(s)
postings_pkey Primary key Asc posting_id
postings_account_id_index Performance Asc account_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

Relationships