Business Intelligence Connector delivers a daily ETL of your organization's Greenhouse Recruiting and Greenhouse Onboarding data, dating from the time of your environment's creation. The data is comprehensive. This article provides a guide to the data, with a brief description of each table and what each row represents, as well as what to expect for each column.
Tip: Use your browser's Find feature (CMD + F on Mac | CTRL + F on Windows) to search for the data point you're interested in, like "custom candidate fields."
Application data
The applications table
The applications
table represents a snapshot of application data. Each row represents the latest status of a single application.
Note: This table doesn't contain any historical records.
Column | What to know |
|
This is the application ID. This appears as |
|
This is the candidate ID. |
|
This is the date and time the candidate applied, like 2024-01-31 06:00:00.000 . |
|
This is the application's current status and is one of active , converted , rejected , or hired . Converted applications represent prospect applications that were converted to candidate applications. |
|
This is Boolean, one of true or false , indicating whether the application is for a prospect. |
|
This is the stage ID of the application. |
|
This is the source ID for the application. |
|
This is the referrer ID for the application. |
|
This is the date and time the application was rejected, if applicable, like 2024-01-31 06:00:00.000 . |
|
This is the user ID of the person who rejected the application, if applicable. |
|
This is the rejection reason ID for a rejected application, if applicable. |
|
This is the percentage that an application has advanced through a job's stages, not including the application's current stage. For an application in a job's first stage, the pipeline percent is 0 . For an application in a job's last stage, the pipeline percent is {number of stages} - 1 / {number of stages} . For a hired application, the pipeline percent is [NULL] . For prospects, the pipeline percent is 0 . |
|
This is Boolean, one of true or false , indicating whether the application was migrated from a different ATS. |
|
This is the name of the Greenhouse Recruiting user who rejected the application, if applicable. |
|
This is the application's current stage name. |
|
This is the job post ID associated with the application. |
|
This is the name of the prospect pool, for prospect applications. |
|
This is the current prospect pool stage, for prospect applications. |
|
This is the Greenhouse Recruiting user who owns the prospect pool, for prospect applications, if applicable. |
|
This is the date and time the application was created, like 2024-01-31 06:00:00.000 . |
|
This is the last time the application was last updated, like 2024-01-31 06:00:00.000 . |
|
This is the event ID associated with a prospect application, if applicable. |
|
This represents a converted prospect application ID for applications that were converted from prospects. |
|
This is Boolean, one of true or false , indicating whether the application was sent demographic questions. |
|
This is your organization's unique Greenhouse Recruiting organization ID. |
The application custom fields table
The application_custom_fields
table represents custom application fields associated with an application. Each row represents a single value of a single custom field for a single application.
Column | What to know |
|
This is the application ID. |
|
This is the custom application field name. |
|
These are number values entered in the custom application field, if applicable. |
|
This is the date entered in the custom application field, if applicable. |
|
This is how the custom application field value appears on the candidate profile. |
|
This is the currency type entered in the custom application field, if applicable. |
|
This column isn't used here, so a NULL value is shown. |
|
This column isn't used here, so a NULL value is shown. |
|
This is the Greenhouse Recruiting user ID for custom application fields with user field types. |
|
This is the date and time the custom application field was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the custom application field was last updated, like 2024-01-31 06:00:00.000 . |
|
This is the immutable field key for the custom application field. |
|
This is the text value as it appears on the application's custom application field. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The application question answers table
The application_question_answers
table represents questions and answers that candidates submitted in response to job posts with their applications. Each row represents a single job post application question and answer from a single application.
Column | What to know |
|
This is the job post ID. |
|
This is the application ID. |
|
This is the application question from the job post. |
|
This is the applicant's answer to the application question. |
|
This is the date the application was received, like 2024-01-31 06:00:00.000 . |
|
This is the date the application was last updated, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Recruiting ID. |
The application stages table
The application_stages
table represents the historical activity of all stages an application has been on, as well as each stage that an application could be on, taken from the job stage setup. Each row represents a single stage that an application can be in and the timestamp that the application entered and exited the stage.
Note: Some applications may show rows for stages that an application has yet to reach, or will never reach if the application was rejected, in which case a NULL
value is shown.
Column | What to know |
|
This is the application ID. |
|
This is the stage ID. |
|
This is the date the application entered the stage, like 2024-01-31 06:00:00.000 . Some applications may show rows for stages that an application has yet to reach, or will never reach if the application was rejected, in which case a NULL value is shown. |
|
This is the date the application exited the stage, like 2024-01-31 06:00:00.000 . Some applications may show rows for stages that an application has yet to reach, or will never reach if the application was rejected, in which case a NULL value is shown. |
|
This is the job stage name. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The applications jobs table
The applications_jobs
table represents applications for jobs. Each row represents one application to one job.
Column | What to know |
|
This is the application ID. |
|
This is the job ID. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The referral question custom fields table
The referral_question_custom_fields
table represents custom referral questions associated with an application. Each row represents a single value of a single custom referral question for a single application.
Column | What to know |
|
This is the candidate ID. |
|
This is the custom referral question. |
|
These are numbers entered in the custom referral question answer, if applicable. |
|
This is a date entered in the custom referral question answer, if applicable. |
|
This is the candidate's response to the custom referral question as it appears in Greenhouse Recruiting. |
|
This is the currency type entered in the custom referral question answer, if applicable. |
|
This column isn't used here, so a NULL value is shown. |
|
This column isn't used here, so a NULL value is shown. |
|
This is the Greenhouse Recruiting user ID for custom referral questions with user answer field types. |
|
This is the date and time the custom referral question was answered, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the custom referral question answer was last updated, like 2024-01-31 06:00:00.000 . |
|
This is the immutable field key for the custom referral question. |
|
This is the answer as it appears on the application's custom referral question. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The rejection question custom fields table
The rejection_question_custom_fields
table represents custom rejection questions associated with an application. Each row represents a single value of a single custom rejection question for a single application.
Column | What to know |
|
This is the application ID. |
|
This is the custom rejection question. |
|
These are numbers entered in the custom rejection question answer, if applicable. |
|
This is the date entered in the custom rejection question answer, if applicable. |
|
This is the response to the custom rejection question as it appears in Greenhouse Recruiting. |
|
This is the currency type entered in the custom rejection question answer, if applicable. |
|
This column isn't used here, so a NULL value is shown. |
|
This column isn't used here, so a NULL value is shown. |
|
This is the Greenhouse Recruiting user ID for custom rejection questions with user answer field types. |
|
This is the date and time the custom rejection question was answered, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the custom rejection question answer was last updated, like 2024-01-31 06:00:00.000 . |
|
This is the immutable field key for the custom rejection question. |
|
This is the answer as it appears on the application's custom rejection question. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The agency question custom fields table
The agency_question_custom_fields
table represents custom agency questions associated with an application. Each row represents a single value of a single custom agency question for a single application.
Column | What to know |
|
This is the application ID. |
|
This is the custom agency question. |
|
This is Boolean, one of true or false , indicating whether the custom agency question is a yes / no question. |
|
These are numbers entered in the custom agency question answer, if applicable. |
|
This is the date entered in the custom agency question answer, if applicable. |
|
This is the response to the custom agency question as it appears in Greenhouse Recruiting. |
|
This is the currency type entered in the custom rejection question answer, if applicable. |
|
This column isn't used here, so a NULL value is shown. |
|
This column isn't used here, so a NULL value is shown. |
|
This column isn't used here, so a NULL value is shown. |
|
This is the date and time the custom agency question was answered, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the custom agency question answer was last updated, like 2024-01-31 06:00:00.000 . |
|
This is the immutable field key for the custom rejection question. |
|
This is the answer as it appears on the application's custom rejection question. |
|
This is your organization's unique Greenhouse Recruiting ID. |
Candidate data
The candidates table
The candidates
table represents a snapshot of candidate data. Each row represents a single candidate. A candidate is a person. A candidate may have multiple applications for multiple jobs.
Column | What to know |
|
This is the candidate ID. This appears as |
|
This is the candidate's first name. |
|
This is the candidate's last name. |
|
This is the candidate's recruiter's ID. A candidate might not have the same recruiter assigned to the hiring team of the candidate's job if their application has been added to another job or if their profile has been merged. |
|
This is the candidate's coordinator's ID. A candidate might not have the same coordinator assigned to the hiring team of the candidate's job if their application has been added to another job or if their profile has been merged. |
|
This is Boolean, one of true or false , indicating whether the candidate was migrated from a previous ATS. |
|
This is the recruiter's name. |
|
This is the coordinator's name. |
|
This is the candidate's current company, if applicable. |
|
This is the candidate's current title, if applicable. |
|
This is the date and time the candidate was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the candidate was last updated, like 2024-01-31 06:00:00.000 . |
|
This is Boolean, one of true or false , indicating whether the candidate is private. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The candidate custom fields table
The candidate_custom_fields
table represents custom candidate fields associated with a candidate. Each row represents a single value of a single custom field for a single candidate.
Column | What to know |
|
This is the candidate ID. |
|
This is the custom candidate field. |
|
These are numbers entered in the custom candidate field, if applicable. |
|
This is the date entered in the custom candidate field, if applicable. |
|
This is the value entered into the custom candidate field as it appears in Greenhouse Recruiting. |
|
This is the currency type entered in the custom candidate field, if applicable. |
|
This column isn't used here, so a NULL value is shown. |
|
This column isn't used here, so a NULL value is shown. |
|
This is the Greenhouse Recruiting user ID entered for custom candidate fields with user field types. |
|
This is the date and time the custom candidate field value was entered, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the custom candidate field value was last updated, like 2024-01-31 06:00:00.000 . |
|
This is the immutable field key for the custom candidate field. |
|
This is the answer as it appears on the application's custom candidate field. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The candidate tags table
The candidate_tags
table represents all candidate tags associated with a candidate. Each row represents a single tag on a single candidate.
Column | What to know |
|
This is the candidate ID. |
|
This is the candidate tag ID. |
|
This is the date and time the candidate tag was created for the candidate, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the candidate tag was updated on the candidate, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Recruiting ID. |
The educations table
The educations
table represents all structured education fields associated with a candidate. Each row represents a single structured education for a single candidate.
Note: Data is only collected in this table when education is added to candidate profiles in a structured method in Greenhouse Recruiting.
Column | What to know |
|
This is the candidate ID. |
|
This is the school name associated with the candidate. |
|
This is the degree associated with the candidate. |
|
This is the school discipline associated with the candidate. |
|
This is the date the candidate started the education, if applicable, like2024-01-01 . |
|
This is the date the candidate ended the education, if applicable, like2024-01-01 . |
|
This is Boolean, one of true or false , indicating whether the education is the latest the candidate has experienced. |
|
This is the date and time the education was associated with the candidate profile, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the education for the candidate profile was last updated, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Recruiting ID. |
The employments table
The employments
table represents all structured employment fields associated with a candidate. Each row represents a single structured employment record for a single candidate.
Note: Data is only collected in this table when employment is added to candidate profiles in a structured method in Greenhouse Recruiting.
Column | What to know |
|
This is the candidate ID. |
|
This is the company name associated with the candidate. |
|
This is the title associated with the candidate. |
|
This is the date the candidate started the employment, if applicable, like2024-01-01 . |
|
This is the date the candidate ended the employment, if applicable, like2024-01-01 . |
|
This is Boolean, one of true or false , indicating whether the employment is the latest the candidate has experienced. |
|
This is the date and time the employment was associated with the candidate profile, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the employment for the candidate profile was last updated, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Recruiting ID. |
Candidate PII data
The candidate email addresses table
The candidate_email_addresses
table represents a list of email addresses by candidate. Each row represents a single email address and the associated candidate.
Note: This table is opt-in only. You can enable this table in your ETL.
Column | What to know |
|
This is the candidate ID. |
|
This is the candidate's email address. |
|
This is the date and time the email address was associated with the candidate, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the email address for the candidate was last updated, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Recruiting ID. |
The candidate mailing addresses table
The candidate_mailing_addresses
table represents a list of mailing addresses by candidate. Each row represents a single mailing address and the associated candidate.
Note: This table is opt-in only. You can enable this table in your ETL.
Column | What to know |
|
This is the candidate ID. |
|
This is the candidate's mailing address. |
|
This is the date and time the mailing address was associated with the candidate, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the mailing address for the candidate was last updated, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Recruiting ID. |
The candidate phone numbers table
The candidate_phone_numbers
table represents a list of phone numbers by candidate. Each row represents a single phone number and the associated candidate.
Note: This table is opt-in only. You can enable this table in your ETL.
Column | What to know |
|
This is the candidate ID. |
|
This is the candidate's phone number. |
|
This is the date and time the phone number was associated with the candidate, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the phone number for the candidate was last updated, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Recruiting ID. |
Demographic data
The demographic answers table
The demographic_answers
table represents responses to U.S. standard or custom demographic questions. Each row represents a single application's response to a custom demographic question. You can join this table with the demographic questions and demographic answer options table.
Note: Custom demographic questions are only available to Expert subscription tier.
Column | What to know |
|
This is the demographic question answer ID. |
|
This is the application ID. |
|
This is the demographic question ID. |
|
This is the demographic question answer option ID. |
|
This is the date and time the demographic answer was associated with the candidate, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the demographic answer for the candidate was last updated, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Recruiting ID. |
The demographic answer options table
The demographic_answer_options
table represents answer options to U.S. standard or custom demographic questions. Each row represents a single custom demographic question answer option. You can join this table with the demographic questions and demographic answers table.
Note: Custom demographic questions are only available to Expert subscription tier.
Column | What to know |
|
This is the demographic question answer option ID. |
|
This is the demographic question ID. |
|
This is Boolean, one of |
|
This is Boolean, one of |
|
This is the demographic question answer option. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The demographic answer option translations table
The demographic_answer_option_translations
table represents translated answer options to U.S. standard or custom demographic questions. Each row represents a single translated custom demographic question answer option. You can join this table with the demographic questions and demographic answers table.
Note: This table has been deprecated. Only English en
is currently supported. Custom demographic questions are only available to Expert subscription tier.
Column | What to know |
|
This is the demographic question answer option ID. |
|
This is the demographic question answer option ID. |
|
This is the demographic question answer option language. This table has been deprecated. Only English |
|
This is the demographic question answer option. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The demographic free form answers table
The demographic_free_form_answers
table represents free-text answer options to U.S. standard or custom demographic questions. Each row represents a single application's response to free-text custom demographic questions. You can join this table with the demographic questions and demographic answers table.
Note: Custom demographic questions are only available to Expert subscription tier.
Column | What to know |
|
This is the demographic free form answer ID. |
|
This is the demographic answer ID. |
|
This is the free-text answer from the candidate. |
|
This is the date and time the demographic answer was associated with the candidate, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the demographic answer for the candidate was last updated, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Recruiting ID. |
The demographic questions table
The demographic_questions
table represents U.S. standard or custom demographic questions. Each row represents a single U.S. standard or custom demographic question. You can join this table with the demographic answers and demographic questions table.
Note: Custom demographic questions are only available to Expert subscription tier.
Column | What to know |
|
This is the demographic question ID. This appears in other tables as |
|
This is your organization's unique Greenhouse Recruiting ID. |
|
This is Boolean, one of |
|
This is the demographic question set ID. An organization can have multiple demographic question sets. |
|
This is the text of the demographic question as it appears in Greenhouse Recruiting. |
|
This is Boolean, one of true or false , indicating whether the demographic question is required. |
|
This is the answer type and is one of Single select or Multi select . |
The demographic question set table
The demographic_question_sets
table represents U.S. standard or custom demographic question sets. Each row represents a single group of custom demographic questions. You can join this table with the demographic answers and demographic questions table.
Note: Custom demographic questions are only available to Expert subscription tier.
Column | What to know |
|
This is the demographic question set ID. This appears in other tables as |
|
This is your organization's unique Greenhouse Recruiting ID. |
|
This is the demographic question set title, as shown in Greenhouse Recruiting. |
|
This is the demographic question set description, as shown in Greenhouse Recruiting. |
|
This is Boolean, one of |
The demographic question translations table
The demographic_question_translations
table represents translated U.S. standard or custom demographic questions. Each row represents a single translated custom demographic question. You can join this table with the demographic questions and demographic answers table.
Note: This table has been deprecated. Only English en
is currently supported.
Custom demographic questions are only available to Expert subscription tier.
Column | What to know |
|
This is the demographic question ID. |
|
This is the demographic question ID. |
|
This is the demographic question answer option language. This table has been deprecated. Only English |
|
This is the text of the demographic question as it appears in Greenhouse Recruiting. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The EEOC responses table
The eeoc_responses
table represents responses to EEOC questions. Each row represents a single application's responses to EEOC questions.
Note: Data is only collected in this table when a candidate responds to EEOC questions on an application, or when a request is sent to a candidate to respond to EEOC questions. Data isn't collected for candidates who didn't respond to questions on the job post or didn't receive a request to respond to the questions afterward.
Column | What to know |
|
This is the application ID. |
|
This is the EEOC response status and is one of responded or pending response . |
|
This is the application response to the EEOC questions |
|
This is the application response to the EEOC question Gender . |
|
This is the application response to the EEOC question Disability Status . |
|
This is the application response to the EEOC question Veteran Status . |
|
This is the date and time the EEOC response was submitted, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Recruiting ID. |
Greenhouse Onboarding data
Note: Greenhouse Onboarding data is opt-in only and is only available to Greenhouse Onboarding subscribers.
The Greenhouse Onboarding assigned tasks table
The gho_assigned_tasks
table represents a list of assigned tasks from Greenhouse Onboarding. Each row represents a single assigned task and the associated Greenhouse Onboarding employee.
Column | What to know |
|
This is the task ID. |
|
This is the task name. |
|
This is the task description. |
|
This is the task category and is one of Build Relationships , Job Training , Know the Company , or Logistics . |
|
This is the ID of the person to whom the task was assigned. |
|
This is the ID of the person who assigned the task. |
|
This is the date and time the task was completed, like 2024-01-31 06:00:00.000 . |
|
This is the number of days before or after the employee's start date that the task was due, if applicable. |
|
This is the number of days before the employee's start date that the task was due. |
|
This is the calculated due date for the task based on the new hire's start date, like 2024-01-31 . |
|
This is the calculated due date for the task based on the new hire's start date, like 2024-01-31 . |
|
This is Boolean, one of true or false , indicating whether the task requires an attachment. |
|
This is the date and time the task was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the task was last updated, like 2024-01-31 06:00:00.000 . |
|
This is the ID of the person assigned to complete the task. |
|
If using a third-party system for a task, this is the system email. |
|
This is the custom field assigned to complete the task. |
|
This is the coworker employee ID assigned to complete the task. |
|
This is the ID of the person who completed the task. |
|
This is the third-party task system that completed the task, if applicable. |
|
This is the date and time the task assignee was last updated, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the task was assigned, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Onboarding ID. |
The Greenhouse Onboarding custom fields table
The gho_custom_fields
table represents a list of your custom fields in Greenhouse Onboarding. Each row represents a single Greenhouse Onboarding custom field.
Column | What to know |
|
This is the custom field ID. |
|
This is the permanent field ID. |
|
This is the custom field name as it appears in Greenhouse Onboarding. |
|
This is the field type and is one of text , long_text , multiple_choice , multiple_select , contact , team , date , employee , address , legal_name , preferred_name , image , country , or masked . |
|
This is the date and time the custom field was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the custom field was last updated, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Onboarding ID. |
The Greenhouse Onboarding custom field values table
The gho_custom_field_values
table represents a list of available values associated with employees from your custom fields in Greenhouse Onboarding. Each row represents a single Greenhouse Onboarding custom field value and the associated employee.
Column | What to know |
|
This is the custom field value ID. |
|
This is the employee ID. |
|
This is the custom field ID. |
|
This is the custom field's permanent field ID. |
|
This is the custom field type and is one of text , long_text , multiple_choice , multiple_select , contact , team , date , employee , address , legal_name , preferred_name , image , country , or masked . |
|
This is the value entered on the employee's profile for the custom field. |
|
This is the date entered in the custom field, if applicable. |
|
This is the date and time the custom field was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the custom field was last updated, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Onboarding ID. |
The Greenhouse Onboarding employees table
The gho_employees
table represents a list of employees in Greenhouse Onboarding. Each row represents a single Greenhouse Onboarding employee.
Column | What to know |
|
This is the employee ID. |
|
This is the date and time the employee profile was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the employee profile was last updated, like 2024-01-31 06:00:00.000 . |
|
This is the employee's personal email address. |
|
This is the employee's work email address. |
|
This is the employee's start date, like 2024-01-31 . |
|
This is the employee's termination date, like 2024-01-31 , if applicable. |
|
This is the employee's employment status, like full_time . |
|
This is the employee's manager's ID. |
|
This is the employee's HR manager's ID. |
|
This is the employee's job title. |
|
This is the employee's role and is one of owner , coordinator , or employee . |
|
This is the number of the employee's direct reports. |
|
This is the employee's office. |
|
This is the employee's location. |
|
This is the employee's legal first name. |
|
This is the employee's legal last name. |
|
This is the employee's legal middle name. |
|
This is the employee's legal name suffix. |
|
This is the employee's preferred first name. |
|
This is the employee's preferred last name. |
|
This is your organization's unique Greenhouse Onboarding ID. |
The Greenhouse Onboarding employee roles table
The gho_employee_roles
table represents a list of employee roles in Greenhouse Onboarding. Each row represents a single Greenhouse Onboarding role and the associated Greenhouse Onboarding employee.
Column | What to know |
|
This is the employee's role ID. This ID comes from the |
|
This is the employee ID. |
|
This is your organization's unique Greenhouse Onboarding ID. |
The Greenhouse Onboarding roles table
The gho_roles
table represents a list of roles in Greenhouse Onboarding. Each row represents a single Greenhouse Onboarding role.
Column | What to know |
|
This is the role ID. |
|
This is the name of the role as it appears in Greenhouse Onboarding. |
|
This is your organization's unique Greenhouse Onboarding ID. |
The Greenhouse Onboarding user activities table
The gho_user_activities
table represents a list of all user activities in Greenhouse Onboarding. Each row represents a single activity from Greenhouse Onboarding and the associated employee.
Column | What to know |
|
This is the employee ID. |
|
This is the date and time the employee last signed in, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Onboarding ID. |
Job data
The jobs table
The jobs
table represents a list of jobs and their statuses in Greenhouse Recruiting. Each row represents the status of a single job.
Column | What to know |
|
This is the job ID. |
|
This is your organization's unique Greenhouse Recruiting ID. |
|
This is the job's internal name as it appears in Greenhouse Recruiting. |
|
This is the job's requisition ID. |
|
This is the job status and is one of open , closed , or draft . |
|
This is the date and time the job was opened, if applicable, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the job was closed, if applicable, like 2024-01-31 06:00:00.000 . |
|
This is the job's department ID. |
|
This is the job's level. |
|
This is Boolean, one of true or false , indicating whether the job is confidential. |
|
This is the date and time the job was created, like 2024-01-31 06:00:00.000 . |
|
These are notes entered on the job. |
|
This is the date and time the job was updated, like 2024-01-31 06:00:00.000 . |
The job custom fields table
The job_custom_fields
table represents custom job fields associated with a job. Each row represents a custom job field associated with a single job.
Column | What to know |
|
This is the job ID. |
|
This is the custom job field name as it appears in Greenhouse Recruiting. |
|
These are numbers entered in the custom job field, if applicable. |
|
This is the date entered in the custom job field, if applicable. |
|
This is the value entered into the custom job field as it appears in Greenhouse Recruiting. |
|
This is the currency type entered in the custom job field, if applicable. |
|
This is the minimum value entered in the custom job field for number range and currency range field types. |
|
This is the maximum value entered in the custom job field for number range and currency range field types. |
|
This is the Greenhouse Recruiting user ID entered for custom job fields with user field types. |
|
This is the date and time the custom job field value was associated with the job, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the custom job field value was last updated, like 2024-01-31 06:00:00.000 . |
|
This is the immutable field key for the custom job field. |
|
This is the value entered on the custom job field as it appears in Greenhouse Recruiting. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The job snapshots table
The job_snapshots
table represents a daily snapshot of job activity. Each row represents job-level metrics for a single day.
Column | What to know |
|
This is the job ID. |
|
This is the date of the snapshot, like 2024-01-31 . |
|
This is the count of new hires in the day. |
|
This is the count of new prospects in the day. |
|
This is the count of new applications in the day. |
|
This is the count of rejected applications in the day. |
|
This is the count of applications advanced in the day. |
|
This is the count of interviews in the day. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The jobs attributes table
The jobs_attributes
table represents a list of scorecard attributes on jobs. Each row represents a single scorecard attribute on a single job.
Column | What to know |
|
This is the scorecard attribute ID. |
|
This is the job ID. |
|
This is the scorecard attribute ID. |
|
This is Boolean, one of true or false , indicating whether the scorecard attribute is active. |
|
This is the date and time the scorecard attribute was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the scorecard attribute was last updated, like 2024-01-31 06:00:00.000 . |
|
This is the name of the scorecard attribute as it appears in Greenhouse Recruiting. |
|
This is the category of the scorecard attribute as it appears in Greenhouse Recruiting. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The jobs departments table
The jobs_departments
table represents a list of departments by job. Each row represents a single department on a single job. Tiered departments will show a row for each parent and child department a job is associated with.
Column | What to know |
|
This is the primary key to this table. |
|
This is the job ID. |
|
This is the department ID associated with the job. |
|
This is the date and time the department was associated with the job, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the department on the job was last updated, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Recruiting ID. |
The jobs interviews table
The jobs_interviews
table represents a list of interviews by job. Each row represents a single interview on a single stage for a single job.
Column | What to know |
|
This is the interview ID. |
|
This is the job ID. |
|
This is the stage ID. |
|
This is the interview ID. |
|
This is the order of the interview on a stage with multiple interviews. |
|
This is the estimated duration of the interview in minutes. |
|
This is the date and time the interview was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the interview was last updated, like 2024-01-31 06:00:00.000 . |
|
This is the interview name as it appears in Greenhouse Recruiting. |
|
This is the stage name as it appears in Greenhouse Recruiting. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The jobs offices table
The jobs_offices
table represents a list of offices by job. Each row represents a single office on a single job. Tiered offices will show a row for each parent and child office a job is associated with.
Column | What to know |
|
This is the primary key to this table. |
|
This is the job ID. |
|
This is the office ID associated with the job. |
|
This is the date and time the job was associated with the office, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the job's office was last updated, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Recruiting ID. |
The jobs posts table
The job_posts
table represents a list of job posts by job. Each row represents details of a job post associated with a job.
Column | What to know |
|
This is the job post ID. |
|
This is the job ID. |
|
This is the job post title. |
|
This is Boolean, one of true or false , indicating whether the job post is live on your job board. |
|
This is the job board name associated with the job post. |
|
This is the language the job post was published in, like en for English. |
|
This is the job post location. |
|
This is the date and time the job post was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the job post was last updated, like 2024-01-31 06:00:00.000 . |
|
This is Boolean, one of true or false , indicating whether the job post includes EEOC questions. |
|
This is Boolean, one of true or false , indicating whether the job post was published on Indeed. This shows a NULL value for internal job posts. |
|
This is Boolean, one of true or false , indicating whether the job post was published on LinkedIn. |
|
The Glassdoor free job post integration has been deprecated, so a NULL is shown. |
|
This is the date and time the job post was first published, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Recruiting ID. |
The job post questions table
The job_post_questions
table represents a list of job post questions by job post. Each row represents a single job post question associated with a single job post.
Column | What to know |
|
This is the job post ID. |
|
This is the job post question. |
|
This is the date and time the job post question was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the job post question was last updated, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Recruiting ID. |
The jobs stages table
The jobs_stages
table represents a list of stages by job. Each row represents a single stage on a single job.
Column | What to know |
|
This is the job ID. |
|
This is the stage ID. |
|
This is the order the stage appears on the job. |
|
This is the name of the stage as it appears in Greenhouse Recruiting. |
|
This is the number of days set for a stage alert setting, if applicable. |
|
This is the date and time the job stage was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the job stage was last updated, like 2024-01-31 06:00:00.000 . |
|
This is the milestone associated with the stage. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The hiring team table
The hiring_team
table represents a list of hiring teams by job. Each row represents a single Greenhouse Recruiting user on a hiring team role on a single job.
Column | What to know |
|
This is the job ID. |
|
This is the user ID of the person associated with the hiring team role. |
|
This is the hiring team role associated with the person. |
|
This is Boolean, one of true or false , indicating whether the person holds a responsible role on the hiring team. |
|
This is the date and time the hiring team role was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the hiring team role was last updated, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Recruiting ID. |
The openings table
The openings
table represents a list of openings by job. Each row represents a single opening for a single job.
Column | What to know |
|
This is the primary key to this table. |
|
This is the job ID. |
|
This is the opening ID. |
|
This is the date and time the opening was opened, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the opening was closed, if applicable, like 2024-01-31 06:00:00.000 . |
|
This is the hired application's ID, if applicable. |
|
This is the close reason selected, if applicable. |
|
This is the date and time the opening was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the opening was last updated, like 2024-01-31 06:00:00.000 . |
|
This is the opening's target start date. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The opening custom fields table
The opening_custom_fields
table represents a snapshot of custom opening fields. Each row represents a single value of a single custom opening field for a single opening.
Column | What to know |
|
This is the opening ID. |
|
This is the custom opening field. |
|
These are numbers entered in the custom opening field, if applicable. |
|
This is the date entered in the custom opening field, if applicable. |
|
This is the value entered into the custom opening field as it appears in Greenhouse Recruiting. |
|
This is the currency type entered in the custom opening field, if applicable. |
|
This is the minimum value entered in the custom opening field for number range and currency range field types. |
|
This is the maximum value entered in the custom opening field for number range and currency range field types. |
|
This is the Greenhouse Recruiting user ID entered for custom opening fields with user field types. |
|
This is the date and time the custom opening field value was associated with the opening, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the custom opening field value was last updated, like 2024-01-31 06:00:00.000 . |
|
This is the immutable field key for the custom opening field. |
|
This is the value entered on the custom opening field as it appears in Greenhouse Recruiting. |
|
This is your organization's unique Greenhouse Recruiting ID. |
Offer data
The offers table
The offers
table represents all offers. Each row represents the details of a single version of an offer for a single application. Each new version of an offer generates a new row of data.
Column | What to know |
|
This is the offer ID. |
|
This is the application ID. |
|
This is the status of the offer and is one of created , accepted , rejected , or deprecated . |
|
This is the date and time the offer was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the offer was sent to the candidate, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the offer was accepted or rejected, like 2024-01-31 06:00:00.000 . |
|
This is the date and time of the new hire's start date, like 2024-01-31 06:00:00.000 . |
|
This is the Greenhouse Recruiting user who created the offer. |
|
This is the date and time the offer was last updated, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Recruiting ID. |
The offer custom fields table
The offer_custom_fields
table represents all custom offer fields associated with an offer. Each row represents a single value of a single custom field for a single offer.
Column | What to know |
|
This is the custom offer field. |
|
These are numbers entered in the custom offer field, if applicable. |
|
This is the date entered in the custom offer field, if applicable. |
|
This is the value entered into the custom offer field as it appears in Greenhouse Recruiting. |
|
This is the currency type entered in the custom offer field, if applicable. |
|
This is the minimum value entered in the custom offer field for number range and currency range field types. |
|
This is the maximum value entered in the custom offer field for number range and currency range field types. |
|
This is the Greenhouse Recruiting user ID entered for custom offer fields with user field types. |
|
This is the date and time the custom offer field value was associated with the offer, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the custom offer field value was last updated, like 2024-01-31 06:00:00.000 . |
|
This is the immutable field key for the custom offer field. |
|
This is the value entered on the custom offer field as it appears in Greenhouse Recruiting. |
|
This is your organization's unique Greenhouse Recruiting ID. |
Organization data
The organizations table
The organizations
table represents the name and ID of your organization. Each row represents a single organization and ID.
Column | What to know |
|
This is your organization's unique Greenhouse Recruiting ID. This appears in other tables as organization_id . |
|
This is your organization's name. |
The attributes table
The attributes
table represents a list of all scorecard attributes ever used on a scorecard. Each row represents a single scorecard attribute.
Column | What to know |
|
This is the scorecard attribute ID. |
|
This is your organization's unique Greenhouse Recruiting ID. |
|
This is the name of the scorecard attribute as it appears in Greenhouse Recruiting. |
|
This is the scorecard attribute category. |
|
This is the date and time the scorecard attribute was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the scorecard attribute was last updated, like 2024-01-31 06:00:00.000 . |
The departments table
The departments
table represents a list of all departments. Each row represents a single department. This table can be joined to any table that has a department_id
to get the name of the department.
Column | What to know |
|
This is the department ID. |
|
This is your organization's unique Greenhouse Recruiting ID. |
|
This is the name of the department as it appears in Greenhouse Recruiting. |
|
This is the department's parent department ID, if applicable. |
|
This is the date and time the department was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the department was last updated, like 2024-01-31 06:00:00.000 . |
The events table
The events
table represents a list of all your organization's events. Each row represents a single event.
Column | What to know |
|
This is the event ID. |
|
This is the name of the event as it appears in Greenhouse Recruiting. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The interviews table
The interviews
table represents a list of all your organization's interviews. Each row represents a single interview.
Column | What to know |
|
This is the interview ID. |
|
This is your organization's unique Greenhouse Recruiting ID. |
|
This is the name of the interview as it appears in Greenhouse Recruiting. |
|
This is the date and time the interview was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the interview was last updated, like 2024-01-31 06:00:00.000 . |
The interviewer tags table
The interviewer_tags
table represents a list of all your organization's interviewer tags. Each row represents a single interviewer tag for a single user.
Column | What to know |
|
This is the user ID associated with the interviewer tag. |
|
This is the interviewer tag as it appears in Greenhouse Recruiting. |
|
This is the date and time the interview was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the interview was last updated, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Recruiting ID. |
The offices table
The offices
table represents a list of all offices. Each row represents a single office. This table can be joined to any table that has a office_id
to get the name of the office.
Column | What to know |
|
This is the office ID. |
|
This is your organization's unique Greenhouse Recruiting ID. |
|
This is the name of the office as it appears in Greenhouse Recruiting. |
|
This is the office's parent office ID, if applicable. |
|
This is the date and time the office was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the office was last updated, like 2024-01-31 06:00:00.000 . |
The referrers table
The referrers
table represents a list of all referrers. Each row represents a single referrer. This table can be joined to any table that has a referrer_id
to get the name of the referrer.
Column | What to know |
|
This is the referrer ID. |
|
This is your organization's unique Greenhouse Recruiting ID. |
|
This is the name of the referrer as it appears in Greenhouse Recruiting. |
|
This is the user ID associated with the referrer, if applicable. |
|
This is the date and time the referrer was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the referrer was last updated, like 2024-01-31 06:00:00.000 . |
The rejection reasons table
The rejection_reasons
table represents a list of all rejection reasons. Each row represents a single rejection reason.
Column | What to know |
|
This is the rejection reason ID. |
|
This is your organization's unique Greenhouse Recruiting ID. |
|
This is the name of the rejection reason as it appears in Greenhouse Recruiting. |
|
This is the type of the rejection reason. |
|
This is the date and time the rejection reason was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the rejection reason was last updated, like 2024-01-31 06:00:00.000 . |
The sources table
The sources
table represents a list of all sources. Each row represents a single source. This table can be joined to any table with a source_id
to get the name of the source.
Column | What to know |
|
This is the source ID. |
|
This is your organization's unique Greenhouse Recruiting ID. |
|
This is the name of the source as it appears in Greenhouse Recruiting. |
|
This is the type of the source. |
|
This is the date and time the source was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the source was last updated, like 2024-01-31 06:00:00.000 . |
The tags table
The tags
table represents a list of all candidate tags. Each row represents a single candidate tag.
Column | What to know |
|
This is the tag ID. |
|
This is your organization's unique Greenhouse Recruiting ID. |
|
This is the name of the tag as it appears in Greenhouse Recruiting. |
|
This is the date and time the tag was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the tag was last updated, like 2024-01-31 06:00:00.000 . |
The users table
The users
table represents a list of all users. Each row represents a single Greenhouse Recruiting user. This table can be joined to any other table that has a user_id
to get the name of a user.
Column | What to know |
|
This is the user ID. |
|
This is your organization's unique Greenhouse Recruiting ID. |
|
This is the user's first name. |
|
This is the user's last name. |
|
This is the user's Greenhouse Recruiting email address. |
|
This is the user's current status in Greenhouse Recruiting and is one of active or disabled . |
|
This is the user's full name. |
|
This is the user's employee ID. |
|
This is the date and time the user was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the user was last updated, like 2024-01-31 06:00:00.000 . |
The user attribute custom fields table
The user_attribute_custom_fields
table represents a list of all custom user fields. Each row represents a single value from a single custom user field for a single user.
Column | What to know |
|
This is the user ID associated with the custom user field. |
|
This is the custom user field. |
|
These are numbers entered in the custom user field, if applicable. |
|
This is the date entered in the custom user field, if applicable. |
|
This is the value entered into the custom user field as it appears in Greenhouse Recruiting. |
|
This is the currency type entered in the custom user field, if applicable. |
|
This is the minimum value entered in the custom user field for number range and currency range field types. |
|
This is the maximum value entered in the custom user field for number range and currency range field types. |
|
This is the Greenhouse Recruiting user ID entered for custom user fields with user field types. |
|
This is the date and time the custom user field value was associated with a user, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the custom user field value was last updated, like 2024-01-31 06:00:00.000 . |
|
This is the immutable field key for the custom user field. |
|
This is the value entered on the custom user field as it appears in Greenhouse Recruiting. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The user candidate links table
The user_candidate_links
table represents a list of all user candidate links. Each row represents a single user linked to a single candidate.
Column | What to know |
|
This is the user ID. |
|
This is the candidate ID linked to the user. |
|
This is the date and time the user candidate link was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the user candidate link was last updated, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Recruiting ID. |
Process data
The audit log table
The audit_log
table represents a list of audit log results in Greenhouse Recruiting. Each row represents a single audit log result.
Note: Audit log is only available to Expert subscription tier.
Column | What to know |
|
This is the ID of the audit log request, which can be used to link an event and its resulting changes across multiple audit log results. |
|
This is the type of request. |
|
This is the name and Greenhouse Recruiting email address of the person who performed the change or the exact type of API key that performed the event. |
|
This is the Greenhouse Recruiting user ID of the person who performed the change, or the API key name if performed via Greenhouse API. |
|
This is the IP address of the performer of the change. |
|
This is the performer type and is one of user , api_key , or greenhouse_internal . |
|
This is the date and time the event occurred, like 2024-01-31 06:00:00.000 . |
|
This is the type of event that occurred. |
|
This is the type of event that occured and is one of data_change_update , data_change_create , data_change_destroy , harvest_access , or action . action event types are defined in the audit log glossary. |
|
This is the ID of the element that was created, edited, or accessed. This may be blank if the action doesn't target one particular ID. |
|
This is the before and after values from data change events, or other relevant data for the event such as the title of a report. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The scheduled interviews table
The scheduled_interviews
table represents a list of scheduled interviews. Each row represents a single scheduled interview.
Note: Data is only collected in this table when an interview is scheduled with Greenhouse Recruiting, as evidenced by the presence of a Greenhouse Recruiting scheduling calendar on the scheduled interview's calendar invite. If an interview occurs or a scorecard is submitted on a meeting that was scheduled outside Greenhouse Recruiting, it won't appear in this table.
Column | What to know |
|
This is the user ID associated with the scheduled interview. |
|
This is the application ID associated with the scheduled interview. |
|
This is the interview ID. |
|
This is the interview's feedback status and is one of complete or awaiting_feedback . |
|
This is the original scheduler or organizer of the interview. If an interview is rescheduled, this field doesn't update. |
|
This is the date and time the interview was scheduled at, like 2024-01-31 06:00:00.000 . If an interview is rescheduled, this timestamp doesn't update. |
|
This is the date and time the interview was scheduled to start, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the interview was scheduled to end, like 2024-01-31 06:00:00.000 . |
|
This is the start date for all-day interviews, like 2024-01-31 . |
|
This is the end date for all-day interviews, like 2024-01-31 . |
|
This is the stage name associated with the scheduled interview. |
|
This is the interview name. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The interviewers table
The interviewers
table represents a list of interviewers per scheduled interview. Each row represents a single interviewer for a scheduled interview.
Column | What to know |
|
This is the interview ID. |
|
This is the user ID associated with the interview. |
|
This is the scorecard associated with the interview. |
|
This is the user name associated with the interview. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The scorecards table
The scorecards
table represents data on submitted scorecards. Each row represents a single submitted scorecard. Connect the scheduled_interviews
table to the interviewers
table, then connect the scorecards
table to the interviewers
table.
Note: Data only appears in this table when a scorecard is submitted in Greenhouse Recruiting.
Column | What to know |
|
This is the scorecard ID. |
|
This is the application ID. |
|
This is the stage ID. |
|
This is the interview ID. |
|
This is the interviewer ID. |
|
This is the user ID of the person who submitted the scorecard. |
|
This is the scorecard's overall recommendation and is one of Yes , Strong Yes , No , Strong No or No Decision . |
|
This is the date and time the scorecard was submitted, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the scheduled interview ended, like 2024-01-31 06:00:00.000 . |
|
This is the total count of scorecard focus attributes on the scorecard. |
|
This is the total count of scorecard focus attributes completed on the scorecard. |
|
This is the interviewer's name. |
|
This is the scorecard submitter's name. |
|
This is the stage associated with the scorecard. |
|
This is the date and time the scorecard was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the scorecard was last updated, like 2024-01-31 06:00:00.000 . |
|
This is the interview name. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The scorecard attributes table
The scorecard_attributes
table represents attribute-level data on submitted scorecards. Each row represents an attribute rating on a submitted scorecard.
Column | What to know |
|
This is the scorecard ID. |
|
This is the scorecard attribute ID. |
|
This is the scorecard attribute rating. |
|
These are the notes associated with the attribute rating, if applicable. |
|
This is the date and time the scorecard was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the scorecard was last updated, like 2024-01-31 06:00:00.000 . |
|
This is the scorecard attribute name. |
|
This is the scorecard attribute category. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The scorecard questions table
The scorecard_questions
table represents a snapshot of your organization's scorecard questions. Each row represents a single scorecard question from a single job.
Column | What to know |
|
This is the scorecard question ID. |
|
This is the interview kit ID. |
|
This is the scorecard question. |
|
This is the scorecard question answer type. |
|
This is Boolean, one of true or false , indicating whether the scorecard question is active. |
|
This is the priority order of the question on the scorecard. |
|
This is Boolean, one of true or false , indicating whether the scorecard question is required. |
|
This is the date and time the scorecard question was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the scorecard question was last updated, like 2024-01-31 06:00:00.000 . |
|
These are the scorecard focus attributes associated with the scorecard question, if applicable. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The scorecard question answers table
The scorecard_question_answers
table represents submitted scorecard questions and answers. Each row represents a single scorecard question and a single submitted scorecard answer.
Column | What to know |
|
This is the scorecard ID. |
|
This is the application ID. |
|
This is the scorecard question. |
|
This is the scorecard answer. |
|
This is the date and time the scorecard was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the scorecard was last updated, like 2024-01-31 06:00:00.000 . |
|
This is the scorecard question ID. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The stage snapshots table
The stage_snapshots
table represents a daily snapshot of stage-level activity. Each row represents the number of active applications in the stage at 4am ET on a given date for jobs that were open at that time.
Column | What to know |
|
This is the stage ID. |
|
This is the date of the stage snapshot. |
|
This is the number of active applications on the stage. |
|
This is the job ID. |
|
This is the stage name as it appears in Greenhouse Recruiting. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The candidate surveys table
The candidate_surveys
table represents a list of candidate survey responses. Each row represents a single response to a candidate survey.
Note: To protect candidate privacy, candidate survey responses are not associated with a specific candidate or job.
Column | What to know |
|
This is the candidate survey response ID. |
|
This is your organization's unique Greenhouse Recruiting ID. |
|
This is the date and time the candidate survey response was submitted, like 2024-01-31 06:00:00.000 . |
|
This is the department ID associated with the candidate survey. |
|
This is the department name associated with the candidate survey. |
|
This is the office ID associated with the candidate survey. |
|
This is the office name associated with the candidate survey. |
|
This is the candidate's response to the first candidate survey question. |
|
This is the candidate's response to the second candidate survey question. |
|
This is the candidate's response to the third candidate survey question. |
|
This is the candidate's response to the fourth candidate survey question. |
|
This is the candidate's response to the fifth candidate survey question. |
|
This is the candidate's response to the sixth candidate survey question. |
|
This is the candidate's response to the seventh candidate survey question. |
|
This is the candidate's response to the eighth candidate survey question. |
|
This is the candidate's response to the ninth candidate survey question. |
The candidate survey questions table
The candidate_survey_questions
table represents a list of candidate survey questions. Each row represents a single candidate survey question.
Column | What to know |
|
This is the candidate survey question ID. |
|
This is the text of the candidate survey question. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The approvals table
The approvals
table represents a list of approvals. Each row represents a specific job or offer approval associated with each approver.
Column | What to know |
|
This is the offer ID. |
|
This is the application ID. |
|
This is the job ID. |
|
This is the job name as it appears in Greenhouse Recruiting. |
|
This is the candidate ID. |
|
This is the candidate's name. |
|
This is the user ID of the approver. |
|
This is the approver's name. |
|
This is the approval type and is one of Offer Candidate for candidate offers, or Open Job or Offer Job for one or two-stage job approvals respectively. |
|
This is the approval status and is one of Due , Waiting , Approved , or Rejected . |
|
This is the approval version. |
|
This is the final version of the approval. |
|
This is the approval group ID. |
|
This is the approver's order in the approval group. |
|
This is the number at which group quorum is reached. |
|
This is the date and time the approval was assigned, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the approval was completed, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the approval was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the approval was last updated, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Recruiting ID. |
The GDPR consent requests table
The gdpr_consent_requests
table represents a list of GDPR consent requests. Each row represents a timestamped GDPR request to a single candidate.
Column | What to know |
|
This is the candidate ID. |
|
This is the status of the GDPR consent request. |
|
This is a token associated with the GDPR consent request. |
|
This is the date and time the GDPR consent was requested, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Recruiting ID. |
The GDPR consent decisions table
The gdpr_consent_decisions
table represents a list of when candidates gave or denied GDPR consent. Each row represents a timestamped approval or denial of GDPR consent by a single candidate.
Column | What to know |
|
This is the candidate ID. |
|
This is the candidate's decision for the GDPR consent request and is one of given or denied . |
|
This is the date and time the GDPR consent decision was submitted, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Recruiting ID. |
The GDPR office rules table
The gdpr_office_rules
table represents a list of GDPR office rules. Each row represents a single office's GDPR retention period.
Column | What to know |
|
This is the office ID associated with the GDPR rule. |
|
This is the retention period in days for the GDPR office rule. |
|
This is your organization's unique Greenhouse Recruiting ID. |
The prospect pools table
The prospect_pools
table represents a list of prospect pools. Each row represents a single prospect pool.
Column | What to know |
|
This is the prospect pool ID. |
|
This is the name of the prospect pool as it appears in Greenhouse Recruiting. |
|
This is Boolean, one of true or false , indicating whether the prospect pool is active. |
|
This is the prospect pool description, if applicable. |
|
This is the date and time the prospect pool was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the prospect pool was last updated, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Recruiting ID. |
The prospect pool stages table
The prospect_pool_stages
table represents a list of prospect pool stages. Each row represents a single prospect pool stage from a single prospect pool.
Column | What to know |
|
This is the prospect pool stage ID. |
|
This is the prospect pool ID. |
|
This is the name of the prospect pool stage. |
|
This is the order of the prospect pool stage. |
|
This is the date and time the prospect pool stage was created, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the prospect pool stage was last updated, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Recruiting ID. |
The prospect pool transitions table
The prospect_pool_transitions
table records when an application is moved from one prospect pool to another, or from one prospect pool stage to another. Each row represents a single prospect's movement from a single prospect pool to another prospect pool or stage.
Column | What to know |
|
This is the prospect's application ID. |
|
This is the user ID associated with moving the prospect. |
|
This is the ID of the prospect's former prospect pool, if applicable. |
|
This is the ID of the prospect's former prospect pool stage, if applicable. |
|
This is the ID of the prospect's new prospect pool, if applicable. |
|
This is the ID of the prospect's new prospect pool stage, if applicable. |
|
This is the date and time the prospect pool transition occurred, like 2024-01-31 06:00:00.000 . |
|
This is the date and time the prospect was last updated, like 2024-01-31 06:00:00.000 . |
|
This is your organization's unique Greenhouse Recruiting ID. |
Usage data
The Greenhouse usages table
The greenhouse_usages
table represents a record of Greenhouse Recruiting usage by users. Each row represents a record of a user using Greenhouse Recruiting on a single date.
Column | What to know |
|
This is the user ID. |
|
This is the date of the Greenhouse Recruiting usage, like 2024-01-31 . |
|
This is your organization's unique Greenhouse Recruiting ID. |
The user actions table
The user_actions
table represents a record of user actions in Greenhouse Recruiting. Each row represents a single action from a user on a single job.
Note: Not all actions in Greenhouse Recruiting are collected in this table. In general, it's better to look for a timestamped activity in another table.
Column | What to know |
|
This is the user action ID. |
|
This is the job ID. |
|
This is the user ID of the person who performed the action. |
|
This is the type of action and is one of advanced_candidate or email_sent . |
|
This is your organization's unique Greenhouse Recruiting ID. |