Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting on duplicate candidate profiles for hired candidates
Summary
Reporting on duplicate candidate profiles for hired candidatesContent
I'm trying to build a report that lists all the candidates that have been hired and also include a count of the number of candidate profiles that have the same firstName & lastName for that candidate (to identify duplicates). The columns I've included in my report are:
Candidate Identification.Last Name
Candidate Identification.First Name
Submission Dates. Offer Target Start Date
Submission Dates.Hire Start Date
Count(Candidate Identification.Candidate identifier WHERE Candidate Identification.First Name||Candidate Identification.Last Name) = Candidate Identification.First Name||Candidate Identification.Last Name of the record.
1