# Greenhouse: Job Enhanced

## Description

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

## Supported Data Sources

* <img src="https://fivetran.com/integrations/greenhouse/resources/greenhouse.svg" alt="" data-size="line"> 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.                        |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/greenhouse-job-enhanced.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.