# Greenhouse: Interview Enhanced

## Description

* Table of **scheduled** interviews joined with interviewer scorecards. Each record is unique to the interview and interviewer and is enriched with data about the applicant and job.

## 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                 |                                                                                                                          |
| INTEGER  | application\_id                    | Foreign key referencing the APPLICATION that is being interviewed.                                                       |
| DATETIME | created\_at                        | Timestamp of when the interview was created.                                                                             |
| DATETIME | end\_at                            | Timestamp of when the interview is scheduled to end. Will be a date if the interview is all-day.                         |
| INTEGER  | scheduled\_interview\_id           | Unique ID of the scheduled interview.                                                                                    |
| INTEGER  | interview\_id                      | Foreign key referencing the id of the generic INTERVIEW step that this scheduled interview maps to.                      |
| INTEGER  | location                           | The location of the interview.                                                                                           |
| INTEGER  | organizer\_user\_id                | Foreign key referencing the USER who organized the interview.                                                            |
| DATETIME | start\_at                          | Timestamp of when the interview is scheduled to start. Will be a date if the interview is all-day.                       |
| STRING   | status                             | One of - scheduled, awaiting\_feedback, complete.                                                                        |
| DATETIME | last\_updated\_at                  | Timestamp of when the interview was last updated.                                                                        |
| INTEGER  | job\_stage\_id                     | Foreign key referencing the JOB\_STAGE that this interview is associated with.                                           |
| STRING   | interview\_name                    | Title of the interview step.                                                                                             |
| DECIMAL  | duration\_interview\_minutes       | From start the finish, the length of the interview in minutes.                                                           |
| INTEGER  | scorecard\_id                      | Unique ID of the scorecard.                                                                                              |
| INTEGER  | candidate\_id                      | Foreign key referencing the CANDIDATE who was interviewed and scored.                                                    |
| STRING   | overall\_recommendation            | One of - definitely\_not, no, yes, strong\_yes, no\_decision.                                                            |
| DATETIME | scorecard\_submitted\_at           | Timestamp of when the scorecard was submitted.                                                                           |
| INTEGER  | scorecard\_submitted\_by\_user\_id | Foreign key referencing the USER who submitted the scorecard.                                                            |
| DATETIME | scorecard\_last\_updated\_at       | Timestamp of when the scorecard was last updated.                                                                        |
| INTEGER  | interviewer\_user\_id              | Foreign key referencing the USER conducting the interview.                                                               |
| STRING   | interview\_scorecard\_key          | Key hashed on `scheduled_interview_id` and `interviewer_user_id`                                                         |
| STRING   | interviewer\_name                  | Full name of the interviewer user.                                                                                       |
| STRING   | scorecard\_submitter\_name         | Full name of the user who submitted the scorecard (either the interviewer or on behalf of the interviewer).              |
| STRING   | organizer\_name                    | Full name of the user who organized the interview.                                                                       |
| STRING   | interviewer\_email                 | Email(s) of the interviewer.                                                                                             |
| STRING   | candidate\_name                    | Full name of the interviewee.                                                                                            |
| STRING   | job\_stage                         | Name of the job stage step that this interview is associated with.                                                       |
| STRING   | application\_current\_job\_stage   | Current job stage of the application. If this is diferent from `job_stage`, the candidate advanced after this interview. |
| STRING   | current\_application\_status       | Current status of the application - active, hired, rejected                                                              |
| STRING   | job\_title                         | Title of the job role the candidate is interviewing for.                                                                 |
| INTEGER  | job\_id                            | Foreign key referencing the JOB being interviewed for.                                                                   |
| BOOLEAN  | interviewer\_is\_hiring\_manager   | Boolean that is true if the interviewer is one of the hiring managers for this job.                                      |
| STRING   | hiring\_managers                   | Comma-separated list of the full names of the job's hiring managers.                                                     |
| STRING   | recruiter\_name                    | Full name of the interviewee's assigned recruiter.                                                                       |
| STRING   | job\_offices                       | Semicolon-separated list of the offices that the job is listed under.                                                    |
| STRING   | job\_departments                   | Semicolon-separated list of the departments that the job is listed under.                                                |
| STRING   | job\_parent\_departments           | Semicolon-separated list of the *parent* departments that the job is listed under.                                       |
| STRING   | candidate\_gender                  | Description of the applicant's gender identity.                                                                          |
| STRING   | candidate\_disability\_status      | Description of the applicant's disability status.                                                                        |
| STRING   | candidate\_race                    | Description of applicant's provided race.                                                                                |
| STRING   | candidate\_veteran\_status         | Description of the applicant's veteran status.                                                                           |


---

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