How can we help you?

Greenhouse Analytics Schema Update- January 28th 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 direct them to analytics@greenhouse.io.

--- 

  • 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

 

 

schema.txt (30 KB)