dentify if any candidate record was merged
For the merged candidates pull the job application progress history
Check for any job applications that have moved directly from offer draft to hr phase and bring them up in the report
Pick the latest offer draft, check the next phase and state -> If in HR Pending Automated Processing