Unable to report off candidate questionnaire

Summary

Need to report on 2nd pass applicaiton questionnaire answer

Content

We have a business requirement to produce a report each time a new pending worker is created. One of the data points that we need to pull in is the candidates response to a question on a questionnaire delivered in the 2nd pass application.

I can see the answer in ORC under 'Questions' but we are having difficulty reporting on it. Has anyone done this? If so can you share your SQL? Below is the SQL my tech resource tried, unsuccessfully.

 

Version

21A

Code Snippet

SELECT --PACV.PERSON_ID,
PAR.SUBJECT_ID,
--PATV.ALLOCATED_CHECKLIST_ID,
--PATV.TASK_NAME,
--PATV.QUESTIONNAIRE_ID,
QSTN.QUESTION_ID,
QSTN.QUESTION_TEXT,
RESP.QSTNR_RESPONSE_ID,
QRES.ANSWER_ID,
ANS.LONG_TEXT
FROM --PER_ALLOCATED_CHECKLISTS_VL PACV,
-- PER_ALLOCATED_TASKS_VL PATV,
Hrq_Qstnr_All_Qstns_V QSTNR,
Hrq_Questions_Vl QSTN,
Hrq_Qstnr_Responses RESP,
Hrq_All_Qstn_Responses_V QRES,
Hrq_All_Qstn_Answers_V ANS,
Hrq_Qstnr_Participants PAR
-- PER_ALL_ASSIGNMENTS_M PAAM
WHERE
--PACV.ALLOCATED_CHECKLIST_ID (+)= PATV.ALLOCATED_CHECKLIST_ID
--AND PATV.TASK_NAME LIKE 'Laptop Preference'
--AND PATV.QUESTIONNAIRE_ID (+)= QSTNR.QUESTIONNAIRE_ID
QSTNR.QUESTION_ID = QSTN.QUESTION_ID(+)
AND QSTN.QUESTION_TEXT like '%Lap%'
AND RESP.QSTNR_RESPONSE_ID = QRES.QSTNR_RESPONSE_ID
AND QSTNR.QSTNR_QUESTION_ID = QRES.QSTNR_QUESTION_ID
AND ANS.QA_QSTN_ANSWER_ID = QRES.ANSWER_ID
AND ANS.QUESTION_ID = QSTN.QUESTION_ID
--AND PAR.PARTICIPANT_ID = PATV.ALLOCATED_TASK_ID
AND Par.Qstnr_Participant_Id = RESP.Qstnr_Participant_Id
--AND PAR.SUBJECT_ID=paam.person_id(+)
--AND PAR.SUBJECT_ID=PACV.PERSON_ID(+)