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
@RVohra Thanks for your response .
I am looking for the table that store who did the prework for an employee among the participants in a talent review meeting . Have already checked dashboard and participant tables updated by and created by column .
Could you please help me with that .
@User_SQCUS ,
I don't believe there is a transactional table that explicitly records "Participant X completed prework for Employee Y" in Talent Review. You can still check HRR schema tables like following and see if it gets you who did the paperwork
HRR_MEETING_FACILITATORS -
FACILITATOR_PERSON_ID
NUMBER
18
Yes
Person Id of the meeting faciliator.
HRR_MEETING_PARTICIPANTS - This meeting table includes the list of participants for the meeting.
HRR_MEETING_REVIEWEES - This meeting table includes the list of reviewees for the meeting.
