I am looking for a table and a column which can give me details of reviewer who completed the review for an employee. I dont need total reviewer on a meeting .
Have you tried to search the subject area documentation? P https://docs.oracle.com/en/cloud/saas/human-resources/faohb/index.html https://docs.oracle.com/en/cloud/saas/human-resources/faohb/Workforce-Performance-Performance-Rating-Real-Time-SA-255.html
@User_SQCUS , Welcome to the Oracle Analytics and AI Community!
HRA_EVAL_PARTICIPANTS - This table stores the participants that are taking part Performance Document review.
HRA_EVALUATIONS - This table stores the primary data related to Performance Documents.
Use following query to further build on it as per your needs
SELECT hep.evaluation_id, hep.person_id reviewer_person_id, hep.role_type_code, hep.participation_status_code, hep.completed_date
FROM hra_eval_participants hep
WHERE hep.role_type_code = 'PARTICIPANT'
AND hep.participation_status_code = 'COMPLETED';
Hope it helps!
Thanks
Rajesh
