We are making the following changes to the Greenhouse Analytics schema on March 11th, 2019! 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 the User <> Candidate linking we released earlier this year via a new table. The new table contains user ids and candidate ids that may be joined with their respective tables for more information.
If you have any questions or comments, please please fill out the form at www.greenhouse.io/asksupport or click here to open a ticket with the Greenhouse Customer Support team.
---
CREATE TABLE user_candidate_links (
user_id bigint,
candidate_id bigint,
created_at timestamp without time zone,
updated_at timestamp without time zone
);