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