How can we help you?

BI Connector Schema Update - April 29th, 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:

----

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

 
schema-042820.txt (40 KB)