OTBI - Report on Most Recent Rejection Reason
Summary: Reporting on Reason for rejection/withdraw provides all rejections in a candidate's history on the requisition. Is there a way to display only the most recent rejection reason?
Content: Using the subject area "Recruiting - Recruiting Events Real Time", I am able to pull the field "Job Application History - Event Details"."Reason Name" to report on reject & withdraw reasons. (I also filter on the field "Job Application - Progression"."Current State" to identify only candidates in the Rejected by Employer and Withdrawn by Candidate states). However, some candidates were rejected more than once, and it's inflating our numbers. For example: