ATS v1: Data Model

This article applies to ATS v1s using the ATS v1 data model only.

Overview

In the ATS v1 Data Model, every stage is represented by a separate Custom Object and records are generated in the background against that Object every time a candidate is moved. This article walks through the process of relating Jobs and Candidates to the various job stages and tracking what stages a candidate goes through relies on a Custom Junction Object called Job Reporting.

If Job Reporting records are inaccurate or incomplete, moving a Candidate through the Bullhorn ATS may result in an error message.

Move To Stage Process

Available Stages:

  • Application
  • Submittal
  • Send Out
  • Offer
  • Closing Report

Status in Stage:

  • C = Current
  • A = Accepted
  • R = Rejected

When a Candidate or Job Card is moved to a stage, two actions occur:

  • A record for the destination stage is created that has a Job Manager Stage Status of Current.
  • The record from the previous stage is updated so that the Job Manager Stage Status is Accepted.

When a stage record is created or updated, the Job Manager Stage Status of the Candidate will always be set or updated. For any Candidate, there should only be one record related to a single job with a status of Current at a given time and any other stage record should be Accepted or Rejected.

The Job Reporting Object

Job Reporting has a Master-Detail relationship to Job and Lookup relationships to Contact, Application, Submittal, Send Out, Offer and Closing Report. The Composite Key field stores the ContactID+JobID and is used to make the correct association of Candidate and Job.

A Job reporting record is created or updated in the background for every Move To Stage action. The Job Reporting Related List does not need to be on the page layout as end users do not need to interact with it, but System Administrator need to be aware of it as it is useful for reporting and troubleshooting purposes.

Troubleshooting

  • If any of the Job Stage records are deleted, the corresponding Job Reporting record(s) must be deleted manually. Not doing this will result in bad data in the system and cause errors or Candidates being associated to incorrect stages or visualized incorrectly in Bullhorn ATSKanban.
  • If any Candidate on a Job has a duplicate Job Reporting record it may prevent that or any other Candidate from being moved to a different stage on the Job.