In an effort to improve our suite of products, Greenhouse Software regularly releases new product features, updates, and improvements. Stay up-to-date with what's new at Greenhouse by Following our Release Notes.

Find our releases for this week below:

 

Greenhouse Analytics

We are making the following changes to the Greenhouse Analytics schema on February 26th, 2020. See below for a description.

This update allows customers with the Business Intelligence Connector to view data regarding:

  • Opening Custom Fields
    • New table opening_custom_fields added
  • Multiple Demographic Question Sets
    • New table demographic_question_sets added
    • New column name added to the demographic_questions table
    • New column name added to the demographic_answer_options table
  • First Published Date for Job Posts
    • New column first_published added to the job_posts table
  • Data Retention Periods
    • New table gdpr_office_rules added

___

CREATE TABLE opening_custom_fields (
opening_id bigint NOT NULL,
custom_field character varying,
float_value double precision,
date_value date,
display_value text,
text_value text,
unit character varying,
min_value numeric,
max_value numeric,
user_id bigint,
created_at timestamp without time zone,
updated_at timestamp without time zone,
key character varying
);
ALTER TABLE ONLY opening_custom_fields
ADD CONSTRAINT opening_custom_fields_opening_id_fk FOREIGN KEY (opening_id) REFERENCES openings(id);
ALTER TABLE ONLY opening_custom_fields
ADD CONSTRAINT opening_custom_fields_user_id_fk FOREIGN KEY (user_id)
REFERENCES users(id);
CREATE TABLE demographic_question_sets (
id bigint NOT NULL,
organization_id bigint NOT NULL,
title character varying NOT NULL,
description character varying,
active boolean NOT NULL
);
CREATE TABLE demographic_questions (
id bigint NOT NULL,
organization_id bigint NOT NULL,
active boolean NOT NULL,
demographic_question_set_id bigint,
name character varying
);
CREATE TABLE demographic_answer_options (
id bigint NOT NULL,
demographic_question_id bigint NOT NULL,
active boolean NOT NULL,
free_form boolean NOT NULL,
name character varying
);
CREATE TABLE job_posts (
id bigint NOT NULL,
job_id bigint,
title character varying,
live boolean,
job_board_name character varying,
language character varying,
location character varying,
created_at timestamp without time zone,
updated_at timestamp without time zone,
eeoc_enabled boolean,
indeed_feed boolean,
linked_in_feed boolean,
glassdoor_feed boolean,
first_published timestamp without time zone
);
CREATE TABLE gdpr_office_rules (
    office_id bigint NOT NULL,
    retention_period bigint NOT NULL
);

 

Greenhouse Onboarding

  • Coming Soon: Greenhouse Onboarding is making some exciting updates to our task emails that will make it easier to track and take action on onboarding tasks. These changes will roll out in phases over the next few weeks. Click here to learn more about these planned releases. 
  • Greenhouse Onboarding's e-signature solution HelloSign has updated their e-signature editor. Click here to learn more.

 

Integrations

  • Greenhouse Recruiting just launched a  redesigned Integrations and Partners page that will easily allow your organization to view enabled integrations, customer preferred partners, etc...

Screen_Shot_2020-02-14_at_10.08.01_AM.png

 

Bug Fixes

  • We recently released a fix that now allows users with only Job Admin permission levels who can add and remove users to assigned jobs to successfully assign interviewer tags.

Screen_Shot_2019-04-17_at_1.05.19_PM.png