Business Intelligence Connector update – April 29, 2020

We are making the following changes to the Greenhouse Analytics schema on May 14th, 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:

• Agency Custom Questions
  • New table agency_question_custom_fields added
• Candidate Consent Extensions
  • New table gdpr_consent_requests added
  • New table gdpr_consent_decision added

----

CREATE TABLE agency_question_custom_fields (
 application_id bigint,
 custom_field character varying,
 boolean_value boolean,
 float_value double precision,
 date_value timestamp without time zone,
 display_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 text,
 text_value text
);

CREATE TABLE gdpr_consent_requests (
 candidate_id bigint NOT NULL,
 status character varying NOT NULL,
 token character varying NOT NULL,
 requested_at timestamp without time zone NOT NULL
);

CREATE TABLE gdpr_consent_decisions (
 candidate_id bigint NOT NULL,
 decision character varying NOT NULL,
 decided_at timestamp without time zone NOT NULL
);