Greenhouse Analytics Schema Update - September 15, 2017

Hi everyone,

We are making the following changes to the Greenhouse Analytics schema on Friday, September 15, 2017! See below for a description, and see attached for the latest schema. If you have any questions or comments, please direct them to analytics@greenhouse.io.

Important note: We are additionally changing where we make these updates and are moving them to Zendesk.

To follow along for new updates you can go here: https://greenhouse.zendesk.com/hc/en-us/sections/200343835-Release-Notes# and click "Follow" and then "New Articles" - you will be notified about all changes moving forward here!

 

Pasted image at 2017_09_07 05_38 PM.png 

---

New Columns

  • created_at – represents the date that a certain record was created in the database
  • updated_at – represents the most recent date that a certain record was updated in the database

These columns will be appended to

  • application_custom_fields
  • application_question_answers
  • application
  • attributes
  • candidate_custom_fields
  • candidate_email_addresses
  • candidate_mailing_addresses
  • candidate_phone_numbers
  • candidates
  • educations
  • employments
  • hiring_team
  • interviewer_tags
  • interviews
  • job_custom_fields
  • job_posts
  • jobs (just updated_at is new)
  • jobs_attributes
  • jobs_departments
  • jobs_interviews
  • jobs_offices
  • jobs_stages
  • offer_custom_fields
  • offers (just updated_at is new)
  • offices
  • openings
  • referral_question_custom_fields
  • referrers
  • rejection_question_custom_fields
  • rejection_reasons
  • scorecard_question_answers
  • scorecards
  • scorecards_attributes
  • sources
  • tags
  • users
Have more questions? Submit a request

Comments

Powered by Zendesk