We are making the following changes to the BI Connector schema on March 15, 2022. See the information below for a description of the changes. You can download the latest schema file by clicking the attachment on the right side of the page.
New column on the applications table
sent_demographic_questions - If true, the candidate has had the opportunity to respond to demographic questions, either by applying directly to a job post or by receiving a job post request email.
CREATE TABLE applications (
id bigint NOT NULL,
applied_at timestamp without time zone,
status character varying,
rejected_at timestamp without time zone,
pipeline_percent double precision,
rejected_by character varying,
stage_name character varying,
prospect_pool character varying(65535),
prospect_pool_stage character varying(65535),
created_at timestamp without time zone,
updated_at timestamp without time zone,