1. Tables and Views for HCM
  2. HRA_EVAL_PCPN_QSTNR_V

HRA_EVAL_PCPN_QSTNR_V

Details

  • Schema: FUSION

  • Object owner: HRA

  • Object type: VIEW

Columns

Name

EVALUATION_ID

EVAL_PARTICIPANT_ID

TOTAL_SCORE

QSTNR_VERSION_NUM

Query

SQL_Statement

SELECT

HRA_EVALUATIONS.EVALUATION_ID,

HRA_EVAL_PARTICIPANTS.EVAL_PARTICIPANT_ID,

HRQ_QSTNR_RESPONSES.TOTAL_SCORE,

QSTNR_VERSION_NUM

FROM

HRQ_QSTNR_RESPONSES,

HRQ_QSTNR_PARTICIPANTS,

HRA_EVALUATIONS,

HRA_EVAL_PARTICIPANTS,

HRA_EVAL_SECTIONS

WHERE

HRQ_QSTNR_PARTICIPANTS.SUBJECT_ID = TO_CHAR(HRA_EVALUATIONS.EVALUATION_ID)

AND HRQ_QSTNR_PARTICIPANTS.PARTICIPANT_ID = TO_CHAR(HRA_EVAL_PARTICIPANTS.EVAL_PARTICIPANT_ID)

AND HRA_EVALUATIONS.EVALUATION_ID = HRA_EVAL_SECTIONS.EVALUATION_ID

AND HRA_EVALUATIONS.EVALUATION_ID = HRA_EVAL_PARTICIPANTS.EVALUATION_ID

AND HRA_EVAL_SECTIONS.SECTION_TYPE_CODE = 'QUESTIONNAIRE'

AND HRQ_QSTNR_PARTICIPANTS.QSTNR_PARTICIPANT_ID = HRQ_QSTNR_RESPONSES.QSTNR_PARTICIPANT_ID

AND HRQ_QSTNR_RESPONSES.ATTEMPT_NUM = (

SELECT

MAX(ATTEMPT_NUM)

FROM

HRQ_QSTNR_RESPONSES HRQ_QSTNR_RESPONSES1

WHERE

HRQ_QSTNR_RESPONSES.QSTNR_PARTICIPANT_ID = HRQ_QSTNR_RESPONSES1.QSTNR_PARTICIPANT_ID

)