# Lever: Interview Enhanced

## Description

* Table in which each row is a unique interview-feedback combo. Interviews without feedback appear here as well.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/lever/resources/lever.svg" alt="" data-size="line"> Lever

## Columns

| Type     | Name                                        | Description                                                                                                                                         |
| -------- | ------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------- |
| STRING   | opportunity\_id                             | Foreign key referencing the OPPORTUNITY being interviewed for.                                                                                      |
| DATETIME | \_fivetran\_synced                          |                                                                                                                                                     |
| DATETIME | canceled\_at                                | Timestamp of when the interview was canceled.                                                                                                       |
| DATETIME | created\_at                                 | Timestamp of when the interview was created.                                                                                                        |
| STRING   | creator\_user\_id                           | Foreign key referencing the USER who created the interview in lever.                                                                                |
| DATETIME | occurred\_at                                | Date + time at which the interview was set to occur.                                                                                                |
| INTEGER  | duration\_minutes                           | Interview duration in minutes, minimum value is 1.                                                                                                  |
| STRING   | feedback\_reminder\_frequency               | Frequency of feedback reminders (i.e. once, daily, frequently, none). Defaults to 'frequently' which is every 6 hours.                              |
| INTEGER  | gcal\_event\_url                            | Google calendar event url.                                                                                                                          |
| STRING   | interview\_id                               | Unique ID of the interview.                                                                                                                         |
| STRING   | location                                    | Interview location. Usually the name of a booked conference room but can also be a phone number to call.                                            |
| INTEGER  | note                                        | Interview note.                                                                                                                                     |
| STRING   | panel\_id                                   | Unique id of the PANEL this interview belongs to.                                                                                                   |
| STRING   | opportunity\_stage\_id                      | Foreign key referencing the STAGE that the candidate was in at the time the interview was scheduled.                                                |
| STRING   | subject                                     | Subject of the interview.                                                                                                                           |
| STRING   | timezone                                    | Name of timezone in which interview was scheduled to occur.                                                                                         |
| STRING   | feedback\_form\_id                          | Unique id of the feedback form.                                                                                                                     |
| STRING   | feedback\_completer\_user\_id               | Foreign key referencing the USER who completed the feedback.                                                                                        |
| DATETIME | feedback\_completed\_at                     | Timestamp of when the feedback form was completed.                                                                                                  |
| INTEGER  | feedback\_form\_instructions                | Guidelines given for how give a feedback score.                                                                                                     |
| STRING   | score\_system\_value                        | Overall rating (1-4 scale) to the candidate.                                                                                                        |
| STRING   | feedback\_form\_title                       | Form title. This can be edited in Feedback and Form Settings.                                                                                       |
| STRING   | interviewer\_user\_id                       | Foreign key referencing the USER that interviewed the candidate.                                                                                    |
| STRING   | inteviewer\_name                            | Full name of the interviewer.                                                                                                                       |
| STRING   | interviewer\_email                          | Email associated with the interviewer.                                                                                                              |
| STRING   | feedback\_completer\_name                   | Full name of the user who completed the feedback form.                                                                                              |
| STRING   | interview\_coordinator\_name                | Full name of the user who created the interviewer in Lever.                                                                                         |
| DATETIME | ended\_at                                   | Timestamp of when the interview was scheduled to end.                                                                                               |
| STRING   | opportunity\_owner\_name                    | Full name of the user who owns the opportunity in Lever.                                                                                            |
| STRING   | referrer\_name                              | Full name of the user who referred the candidate for this opportunity.                                                                              |
| STRING   | hiring\_manager\_name                       | Full name of the hiring manager of role for which the opportunity applied.                                                                          |
| BOOLEAN  | interviewer\_is\_hiring\_manager            | Boolean that is true if the interviewer is also the hiring manager of this position.                                                                |
| STRING   | interviewee\_name                           | Full name of the interviewee candidate.                                                                                                             |
| INTEGER  | interviewee\_location                       |                                                                                                                                                     |
| STRING   | interviewee\_origin                         | The way in which the interviewed opportunity was added to lever. Includes 'agency', 'applied', 'internal', 'referred', 'sourced', and 'university'. |
| STRING   | interviewee\_contact\_id                    | CONTACT id of the opportunity.                                                                                                                      |
| INTEGER  | days\_between\_opp\_created\_and\_interview | Number of days that have passed between the creation of this opportunity and the beginning of this interview.                                       |
| BOOLEAN  | has\_advanced\_since\_interview             | Boolean that is true if the opportunity advanced to another stage after this interview ended.                                                       |


---

# 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-interview-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.