Lever: Posting Enhanced

Description

• Table capturing job postings.

Supported Data Sources

• Lever

Columns

Type	Name	Description
DATETIME	_fivetran_synced
STRING	job_commitment	Tag for job position work type (e.g. Full-time, Part-time, Internship).
INTEGER	job_department	Tag for the department to which the job posting's team belongs, if present.
INTEGER	job_level	Tag for job posting level (e.g. Senior, Junior). Note - this has been deprecated by Lever but is currently maintained for backward compatibility.
STRING	job_location	Tag for job position location.
STRING	job_team	Tag for the team to which the job posting belongs (a sub-category of department).
STRING	content_description	Job posting description that is shown at the top of the job's page, as plaintext.
DATETIME	created_at	Timestamp of when the posting was created in Lever.
STRING	creator_user_id	Foreign key referencing the id of the USER who created the job posting.
STRING	posting_id	Unique ID of the job posting.
STRING	owner_user_id	Foreign key referencing the id of the USER who owns the posting. The posting owner is the individual who is directly responsible for managing all candidates who are applied to that role.
INTEGER	requisition_code	Array of requisition codes associated with this posting.
STRING	current_state	Current status of the posting, which may include 'published', 'internal' (called 'unlisted' in the UI), 'closed', 'draft', 'pending' (awaiting approval), and 'rejected'.
STRING	job_title	Title of the job posting role.
DATETIME	updated_at	Timestamp of when the posting was last updated.
DATETIME	first_app_sent_at	Timestamp of when the first application was submitted to this posting.
INTEGER	count_referred_applications	Count of how many applications were referred to this posting.
INTEGER	count_posting_applications	Count of how many applications were submitted through the posting (including via an agency).
INTEGER	count_manual_user_applications	Count of how many applications have been manually submitted by internal users.
INTEGER	count_opportunities	Count of how many opportunities applied to this posting.
INTEGER	count_open_opportunities	Count of how many currently open opprtunities applied to this posting.
INTEGER	count_interviews	Count of the number of interviews conducted for this posting.
INTEGER	count_interviewees	Count of opportunities interviewed for this posting.
INTEGER	count_requisitions	Number of requisitions associated with this posting.
BOOLEAN	has_requisition	Boolean that is true if the posting has a requisition.
STRING	tags	Comma-separated aggregated list of tags.
STRING	posting_hiring_manager_name	Full name of the user who is hiring manager of this posting.