HWR_SRVY_QSTN_BASE

Details

Schema: FUSION
Object owner: HWR
Object type: VIEW

Columns

Name
SUBSCRIBER_ID SUBSCRIBER_CODE QUESTIONNAIRE_ID QUESTIONNAIRE_VERSION QUESTIONNAIRE_NAME QUESTION_ID QUESTION_VERSION QUESTION_TEXT QUESTION_OWNER QUESTION_TYPE QUESTION_TIMESTAMP QUESTIONS_BASE_ATTR_1 QUESTIONS_BASE_ATTR_2 QUESTIONS_BASE_ATTR_3 QUESTIONS_BASE_ATTR_4 CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Name

SUBSCRIBER_ID

SUBSCRIBER_CODE

QUESTIONNAIRE_ID

QUESTIONNAIRE_VERSION

QUESTIONNAIRE_NAME

QUESTION_ID

QUESTION_VERSION

QUESTION_TEXT

QUESTION_OWNER

QUESTION_TYPE

QUESTION_TIMESTAMP

QUESTIONS_BASE_ATTR_1

QUESTIONS_BASE_ATTR_2

QUESTIONS_BASE_ATTR_3

QUESTIONS_BASE_ATTR_4

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement
SELECT B.SUBSCRIBER_ID, B.SUBSCRIBER_CODE, B.QUESTIONNAIRE_ID, B.QUESTIONNAIRE_VERSION, T.QUESTIONNAIRE_NAME, B.QUESTION_ID, B.QUESTION_VERSION, T.QUESTION_TEXT, B.QUESTION_OWNER, B.QUESTION_TYPE, B.QUESTION_TIMESTAMP, B.QUESTIONS_BASE_ATTR_1, B.QUESTIONS_BASE_ATTR_2, B.QUESTIONS_BASE_ATTR_3, B.QUESTIONS_BASE_ATTR_4, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM HWR_SRVY_QSTN_BASE_B B, HWR_SRVY_QSTN_BASE_TL T WHERE B.SUBSCRIBER_ID = T.SUBSCRIBER_ID AND B.QUESTIONNAIRE_ID = T.QUESTIONNAIRE_ID AND B.QUESTIONNAIRE_VERSION = T.QUESTIONNAIRE_VERSION AND B.QUESTION_ID = T.QUESTION_ID AND B.QUESTION_VERSION = T.QUESTION_VERSION AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.SUBSCRIBER_ID,

B.SUBSCRIBER_CODE,

B.QUESTIONNAIRE_ID,

B.QUESTIONNAIRE_VERSION,

T.QUESTIONNAIRE_NAME,

B.QUESTION_ID,

B.QUESTION_VERSION,

T.QUESTION_TEXT,

B.QUESTION_OWNER,

B.QUESTION_TYPE,

B.QUESTION_TIMESTAMP,

B.QUESTIONS_BASE_ATTR_1,

B.QUESTIONS_BASE_ATTR_2,

B.QUESTIONS_BASE_ATTR_3,

B.QUESTIONS_BASE_ATTR_4,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN

FROM

HWR_SRVY_QSTN_BASE_B B,

HWR_SRVY_QSTN_BASE_TL T

WHERE

B.SUBSCRIBER_ID = T.SUBSCRIBER_ID AND B.QUESTIONNAIRE_ID = T.QUESTIONNAIRE_ID AND B.QUESTIONNAIRE_VERSION = T.QUESTIONNAIRE_VERSION AND B.QUESTION_ID = T.QUESTION_ID AND B.QUESTION_VERSION = T.QUESTION_VERSION AND T.LANGUAGE = USERENV('LANG')