HRQ_PTCPNT_RESPONSES_V

Details

• Schema: FUSION

• Object owner: HRT

• Object type: VIEW

Columns

Name
PARTICIPANT_ID PARTICIPANT_TYPE SUBJECT_ID SUBJECT_CODE SUBSCRIBER_ID QUESTIONNAIRE_ID QSTNR_QUESTION_ID ANSWER_TEXT ANSWER_LIST QSTN_ANSWER_ID ANSWER_CLOB

Query

SQL_Statement

Select P.PARTICIPANT_ID , P.PARTICIPANT_TYPE , P.SUBJECT_ID , P.SUBJECT_CODE , P.SUBSCRIBER_ID , P.QUESTIONNAIRE_ID , R.QSTNR_QUESTION_ID , R.ANSWER_TEXT , R.ANSWER_LIST , R.QSTN_ANSWER_ID , R.ANSWER_CLOB From HRQ_QSTNR_PARTICIPANTS P, HRQ_QSTN_RESPONSES R, HRQ_QSTNR_RESPONSES Q Where Q.qstnr_participant_id = P.qstnr_participant_id and Q.attempt_num = (Select max(Q1.attempt_num) from HRQ_QSTNR_RESPONSES Q1 where Q1.qstnr_participant_id = Q.qstnr_participant_id and Q1.status = 'S') and R.qstnr_response_id = Q.qstnr_response_id