We're making updates to Business Intelligence Connector on Friday, April 28, 2023.
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_9column.
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)
);