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 firstname.lastname@example.org.
privateas a boolean to the `candidates` table
converted prospect_idas a bigint to `applications`
NULLif not applicable
- This will be the id of the corresponding prospect application that was converted to a candidate application