Business Intelligence Connector update – January 28, 2019

We are making the following changes to the Greenhouse Analytics schema on January 28th, 2018! See below for a description, and see attached for the latest schema.

The first update is designed to make it easier for you to determine whether or not a candidate is Private.

Additionally, the applications table will now contain the id of the prospect application that was converted to create the candidate, if applicable.

These updates should make it easier to determine the status of a candidate and keep track of your CRM prospecting efforts. If you have any questions or comments, please fill out the form at or click here to open a ticket with the Greenhouse Customer Support team.


  • Adding private as a boolean to the `candidates` table
  • Adding converted prospect_id as a bigint to `applications`
    • NULL if not applicable
    • This will be the id of the corresponding prospect application that was converted to a candidate application