HRQ_QUESTIONNAIRES

Details

Schema: FUSION
Object owner: HRQ
Object type: VIEW

Columns

Name
BUSINESS_GROUP_ID QUESTIONNAIRE_ID QSTNR_VERSION_NUM QUESTIONNAIRE_CODE STATUS CATEGORY_ID TEMPLATE_FLAG SUBSCRIBER_ID NAME DESCRIPTION KEYWORDS INTRO_TEXT QSTNR_TEMPLATE_ID PRIVACY_FLAG UPDATE_ALLOWED OWNER SECTION_ORDER SECTION_PRESENTATION PAGE_LAYOUT QSTNS_PER_PAGE IN_USE LATEST_VERSION VERSION_DESCRIPTION MODULE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN SCORED_FLAG CALC_RULE_CODE MAX_POSSIBLE_SCORE LAYOUT_OPTION SURVEY_TYPE

Name

BUSINESS_GROUP_ID

QUESTIONNAIRE_ID

QSTNR_VERSION_NUM

QUESTIONNAIRE_CODE

STATUS

CATEGORY_ID

TEMPLATE_FLAG

SUBSCRIBER_ID

NAME

DESCRIPTION

KEYWORDS

INTRO_TEXT

QSTNR_TEMPLATE_ID

PRIVACY_FLAG

UPDATE_ALLOWED

OWNER

SECTION_ORDER

SECTION_PRESENTATION

PAGE_LAYOUT

QSTNS_PER_PAGE

IN_USE

LATEST_VERSION

VERSION_DESCRIPTION

MODULE_ID

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

SCORED_FLAG

CALC_RULE_CODE

MAX_POSSIBLE_SCORE

LAYOUT_OPTION

SURVEY_TYPE

Query

SQL_Statement
SELECT B.BUSINESS_GROUP_ID, B.QUESTIONNAIRE_ID, B.QSTNR_VERSION_NUM, B.QUESTIONNAIRE_CODE, B.STATUS, B.CATEGORY_ID, B.TEMPLATE_FLAG, B.SUBSCRIBER_ID, L.NAME, L.DESCRIPTION, L.KEYWORDS, L.INTRO_TEXT, B.QSTNR_TEMPLATE_ID, B.PRIVACY_FLAG, B.UPDATE_ALLOWED, B.OWNER, B.SECTION_ORDER, B.SECTION_PRESENTATION, B.PAGE_LAYOUT, B.QSTNS_PER_PAGE, B.IN_USE, B.LATEST_VERSION, B.VERSION_DESCRIPTION, B.MODULE_ID, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.SCORED_FLAG, B.CALC_RULE_CODE, B.MAX_POSSIBLE_SCORE, B.LAYOUT_OPTION, B.SURVEY_TYPE FROM HRQ_QUESTIONNAIRES_B B, HRQ_QUESTIONNAIRES_TL L WHERE B.BUSINESS_GROUP_ID = L.BUSINESS_GROUP_ID AND B.QUESTIONNAIRE_ID = L.QUESTIONNAIRE_ID AND B.QSTNR_VERSION_NUM = L.QSTNR_VERSION_NUM AND L.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.BUSINESS_GROUP_ID,

B.QUESTIONNAIRE_ID,

B.QSTNR_VERSION_NUM,

B.QUESTIONNAIRE_CODE,

B.STATUS,

B.CATEGORY_ID,

B.TEMPLATE_FLAG,

B.SUBSCRIBER_ID,

L.NAME,

L.DESCRIPTION,

L.KEYWORDS,

L.INTRO_TEXT,

B.QSTNR_TEMPLATE_ID,

B.PRIVACY_FLAG,

B.UPDATE_ALLOWED,

B.OWNER,

B.SECTION_ORDER,

B.SECTION_PRESENTATION,

B.PAGE_LAYOUT,

B.QSTNS_PER_PAGE,

B.IN_USE,

B.LATEST_VERSION,

B.VERSION_DESCRIPTION,

B.MODULE_ID,

B.OBJECT_VERSION_NUMBER,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.SCORED_FLAG,

B.CALC_RULE_CODE,

B.MAX_POSSIBLE_SCORE,

B.LAYOUT_OPTION,

B.SURVEY_TYPE

FROM

HRQ_QUESTIONNAIRES_B B,

HRQ_QUESTIONNAIRES_TL L

WHERE

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