HWR_SRVY_SUMMARY

Details

Schema: FUSION
Object owner: HWR
Object type: VIEW

Columns

Name
SURVEY_ID QUESTIONNAIRE_ID QUESTIONNAIRE_VERSION QUESTIONS OWNER_ID SUBSCRIBER_ID SUBSCRIBER_CODE PARTICPANT_COUNT PARTICPANT_COMPLETION_COUNT START_DATE EXPIIRATION_DATE ADVANCE_FLAG ANALYZED MEETING_ID IS_DELETED SURVEY_BASE_ATTR_1 SURVEY_BASE_ATTR_2 SURVEY_BASE_ATTR_3 SURVEY_BASE_ATTR_4 CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN SURVEY_NAME

Name

SURVEY_ID

QUESTIONNAIRE_ID

QUESTIONNAIRE_VERSION

QUESTIONS

OWNER_ID

SUBSCRIBER_ID

SUBSCRIBER_CODE

PARTICPANT_COUNT

PARTICPANT_COMPLETION_COUNT

START_DATE

EXPIIRATION_DATE

ADVANCE_FLAG

ANALYZED

MEETING_ID

IS_DELETED

SURVEY_BASE_ATTR_1

SURVEY_BASE_ATTR_2

SURVEY_BASE_ATTR_3

SURVEY_BASE_ATTR_4

CREATION_DATE

CREATED_BY

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

SURVEY_NAME

Query

SQL_Statement
SELECT B.SURVEY_ID SURVEY_ID, B.QUESTIONNAIRE_ID QUESTIONNAIRE_ID, B.QUESTIONNAIRE_VERSION QUESTIONNAIRE_VERSION, B.QUESTIONS QUESTIONS, B.OWNER_ID OWNER_ID, B.SUBSCRIBER_ID SUBSCRIBER_ID, B.SUBSCRIBER_CODE SUBSCRIBER_CODE, B.PARTICPANT_COUNT PARTICPANT_COUNT, B.PARTICPANT_COMPLETION_COUNT PARTICPANT_COMPLETION_COUNT, B.START_DATE START_DATE, B.EXPIIRATION_DATE EXPIIRATION_DATE, B.ADVANCE_FLAG ADVANCE_FLAG, B.ANALYZED ANALYZED, B.MEETING_ID MEETING_ID, B.IS_DELETED IS_DELETED, B.SURVEY_BASE_ATTR_1 SURVEY_BASE_ATTR_1, B.SURVEY_BASE_ATTR_2 SURVEY_BASE_ATTR_2, B.SURVEY_BASE_ATTR_3 SURVEY_BASE_ATTR_3, B.SURVEY_BASE_ATTR_4 SURVEY_BASE_ATTR_4, B.CREATION_DATE CREATION_DATE, B.CREATED_BY CREATED_BY, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, T.SURVEY_NAME SURVEY_NAME FROM HWR_SRVY_SUMMARY B, HWR_SRVY_SUMMARY_TL T WHERE B.SURVEY_ID = T.SURVEY_ID AND B.QUESTIONNAIRE_ID = T.QUESTIONNAIRE_ID AND B.QUESTIONNAIRE_VERSION = T.QUESTIONNAIRE_VERSION AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.SURVEY_ID SURVEY_ID,

B.QUESTIONNAIRE_ID QUESTIONNAIRE_ID,

B.QUESTIONNAIRE_VERSION QUESTIONNAIRE_VERSION,

B.QUESTIONS QUESTIONS,

B.OWNER_ID OWNER_ID,

B.SUBSCRIBER_ID SUBSCRIBER_ID,

B.SUBSCRIBER_CODE SUBSCRIBER_CODE,

B.PARTICPANT_COUNT PARTICPANT_COUNT,

B.PARTICPANT_COMPLETION_COUNT PARTICPANT_COMPLETION_COUNT,

B.START_DATE START_DATE,

B.EXPIIRATION_DATE EXPIIRATION_DATE,

B.ADVANCE_FLAG ADVANCE_FLAG,

B.ANALYZED ANALYZED,

B.MEETING_ID MEETING_ID,

B.IS_DELETED IS_DELETED,

B.SURVEY_BASE_ATTR_1 SURVEY_BASE_ATTR_1,

B.SURVEY_BASE_ATTR_2 SURVEY_BASE_ATTR_2,

B.SURVEY_BASE_ATTR_3 SURVEY_BASE_ATTR_3,

B.SURVEY_BASE_ATTR_4 SURVEY_BASE_ATTR_4,

B.CREATION_DATE CREATION_DATE,

B.CREATED_BY CREATED_BY,

B.LAST_UPDATED_BY LAST_UPDATED_BY,

B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

T.SURVEY_NAME SURVEY_NAME

FROM

HWR_SRVY_SUMMARY B,

HWR_SRVY_SUMMARY_TL T

WHERE

B.SURVEY_ID = T.SURVEY_ID AND B.QUESTIONNAIRE_ID = T.QUESTIONNAIRE_ID AND B.QUESTIONNAIRE_VERSION = T.QUESTIONNAIRE_VERSION AND T.LANGUAGE = USERENV('LANG')