Business Intelligence Connector update – April 28, 2023

We're making updates to Business Intelligence Connector on Friday, April 28, 2023.

Download the updated schema.

Overview of changes

Candidate surveys

The candidate_surveys table will receive an update to make the data consistent with the in-app candidate survey.

  • We're adding a column to the table to accommodate responses to question 9 from the candidate survey: "Is there anything you wish the company had done differently?" Candidate responses to question 9 will now appear in the question_9 column.

Check out a plaintext example of the updated table below:

CREATE TABLE candidate_surveys (
   id bigint,
   organization_id bigint,
   submitted_at timestamp without time zone,
   department_id bigint,
   department_name character varying,
   office_id bigint,
   office_name character varying,
   question_1 character varying,
   question_2 character varying,
   question_3 character varying,
   question_4 character varying,
   question_5 character varying,
   question_6 character varying,
   question_7 character varying,
   question_8 character varying,
question_9 character varying(16384)
);