We are making the following changes to the Greenhouse Analytics schema on September 10, 2018! See below for a description, and see attached for the latest schema. If you have any questions or comments, please fill out the form at www.greenhouse.io/asksupport or click here to open a ticket with the Greenhouse Customer Support team.
---
We are adding a new table to the Business Intelligence Connector to make it easier to audit and report on your approvals process. No changes will be made to existing tables.
A table called `approvals` with the following dimensions will be added:
offer_id bigint - The Greenhouse generated Offer ID NULL if not applicable
application_id bigint - The Greenhouse generated Application ID. NULL if not applicable
job_id bigint - The Greenhouse generated Job ID
job_name character varying(1024) - The internal job name in Greenhouse
candidate_id bigint - The Greenhouse Candidate ID of the related Candidate. NULL if not applicable
candidate_name character varying(1024) - The name of the Candidate to whom this offer is being made. NULL if not applicable
approver_id bigint - The Greenhouse User ID of the approver for a given step
approver_name character varying(1024) - The name of the User with the associated User ID
approval_type character varying(32) - The type of approval; one of: `Open Job`, `Offer Job` , `Offer Candidate`
status character varying(32) - The status of the approval; one of: `Pending` , `Approved` or `Rejected`
group_id bigint - The Greenhouse generated approver group ID. Groups may include multiple approvers
group_order integer - The position of this Group in the approval chain; for example if this is the second approval step, this value will be `2`
group_quorum integer - The number of required approvers in a given Group. For example, if three out of four potential approvers must approve in a given step, this value will `3`
version integer - The version number of this particular approval. This only applies to Offers. NULL if not applicable
version_final integer - The last known version of this offer. This only applies to Offers. NULL if not applicable
assigned_at timestamp without time zone - The time at which this approval step was assigned to the approver
completed_at timestamp without time zone - The time at which this approval step was completed by the approver
created_at timestamp without time zone - The time at which this entry was created
updated_at timestamp without time zone - The last time at which this entry was updated