nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

How to get reviewer details for an employee

User_SQCUS

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 .

Find more posts tagged with

talent management- Feedback Center

Accepted answers

All comments

Andrew_Schmitz

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

RVohra

@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

User_SQCUS

@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 .

Thanks

RVohra

@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.

Hope it helps!

MandeepGupta

Hi,

Welcome to Oracle Analytics and AI Community. Can you please provide us with some details around your current process so that we could guide you better with the flow and tables assoicated.

Thanks.

User_SQCUS

@MandeepGupta We are looking for the reviewer who completed the prework review for an employee eg:

When we select a Talent Review > select meeting > three dots : >View rating submission info

In this BIP report we are fectching status of associates also we need a column as reviewer where whoever among the reviewer from the list of participant completed the prework that should be picked .

I checked below tables :

HRR_MEETING_PARTICIPANTS - Last updated by is matching matching from the participant list but in that case we will get that many rows as many reviewer have completed the review. Is there a way we can only have 1 reviwer per associate

HRR_MEETING_REVIEWEES - This table have reviewer person id but its optional and blank for us.

Could you please help if you have any details around it.

Thanks,

Roma

MandeepGupta

Hi Roma,

Thanks for the details. So, based on the given screenshot, it seems two reviewers have completed the prework out of 4. So, you want to get these two reviewers?

Thanks.