Skip to content
Share
Explore
ID Mappings
ID Mappings
Name
Tables
Explanation
1
candidate_id
applications
demographics
The candidate_id allows looking up the candidate’s most recent demographic information in the demographics table.
For each application submitted, you can add the most recently submitted race/ethnicity and gender for the candidate.
For instance, this script would add the most recently submitted demographics information for each application:
select * from recruitee.applications a
left join recruitee.demographics d
on d.candidate_id = a.candidate_id
2
offer_id
offers
applications
offer_followers
The offer_id allows looking up offer details for applications table records.
For each application submitted, you can add the job title, number of disqualified candidates, etc. from the offers table. You can also add the followers for each offer (i.e., the hiring team) from the offer_followers table.
For instance, this script would add the offer information for each application:
select * from recruitee.applications a
left join recruitee.offers o
on a.offer_id = o.offer_id
And this script would add the hiring team for each offer:
select * from recruitee.offers o
left join recruitee.offer_followers of2
on o.offer_id = of2.offer_id
3
department_id
departments
offers
The department_id allows looking up the department details for the offer table records.
For each offer, you can add the job’s department information, such as the department the job belongs to.
For instance, this script would add the department information for each offer:
select * from recruitee.offers o
left join recruitee.departments d
on o.department_id = d.department_id
And this script would add the offer information and department information to each application:
select * from recruitee.applications a
left join recruitee.offers o
on o.offer_id = a.offer_id
left join recruitee.departments d
on d.department_id = o.department_id
4
stage_id
applications
stages
The stage_id allows looking up stage (i.e., where is the candidate currently within the specific job’s pipeline?) information and adding it to each job the candidate applied to within the applications table.
For each application submitted, you can add the stage name, stage category, etc. Candidates may apply to multiple jobs and therefore be in different stages for each of their records in the applications table.
For instance, this script would add the stage information for each application:
select * from recruitee.applications a
left join recruitee.stages s
on a.stage_id = s.stage_id
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.