# Greenhouse: Application Enhanced
## Description
* Table capturing all candidate and prospect applications. Note that prospect applications can be associated with 0-many jobs. Also, a prospect that converts to a candidate application will have 2 records (the difference is `is_prospect`).
## Supported Data Sources
* 
Greenhouse
## Columns
| Type | Name | Description |
| -------- | ---------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------- |
| DATETIME | \_fivetran\_synced | |
| DATETIME | applied\_at | Timestamp of when the application was submitted. |
| INTEGER | candidate\_id | Foreign key referencing the CANDIDATE who submitted the application. |
| INTEGER | credited\_to\_user\_id | Foreign key referencing the USER who will receive credit for this application. |
| INTEGER | current\_stage\_id | Foreign key referencing the JOB\_STAGE that the application is currently at in the pipeline. |
| INTEGER | application\_id | Unique ID of the application. |
| DATETIME | last\_activity\_at | Timestamp of when the last activity was taken on this application. |
| INTEGER | location\_address | The content of the address question on a job post. |
| BOOLEAN | is\_prospect | Boolean that is true if this is a prospect application, which means that the associated person is a prospect and has not yet applied for this job. |
| INTEGER | prospect\_owner\_user\_id | Foreign key referencing the USER ID of the prospect owner. |
| INTEGER | prospect\_pool\_id | Foreign key referencing the PROSPECT\_POOL that the application came from. |
| INTEGER | prospect\_stage\_id | Foreign key referencing the ID of the application's PROSPECT\_POOL\_STAGE. |
| DATETIME | rejected\_at | Timestamp of when the application was rejected. |
| INTEGER | rejected\_reason\_id | Foreign key referencing the REJECTION\_REASON for the application. |
| INTEGER | source\_id | Foreign key referencing the ID of the SOURCE of the application. |
| STRING | status | One of - active, rejected, hired. |
| INTEGER | custom\_what\_is\_your\_preferred\_pronoun\_ | |
| INTEGER | custom\_how\_did\_you\_hear\_about\_fivetran\_ | |
| STRING | referrer\_name | Full name of the user who is credited with referring this application. |
| STRING | prospect\_owner\_name | Full name of the prospect owner. |
| STRING | current\_company | The company at which the candidate currently works. |
| INTEGER | coordinator\_user\_id | Foreign key referencing the USER who is responsible for coordinating this candidate. |
| STRING | full\_name | First and last name of the candidate. |
| BOOLEAN | is\_private | Boolean that is true if the candidate is private. |
| INTEGER | recruiter\_user\_id | Foreign key referencing the USER who is the recruiter assigned to this candidate. |
| INTEGER | current\_title | The candidate's current title. |
| DATETIME | last\_updated\_at | Timestamp of when the candidate profile was last updated. |
| STRING | phone | Comma-separated aggregated list of the candidate's phone numbers and the type of phone they are. |
| STRING | email | Comma-separated list of the candidate's email addresses. |
| STRING | resume\_url | URL of the candidate's most recently uploaded resume. |
| STRING | linkedin\_url | URL of the candidate's most recently added LinkedIn link. |
| STRING | github\_url | URL of the candidate's most recently added Github link. |
| STRING | coordinator\_name | Full name of the user who is responsible for coordinating with this candidate. |
| STRING | recruiter\_name | Full name of the candidate's assigned recruiter. |
| STRING | coordinator\_email | Email of the user who is responsible for coordinating with this candidate. |
| STRING | recruiter\_email | Email of the candidate's assigned recruiter. |
| DATETIME | candidate\_created\_at | Timestamp of when the candidate profile was created. |
| STRING | candidate\_tags | Comma-separated list of tags attached to this candidate. |
| STRING | current\_job\_stage | Current stage that the application is at in the hiring pipeline. |
| STRING | sourced\_from | Where the application was sourced from. |
| STRING | sourced\_from\_type | The category of source that the application came from. |
| INTEGER | count\_activities | Total count of activities completed on this candidate's profile. |
| STRING | job\_title | Title of the job role the candidate is applying for. |
| STRING | job\_status | Current status of the job being applied for. |
| STRING | hiring\_managers | Comma-separated list of the full names of the job's hiring managers. |
| INTEGER | job\_id | Foreign key referencing the JOB being applied for. |
| INTEGER | job\_requisition\_id | The id of the requisition corresponding to this job posting, if applicable. |
| STRING | job\_sourcers | Comma-separated list of the full names of the job's recruiting sourcers. |
| 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 | prospect\_pool | Name given to the applicant's prospect pool. |
| STRING | prospect\_stage | Current stage of the applicant within its prospect pool, if applicable. |
| 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. |
| STRING | application\_job\_key | Unique key hashed on `application_id` and `job_id`. This has to be done as the table contains both candidates and prospects. |
| BOOLEAN | has\_interviewed\_w\_hiring\_manager | Boolean that is true if the applicant has interviewed with one of the job's hiring managers. |
| INTEGER | count\_interviews | Total number of interviews had (1 interview with a panel of 3 interviewers = 1). |
| INTEGER | count\_interview\_scorecards | Count of feedback scorecards given (1 interview with a panel of 3 interviewers = 3). |
| INTEGER | count\_distinct\_interviewers | Count of internal users that the candidate has interviewed with. |
| DATETIME | latest\_interview\_scheduled\_at | The latest time that the candidate was scheduled to be interviewed at (can be in the future). |
---
# 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-application-enhanced.md?ask=
```
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.