1. Tables and Views for HCM
  2. HRQ_QSTNR_LATEST_RESPS_V

HRQ_QSTNR_LATEST_RESPS_V

Details

  • Schema: FUSION

  • Object owner: HRT

  • Object type: VIEW

Columns

Name

QSTNR_RESPONSE_ID

QSTNR_PARTICIPANT_ID

QUESTIONNAIRE_ID

QSTNR_VERSION_NUM

PARTICIPANT_ID

PARTICIPANT_TYPE

SUBJECT_CODE

SUBJECT_ID

SUBSCRIBER_CODE

Query

SQL_Statement

Select R.qstnr_response_id, P.qstnr_participant_id, P.questionnaire_id, R.qstnr_version_num, P.participant_id, p.participant_type, P.subject_code, P.subject_id, S.subscriber_code

From HRQ_QSTNR_PARTICIPANTS P, HRQ_QSTNR_RESPONSES R, HRQ_SUBSCRIBERS_B S

Where R.qstnr_participant_id = P.qstnr_participant_id

and R.attempt_num = (Select max(R1.attempt_num)

From HRQ_QSTNR_RESPONSES R1

where R1.qstnr_participant_id = P.qstnr_participant_id

and R1.status = 'S')

and S.subscriber_id = P.subscriber_id

and S.business_group_id = P.business_group_id