HRQ_ALL_QSTN_RESPONSES_V

Details

• Schema: FUSION

• Object owner: HRQ

• Object type: VIEW

Columns

Name
QSTNR_RESPONSE_ID QSTNR_QUESTION_ID BUSINESS_GROUP_ID QSTN_RESPONSE_ID ANSWER_TYPE ANSWER_TEXT ANSWER_CLOB ANSWER_ID

Query

SQL_Statement

SELECT QSTNR_RESPONSE_ID, QSTNR_QUESTION_ID, BUSINESS_GROUP_ID, QSTN_RESPONSE_ID, nvl2( ANSWER_ID || ANSWER_TEXT, nvl2( ANSWER_ID, 'RATING', 'ANSWER' ), NULL ) AS ANSWER_TYPE, ANSWER_TEXT, ANSWER_CLOB, ANSWER_ID FROM ( SELECT t.BUSINESS_GROUP_ID, t.QSTNR_RESPONSE_ID, t.QSTN_RESPONSE_ID, t.QSTNR_QUESTION_ID, t.ANSWER_TEXT, t.ANSWER_CLOB, TRIM(regexp_substr( t.answer_list, '[^,;]+', 1, level )) ANSWER_ID, level FROM HRQ_QSTN_RESPONSES t CONNECT BY regexp_substr( t.answer_list, '[^,]+', 1, level ) IS NOT NULL AND PRIOR QSTN_RESPONSE_ID = QSTN_RESPONSE_ID AND PRIOR sys_guid() IS NOT NULL )