HRQ_QUESTIONS

Details

Schema: FUSION
Object owner: HRQ
Object type: VIEW

Columns

Name
BUSINESS_GROUP_ID QUESTION_ID QSTN_VERSION_NUM QUESTION_TEXT CATEGORY_ID SUBSCRIBER_ID QUESTION_TYPE RESPONSE_TYPE_ID MIN_LENGTH MAX_LENGTH MIN_SELECTIONS MAX_SELECTIONS OWNER PRIVACY_FLAG UPDATE_ALLOWED ADHOC_FLAG RATING_MODEL_ID LATEST_VERSION VERSION_DESCRIPTION ATTACHMENT_ALLOWED STATUS QUESTION_CODE MODULE_ID OVERRIDE_DESC_FLAG OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN SCORED_FLAG MIN_THRESHOLD_SCORE MAX_THRESHOLD_SCORE MAX_POSSIBLE_SCORE CLASSIFICATION_CODE CANDIDATE_CODE ALL_LOCATIONS_FLAG ALL_ORGANIZATIONS_FLAG ALL_JOB_FAMILIES_FLAG ALL_JOB_FUNCTIONS_FLAG CONDITION_QUESTION_ID CONDITION_QSTN_VERSION_NUM CONDITION_ANSWER_ID CONDITION_DISPLAY QSTN_SAMPLE_SIZE QSTN_RESPONSE_ORDER MIN_DATE MAX_DATE INSTRUCTIONS_TEXT ENABLE_COMMENTS SURVEY_TYPE

Name

BUSINESS_GROUP_ID

QUESTION_ID

QSTN_VERSION_NUM

QUESTION_TEXT

CATEGORY_ID

SUBSCRIBER_ID

QUESTION_TYPE

RESPONSE_TYPE_ID

MIN_LENGTH

MAX_LENGTH

MIN_SELECTIONS

MAX_SELECTIONS

OWNER

PRIVACY_FLAG

UPDATE_ALLOWED

ADHOC_FLAG

RATING_MODEL_ID

LATEST_VERSION

VERSION_DESCRIPTION

ATTACHMENT_ALLOWED

STATUS

QUESTION_CODE

MODULE_ID

OVERRIDE_DESC_FLAG

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

SCORED_FLAG

MIN_THRESHOLD_SCORE

MAX_THRESHOLD_SCORE

MAX_POSSIBLE_SCORE

CLASSIFICATION_CODE

CANDIDATE_CODE

ALL_LOCATIONS_FLAG

ALL_ORGANIZATIONS_FLAG

ALL_JOB_FAMILIES_FLAG

ALL_JOB_FUNCTIONS_FLAG

CONDITION_QUESTION_ID

CONDITION_QSTN_VERSION_NUM

CONDITION_ANSWER_ID

CONDITION_DISPLAY

QSTN_SAMPLE_SIZE

QSTN_RESPONSE_ORDER

MIN_DATE

MAX_DATE

INSTRUCTIONS_TEXT

ENABLE_COMMENTS

SURVEY_TYPE

Query

SQL_Statement
SELECT B.BUSINESS_GROUP_ID, B.QUESTION_ID, B.QSTN_VERSION_NUM, L.QUESTION_TEXT, B.CATEGORY_ID, B.SUBSCRIBER_ID, B.QUESTION_TYPE, B.RESPONSE_TYPE_ID, B.MIN_LENGTH, B.MAX_LENGTH, B.MIN_SELECTIONS, B.MAX_SELECTIONS, B.OWNER, B.PRIVACY_FLAG, B.UPDATE_ALLOWED, B.ADHOC_FLAG, B.RATING_MODEL_ID, B.LATEST_VERSION, B.VERSION_DESCRIPTION, B.ATTACHMENT_ALLOWED, B.STATUS, B.QUESTION_CODE, B.MODULE_ID, B.OVERRIDE_DESC_FLAG, 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.MIN_THRESHOLD_SCORE, B.MAX_THRESHOLD_SCORE, B.MAX_POSSIBLE_SCORE, B.CLASSIFICATION_CODE, B.CANDIDATE_CODE, B.ALL_LOCATIONS_FLAG, B.ALL_ORGANIZATIONS_FLAG, B.ALL_JOB_FAMILIES_FLAG, B.ALL_JOB_FUNCTIONS_FLAG, B.CONDITION_QUESTION_ID, B.CONDITION_QSTN_VERSION_NUM, B.CONDITION_ANSWER_ID, B.CONDITION_DISPLAY, B.QSTN_SAMPLE_SIZE, B.QSTN_RESPONSE_ORDER, B.MIN_DATE,B.MAX_DATE, L.INSTRUCTIONS_TEXT, B.ENABLE_COMMENTS, B.SURVEY_TYPE FROM HRQ_QUESTIONS_B B, HRQ_QUESTIONS_TL L WHERE B.BUSINESS_GROUP_ID = L.BUSINESS_GROUP_ID AND B.QUESTION_ID = L.QUESTION_ID AND B.QSTN_VERSION_NUM = L.QSTN_VERSION_NUM AND L.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.BUSINESS_GROUP_ID,

B.QUESTION_ID,

B.QSTN_VERSION_NUM,

L.QUESTION_TEXT,

B.CATEGORY_ID,

B.SUBSCRIBER_ID,

B.QUESTION_TYPE,

B.RESPONSE_TYPE_ID,

B.MIN_LENGTH,

B.MAX_LENGTH,

B.MIN_SELECTIONS,

B.MAX_SELECTIONS,

B.OWNER,

B.PRIVACY_FLAG,

B.UPDATE_ALLOWED,

B.ADHOC_FLAG,

B.RATING_MODEL_ID,

B.LATEST_VERSION,

B.VERSION_DESCRIPTION,

B.ATTACHMENT_ALLOWED,

B.STATUS,

B.QUESTION_CODE,

B.MODULE_ID,

B.OVERRIDE_DESC_FLAG,

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.MIN_THRESHOLD_SCORE,

B.MAX_THRESHOLD_SCORE,

B.MAX_POSSIBLE_SCORE,

B.CLASSIFICATION_CODE,

B.CANDIDATE_CODE,

B.ALL_LOCATIONS_FLAG,

B.ALL_ORGANIZATIONS_FLAG,

B.ALL_JOB_FAMILIES_FLAG,

B.ALL_JOB_FUNCTIONS_FLAG,

B.CONDITION_QUESTION_ID,

B.CONDITION_QSTN_VERSION_NUM,

B.CONDITION_ANSWER_ID,

B.CONDITION_DISPLAY, B.QSTN_SAMPLE_SIZE, B.QSTN_RESPONSE_ORDER,

B.MIN_DATE,B.MAX_DATE,

L.INSTRUCTIONS_TEXT,

B.ENABLE_COMMENTS,

B.SURVEY_TYPE

FROM

HRQ_QUESTIONS_B B,

HRQ_QUESTIONS_TL L

WHERE

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