Greenhouse: Job Enhanced

Description

• Table capturing information and metrics related to jobs. May contain custom columns.

Supported Data Sources

• Greenhouse

Columns

Type	Name	Description
DATETIME	_fivetran_synced
DATETIME	last_opening_closed_at	Timestamp of when the last opening for this job closed.
BOOLEAN	is_confidential	Boolean that is true if the job is confidential.
DATETIME	created_at	Timestamp of when the job was created.
INTEGER	job_id	Unique ID of the job.
STRING	job_title	Title of the job role.
STRING	notes	Notes on the hiring plan.
INTEGER	requisition_id	The id of the requisition corresponding to this job posting, if applicable.
STRING	status	One of open, closed, draft.
DATETIME	last_updated_at	Timestamp of when the job was last updated.
STRING	custom_employment_type
INTEGER	custom_stock_options
STRING	hiring_managers	Comma-separated list of the full names of the job's hiring managers.
STRING	sourcers	Comma-separated list of the full names of the job's recruiting sourcers.
STRING	recruiters	Comma-separated list of the full names of the job's recruiters.
STRING	coordinators	Comma-separated list of the full names of the job's recruiting coordinators.
STRING	offices	Semicolon-separated list of the offices that the job is listed under.
STRING	office_locations
STRING	departments	Semicolon-separated list of the departments that the job is listed under.
STRING	parent_departments	Semicolon-separated list of the parent departments that the job is listed under.
INTEGER	count_active_applications	Total count of currently active applications.
INTEGER	count_hired_applications	Total count of hired applications for this role.
INTEGER	count_rejected_applications	Total count of rejected applications.
INTEGER	count_interviewed_applications	Total count of applications who have received an interview.
INTEGER	count_active_prospects	Total count of currently active (and not converted) prospects.
INTEGER	count_converted_prospects	Total count of prospects who have converted to candidate applications for this job.
INTEGER	count_rejected_prospects	Total count of rejected prospects.
INTEGER	count_active_openings	Total count of currently active job openings.
INTEGER	count_closed_openings	Total count of closed job openings.
INTEGER	count_hired_closed_openings	Total count of job openings that were closed by hiring someone.
INTEGER	count_live_internal_posts	Total count of currently live and internally-facing posts.
INTEGER	count_live_external_posts	Total count of currently live and externally-facing posts.
INTEGER	count_live_locations	Total count of unique locations that this job is listed for.