Lever: Requisition Enhanced

Description

• Table capturing requisitions, if enabled.

Supported Data Sources

• Lever

Columns

Type	Name	Description
DATETIME	_fivetran_synced
BOOLEAN	is_backfill	Boolean that is true if the requisition represents a backfill or new headcount. If unspecified, defaults to false.
STRING	compensation_band_currency	The ISO currency code associated with the requisition's compensation band.
STRING	compensation_band_interval	The string representing the interval of payment for the compensation band.
INTEGER	compensation_band_max	The high bound for the compensation band.
INTEGER	compensation_band_min	The low bound for the compensation band.
DATETIME	created_at	Timestamp of when the requisition was first created.
STRING	creator_user_id	Foreign key referencing the USER who created the requisition.
STRING	employment_status	The work type of the requisition ('full-time', 'part-time', 'intern', 'contractor', or 'temp-worker').
INTEGER	headcount_hired	The number of filled seats / openings on the requisition, or the string, 'unlimited'.
INTEGER	headcount_infinite
INTEGER	headcount_total_allotted	Total headcount allotted for this requisition.
STRING	hiring_manager_user_id	Foreign key referencing the USER who is the hiring manager for this requisition.
STRING	requisition_id	Unique id of the requisition.
STRING	internal_notes	Free form text for notes and meta-data about the requisition, visible to anyone who can see the requisition in Lever.
STRING	job_location	The location associated with the requisition.
STRING	job_title	The human-readable name for the requisition.
STRING	owner_user_id	Foreign key referencing the USER who owns the requisition.
INTEGER	requisition_code	The unique HRIS requisition code.
STRING	status	The status of the requisition. Can be 'open', 'onHold', 'closed', or 'draft'.
STRING	job_team	The team associated with the requisition
STRING	creator_name	Full name of the user who created the requisition.
STRING	requisition_owner_name	Full user name of the user who owns the requisition.
STRING	hiring_manager_name	Full user name of the requisition's hiring manager.
INTEGER	count_postings	Number of postings associated with this requisition.
BOOLEAN	has_posting	Boolean that is true if the requisition has a posting.
INTEGER	count_offers	Total count of extended offers associated with this requisition. Note - includes offers regardless of their status.
BOOLEAN	has_offer	Boolean that is true if the requisition has any offer associated with it.