# Lever: Posting Enhanced

## Description

* Table capturing job postings.

## Supported Data Sources

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


---

# 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/lever-posting-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.