Business Intelligence Connector delivers a nightly ETL of your organization's Greenhouse Recruiting or Greenhouse Onboarding data. The data model relies on three main keys, on which other tables and columns are mapped.
There are three main keys in Business Intelligence Connector data:
|Candidates||A candidate is a person who can submit any number of applications for any number of jobs, meaning they can apply to one job many times, or to many jobs at different times. A candidate is represented in the model by
|Applications||Only one application can be submitted for a single job. This information is summarized in the
|Jobs||A job is a role with one or more openings. A job is represented in the model by
Candidates in the
candidates table can be associated with the following candidate-level tables using
candidate_id as a key:
Applications in the
applications table can be associated with the following application-level tables using
application_id as a key:
Jobs in the
jobs table can be associated with the following job-level tables using
job_id as a key:
Process and applicant tracking data
As applications move through the hiring pipeline, process and applicant tracking data is generated for each application ID.
There are a few other tables that are not keyed to candidates, applications, or jobs:
Every other data table is a simple mapping table that maps an ID to the name of the item represented. For example, the
attributes table maps an attribute ID to the name of the attribute.