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.
Need tablename or query to extract the manager rating for the Evaluated Topic Performance Standar
Summary:
Do need to extract the manager rating for an employee against each goal
SELECT *
FROM HRG_GOALS
WHERE 1=1
AND GOAL_TYPE_CODE = 'PERFORMANCE'
AND GOAL_NAME = '*Performance Standard - Contributes to growing the brand'
AND PERSON_ID =:person_id
AND goal_id
in (select max(goal_id) from hrg_goals
where goal_type_code = 'PERFORMANCE'
AND GOAL_NAME='*Performance Standard - Contributes to growing the brand'
AND PERSON_ID = :person_id)
There are records in teh HRG_GOALS table if i pass the value to the HRG_GOAL_OUTCOMES no records for the goal_id
and also records exists in
Tagged:
0