You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Performance document questionnaire with answers for worker and manager query

I am trying to build a query for Performance document questionnaire with answers for worker and manager query but its not giving correct answers.

When I add the tables for answers then row count increases.

Below is the query I am using.

Please suggest what join is missing.

SELECT DISTINCT papf.person_number Employee_ID
,ppnf.full_name Employee_Name

,paam.assignment_name
,ppos.date_start Start_Date
,papf1.person_number Manager_ID
,ppnf1.full_name Manager_Name,htpt.customary_name perf_doc_name

  --,he.evaluation_id       
,hes.section_type_code
,hsdv.name section_name
,he.status_code
,he.calibration_status

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!