HRQ_QSTN_ANSWERS

Details

Schema: FUSION
Object owner: HRQ
Object type: VIEW

Columns

Name
BUSINESS_GROUP_ID QSTN_ANSWER_ID QUESTION_ID QSTN_VERSION_NUM SHORT_TEXT LONG_TEXT SEQ_NUM CORRECT_FLAG SCORE_WEIGHT MODULE_ID RATING_LEVEL_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN SCORE ADDL_QSTNR_ID ADDL_QSTNR_VERSION_NUM RESPONSE_FEEDBACK ANSWER_CODE

Name

BUSINESS_GROUP_ID

QSTN_ANSWER_ID

QUESTION_ID

QSTN_VERSION_NUM

SHORT_TEXT

LONG_TEXT

SEQ_NUM

CORRECT_FLAG

SCORE_WEIGHT

MODULE_ID

RATING_LEVEL_ID

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

SCORE

ADDL_QSTNR_ID

ADDL_QSTNR_VERSION_NUM

RESPONSE_FEEDBACK

ANSWER_CODE

Query

SQL_Statement
SELECT B.BUSINESS_GROUP_ID, B.QSTN_ANSWER_ID, B.QUESTION_ID, B.QSTN_VERSION_NUM, L.SHORT_TEXT, L.LONG_TEXT, B.SEQ_NUM, B.CORRECT_FLAG, B.SCORE_WEIGHT, B.MODULE_ID, B.RATING_LEVEL_ID, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.SCORE, B.ADDL_QSTNR_ID, B.ADDL_QSTNR_VERSION_NUM, L.RESPONSE_FEEDBACK, B.ANSWER_CODE FROM HRQ_QSTN_ANSWERS_B B, HRQ_QSTN_ANSWERS_TL L WHERE B.BUSINESS_GROUP_ID = L.BUSINESS_GROUP_ID AND B.QSTN_ANSWER_ID = L.QSTN_ANSWER_ID AND L.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.BUSINESS_GROUP_ID,

B.QSTN_ANSWER_ID,

B.QUESTION_ID,

B.QSTN_VERSION_NUM,

L.SHORT_TEXT,

L.LONG_TEXT,

B.SEQ_NUM,

B.CORRECT_FLAG,

B.SCORE_WEIGHT,

B.MODULE_ID,

B.RATING_LEVEL_ID,

B.OBJECT_VERSION_NUMBER,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.SCORE,

B.ADDL_QSTNR_ID,

B.ADDL_QSTNR_VERSION_NUM,

L.RESPONSE_FEEDBACK,

B.ANSWER_CODE

FROM

HRQ_QSTN_ANSWERS_B B,

HRQ_QSTN_ANSWERS_TL L

WHERE

B.BUSINESS_GROUP_ID = L.BUSINESS_GROUP_ID AND B.QSTN_ANSWER_ID = L.QSTN_ANSWER_ID AND L.LANGUAGE = USERENV('LANG')