Report to capture hired candidates that ultimately do not begin working

Summary

Report to capture hired candidates that ultimately do not begin working

Content

I am trying to create a report of candidates that displays candidates that accepted a job offer but were subsequently not hired due to various reasons (ie, failed the background check, candidates withdraws their acceptance of the offer). I'm having trouble figuring out how to do this. 

Candidates will move through the following req-specific candidate status during the offer phase:

1. Offer Extended (the main status is under consideration)
2. Background check (this is a hired status) (the main status is hired)
3. Hired (when the background check is cleared) (the main status is hired)