How can we help you?

Greenhouse Analytics Schema Update - August 14, 2018

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 direct them to analytics@greenhouse.io.

---

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

schema_2018_09_10.txt (30 KB)