Business Intelligence Connector update – February 10, 2020

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

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

___

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
);