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
0