20Questionnaire

Tables

HRQ_JOB_FAMILIES

Table contaning QUESTION_ID/ QSTNR_TEMPLATE_IDor QUESTIONNAIRE_ID as REFERENCE_ID and is used to classify each of them based on the Job Family.

Details

  • Schema: FUSION

  • Object owner: HRQ

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HRQ_JOB_FAMILIES_PK

HRQ_JOB_FAMILY_ID

Columns

Name Datatype Length Precision Not Null Comments Flexfield Mapping
HRQ_JOB_FAMILY_ID NUMBER 18 Yes Unique identifier for a job family. System generated id. This attribute combined with the version number and business group id forms the primary key.
BUSINESS_GROUP_ID NUMBER 18 Yes Identifier of Enterprise, used for multi-tenancy partitioning. Foreign key to HR_ORGANIZATION_UNITS.
REFERENCE_TYPE VARCHAR2 240 Yes Question or Questionnaire Template or Questionnaire based on the context.
REFERENCE_ID NUMBER 18 Yes Question ID or Questionnaire Template ID or Questionnaire, based on the context.
REFERENCE_VERSION_NUM NUMBER 18 Yes Version Number of the Question or Questionnaire Template or Questionnaire, based on the context.
JOB_FAMILY_ID NUMBER 18 Yes Job Family table's primary key
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index Uniqueness Tablespace Column
HRQ_JOB_FAMILIES_U1 Unique Default HRQ_JOB_FAMILY_ID

HRQ_JOB_FUNCTIONS

Table contaning QUESTION_ID/ QSTNR_TEMPLATE_IDor QUESTIONNAIRE_ID as REFERENCE_ID and is used to classify each of them based on the Job Function.

Details

  • Schema: FUSION

  • Object owner: HRQ

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HRQ_JOB_FUNCTIONS_PK

HRQ_JOB_FUNCTION_ID

Columns

Name Datatype Length Precision Not Null Comments Flexfield Mapping
HRQ_JOB_FUNCTION_ID NUMBER 18 Yes Unique identifier for a job function. System generated id. This attribute combined with the version number and business group id forms the primary key.
BUSINESS_GROUP_ID NUMBER 18 Yes Identifier of Enterprise, used for multi-tenancy partitioning. Foreign key to HR_ORGANIZATION_UNITS.
REFERENCE_TYPE VARCHAR2 240 Yes Question or Questionnaire Template or Questionnaire based on the context.
REFERENCE_ID NUMBER 18 Yes Question ID or Questionnaire Template ID or Questionnaire, based on the context.
REFERENCE_VERSION_NUM NUMBER 18 Yes Version Number of the Question or Questionnaire Template or Questionnaire, based on the context.
JOB_FUNCTION_CODE VARCHAR2 30 Yes Job Function tables primary key.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index Uniqueness Tablespace Column
HRQ_JOB_FUNCTIONS_U1 Unique Default HRQ_JOB_FUNCTION_ID

HRQ_LOCATIONS

Table contaning QUESTION_ID/ QSTNR_TEMPLATE_IDor QUESTIONNAIRE_ID as REFERENCE_ID and is used to classify each of them based on the geography location.

Details

  • Schema: FUSION

  • Object owner: HRQ

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HRQ_LOCATIONS_PK

HRQ_LOCATION_ID

Columns

Name Datatype Length Precision Not Null Comments Flexfield Mapping
HRQ_LOCATION_ID NUMBER 18 Yes Unique identifier for a location. System generated id. This attribute combined with the version number and business group id forms the primary key.
BUSINESS_GROUP_ID NUMBER 18 Yes Identifier of Enterprise, used for multi-tenancy partitioning. Foreign key to HR_ORGANIZATION_UNITS.
REFERENCE_TYPE VARCHAR2 240 Yes Question or Questionnaire Template or Questionnaire based on the context.
REFERENCE_ID NUMBER 18 Yes Question ID or Questionnaire Template ID or Questionnaire, based on the context.
REFERENCE_VERSION_NUM NUMBER 18 Yes Version Number of the Question or Questionnaire Template or Questionnaire, based on the context.
LOCATION_ID NUMBER 18 Yes Identifies the location id.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index Uniqueness Tablespace Column
HRQ_LOCATIONS_U1 Unique Default HRQ_LOCATION_ID

HRQ_ORGANIZATIONS

Table contaning QUESTION_ID/ QSTNR_TEMPLATE_IDor QUESTIONNAIRE_ID as REFERENCE_ID and is used to classify each of them based on the organization.

Details

  • Schema: FUSION

  • Object owner: HRQ

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HRQ_ORGANIZATIONS_PK

HRQ_ORGANIZATION_ID

Columns

Name Datatype Length Precision Not Null Comments Flexfield Mapping
HRQ_ORGANIZATION_ID NUMBER 18 Yes Unique identifier for a organization. System generated id. This attribute combined with the version number and business group id forms the primary key.
BUSINESS_GROUP_ID NUMBER 18 Yes Identifier of Enterprise, used for multi-tenancy partitioning. Foreign key to HR_ORGANIZATION_UNITS.
REFERENCE_TYPE VARCHAR2 240 Yes Question or Questionnaire Template or Questionnaire based on the context.
REFERENCE_ID NUMBER 18 Yes Question ID or Questionnaire Template ID or Questionnaire, based on the context.
REFERENCE_VERSION_NUM NUMBER 18 Yes Version Number of the Question or Questionnaire Template or Questionnaire, based on the context.
ORGANIZATION_ID NUMBER 18 Yes Organization table's Primary Key
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index Uniqueness Tablespace Column
HRQ_ORGANIZATIONS_U1 Unique Default HRQ_ORGANIZATION_ID

Views

HRQ_ALL_QSTN_ANSWERS_V

Details

  • Schema: FUSION

  • Object owner: HRQ

  • Object type: VIEW

Columns

Name

QA_QSTN_ANSWER_ID

QA_BUSINESS_GROUP_ID

QUESTION_ID

RATING_LEVEL_ID

SEQ_NUM

QAT_QSTN_ANSWER_ID

QAT_BUSINESS_GROUP_ID

LANGUAGE

SHORT_TEXT

LONG_TEXT

Query

SQL_Statement

select QA.QSTN_ANSWER_ID AS QA_QSTN_ANSWER_ID,

QA.BUSINESS_GROUP_ID AS QA_BUSINESS_GROUP_ID,

QA.QUESTION_ID,

QA.RATING_LEVEL_ID,

QA.SEQ_NUM,

QAT.QSTN_ANSWER_ID AS QAT_QSTN_ANSWER_ID,

QAT.BUSINESS_GROUP_ID AS QAT_BUSINESS_GROUP_ID,

QAT.LANGUAGE,

QAT.SHORT_TEXT,

QAT.LONG_TEXT

from HRQ_QSTN_ANSWERS_B QA,

HRQ_QSTN_ANSWERS_TL QAT

WHERE QA.QSTN_ANSWER_ID = QAT.QSTN_ANSWER_ID

AND QA.BUSINESS_GROUP_ID = QAT.BUSINESS_GROUP_ID

HRQ_ALL_QSTN_RESPONSES_V

Details

  • Schema: FUSION

  • Object owner: HRQ

  • Object type: VIEW

Columns

Name

QSTNR_RESPONSE_ID

QSTNR_QUESTION_ID

BUSINESS_GROUP_ID

QSTN_RESPONSE_ID

ANSWER_TYPE

ANSWER_TEXT

ANSWER_CLOB

ANSWER_ID

Query

SQL_Statement

SELECT QSTNR_RESPONSE_ID,

QSTNR_QUESTION_ID,

BUSINESS_GROUP_ID,

QSTN_RESPONSE_ID,

nvl2(ANSWER_ID || ANSWER_TEXT, nvl2(ANSWER_ID, 'RATING','ANSWER'), NULL) AS ANSWER_TYPE,

ANSWER_TEXT,

ANSWER_CLOB,

ANSWER_ID from

(SELECT BUSINESS_GROUP_ID,

QSTNR_RESPONSE_ID,

QSTN_RESPONSE_ID,

QSTNR_QUESTION_ID,

ANSWER_TEXT,

ANSWER_CLOB,

regexp_substr (answer_list, '[^,;]+', 1, rn) ANSWER_ID

FROM

(

SELECT BUSINESS_GROUP_ID,

QSTNR_RESPONSE_ID,

QSTN_RESPONSE_ID,

QSTNR_QUESTION_ID,

ANSWER_TEXT,

ANSWER_LIST,

ANSWER_CLOB

FROM HRQ_QSTN_RESPONSES

),

(SELECT rownum rn

FROM

(SELECT MAX (LENGTH (regexp_replace (answer_list, '[^,]+'))) + 1 max_value

FROM

(SELECT answer_list FROM HRQ_QSTN_RESPONSES

)

)

CONNECT BY level <= max_value

)

WHERE regexp_substr (NVL(answer_list,'dummy'), '[^,]+', 1, rn) IS NOT NULL

)

HRQ_CATEGORIES_VL

Details

  • Schema: FUSION

  • Object owner: HRQ

  • Object type: VIEW

Columns

Name

BUSINESS_GROUP_ID

CATEGORY_ID

NAME

PARENT_CATEGORY_ID

SUBSCRIBER_ID

CONTAIN_QUESTIONS

CONTAIN_QUESTIONNAIRES

MODULE_ID

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.BUSINESS_GROUP_ID, B.CATEGORY_ID, L.NAME, B.PARENT_CATEGORY_ID, B.SUBSCRIBER_ID, B.CONTAIN_QUESTIONS, B.CONTAIN_QUESTIONNAIRES, 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

FROM HRQ_CATEGORIES_B B, HRQ_CATEGORIES_TL L

WHERE B.BUSINESS_GROUP_ID = L.BUSINESS_GROUP_ID AND B.CATEGORY_ID = L.CATEGORY_ID

AND L.LANGUAGE = USERENV('LANG')

HRQ_QSTNR_DIMENSIONS_VL

Details

  • Schema: FUSION

  • Object owner: HRQ

  • Object type: VIEW

Columns

Name

BUSINESS_GROUP_ID

QSTNR_DIMENSION_ID

NAME

QUESTIONNAIRE_ID

QSTNR_VERSION_NUM

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.BUSINESS_GROUP_ID, B.QSTNR_DIMENSION_ID, L.NAME, B.QUESTIONNAIRE_ID, B.QSTNR_VERSION_NUM, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN

FROM HRQ_QSTNR_DIMENSIONS_B B, HRQ_QSTNR_DIMENSIONS_TL L

WHERE B.BUSINESS_GROUP_ID = L.BUSINESS_GROUP_ID AND B.QSTNR_DIMENSION_ID = L.QSTNR_DIMENSION_ID

AND L.LANGUAGE = USERENV('LANG')

HRQ_QSTNR_PCPT_RESPONSES_V

Details

  • Schema: FUSION

  • Object owner: HRQ

  • Object type: VIEW

Columns

Name

QSTNR_RESPONSE_ID

QSTNR_QUESTION_ID

QSTN_RESPONSE_ID

ANSWER_TYPE

ANSWER_CLOB

ANSWER_ID

QUESTIONNAIRE_CODE

QUESTION_CODE

ATTEMPT_NUM

STATUS

PARTICIPANT_TYPE

PARTICIPANT_ID

SUBSCRIBER_ID

SUBJECT_CODE

SUBJECT_ID

LONG_TEXT

QUESTION_ID

QSTN_ANSWER_ID

SEQ_NUM

CORRECT_FLAG

ANSWER_CODE

Query

SQL_Statement

SELECT

aqrv.QSTNR_RESPONSE_ID,

aqrv.QSTNR_QUESTION_ID,

aqrv.QSTN_RESPONSE_ID,

aqrv.ANSWER_TYPE,

aqrv.ANSWER_CLOB,

aqrv.ANSWER_ID,

qsnr.QUESTIONNAIRE_CODE,

qsn.QUESTION_CODE,

qrsp.ATTEMPT_NUM,

qrsp.STATUS,

qprt.PARTICIPANT_TYPE,

qprt.PARTICIPANT_ID,

qprt.SUBSCRIBER_ID,

qprt.SUBJECT_CODE,

qprt.SUBJECT_ID,

qans.LONG_TEXT,

qans.QUESTION_ID,

qans.QSTN_ANSWER_ID,

qans.SEQ_NUM,

qans.CORRECT_FLAG,

qans.ANSWER_CODE

FROM

HRQ_ALL_QSTN_RESPONSES_V aqrv,

HRQ_QUESTIONNAIRES_B qsnr,

HRQ_QSTNR_SECTIONS_B qsec,

HRQ_QSTNR_QUESTIONS qqs,

HRQ_QUESTIONS_B qsn,

HRQ_QSTN_ANSWERS_VL qans,

HRQ_QSTNR_PARTICIPANTS qprt,

HRQ_QSTNR_RESPONSES qrsp

WHERE

aqrv.QSTNR_RESPONSE_ID = qrsp.QSTNR_RESPONSE_ID

AND aqrv.QSTNR_QUESTION_ID = qqs.QSTNR_QUESTION_ID

AND qqs.QUESTION_ID = qsn.QUESTION_ID

AND qqs.QSTN_VERSION_NUM = qsn.QSTN_VERSION_NUM

AND qqs.BUSINESS_GROUP_ID = qsn.BUSINESS_GROUP_ID

AND qqs.QSTNR_SECTION_ID = qsec.QSTNR_SECTION_ID

AND qqs.BUSINESS_GROUP_ID = qsec.BUSINESS_GROUP_ID

AND qsec.QUESTIONNAIRE_ID = qsnr.QUESTIONNAIRE_ID

AND qsec.QSTNR_VERSION_NUM = qsnr.QSTNR_VERSION_NUM

AND qsec.BUSINESS_GROUP_ID = qsnr.BUSINESS_GROUP_ID

AND qsnr.QUESTIONNAIRE_ID = qprt.QUESTIONNAIRE_ID

AND qsnr.BUSINESS_GROUP_ID = qprt.BUSINESS_GROUP_ID

AND aqrv.ANSWER_ID = qans.QSTN_ANSWER_ID(+)

AND aqrv.BUSINESS_GROUP_ID = qans.BUSINESS_GROUP_ID(+)

AND qprt.QSTNR_PARTICIPANT_ID = qrsp.QSTNR_PARTICIPANT_ID

AND qprt.BUSINESS_GROUP_ID = qrsp.BUSINESS_GROUP_ID

AND qrsp.STATUS = 'S'

AND qrsp.ATTEMPT_NUM =

(SELECT MAX(x.ATTEMPT_NUM)

FROM HRQ_QSTNR_RESPONSES x

WHERE x.QSTNR_PARTICIPANT_ID = qprt.QSTNR_PARTICIPANT_ID

)

HRQ_QSTNR_SECTIONS_VL

Details

  • Schema: FUSION

  • Object owner: HRQ

  • Object type: VIEW

Columns

Name

QSTNR_SECTION_ID

BUSINESS_GROUP_ID

SECTION_SEQ_NUM

NEW_PAGE

NAME

QUESTIONNAIRE_ID

QSTNR_VERSION_NUM

DESCRIPTION

INTRO_TEXT

QUESTION_ORDER

RESPONSE_ORDER

MANDATORY

ALLOW_ADHOC

MODULE_ID

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.QSTNR_SECTION_ID, B.BUSINESS_GROUP_ID, B.SECTION_SEQ_NUM, NEW_PAGE, L.NAME, B.QUESTIONNAIRE_ID, B.QSTNR_VERSION_NUM, L.DESCRIPTION, L.INTRO_TEXT, B.QUESTION_ORDER, B.RESPONSE_ORDER, B.MANDATORY, B.ALLOW_ADHOC, 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

FROM HRQ_QSTNR_SECTIONS_B B, HRQ_QSTNR_SECTIONS_TL L

WHERE B.BUSINESS_GROUP_ID = L.BUSINESS_GROUP_ID AND B.QSTNR_SECTION_ID = L.QSTNR_SECTION_ID

AND L.LANGUAGE = USERENV('LANG')

HRQ_QSTNR_TEMPLATES_VL

Details

  • Schema: FUSION

  • Object owner: HRQ

  • Object type: VIEW

Columns

Name

BUSINESS_GROUP_ID

QSTNR_TEMPLATE_ID

NAME

QUESTIONNAIRE_ID

ALLOW_FORMAT_CHG

ALLOW_INTRO_CHG

ALLOW_SECTION_CHG

ALLOW_QSTN_ORDER_CHG

ALLOW_RESP_ORDER_CHG

BASIC_SETUP_FLAG

RANDOM_QSTNS

RANDOM_ANSWERS

MODULE_ID

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

B.BUSINESS_GROUP_ID,

B.QSTNR_TEMPLATE_ID,

L.NAME,

B.QUESTIONNAIRE_ID,

B.ALLOW_FORMAT_CHG,

B.ALLOW_INTRO_CHG,

B.ALLOW_SECTION_CHG,

B.ALLOW_QSTN_ORDER_CHG,

B.ALLOW_RESP_ORDER_CHG,

B.BASIC_SETUP_FLAG,

B.RANDOM_QSTNS,

B.RANDOM_ANSWERS,

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

FROM

HRQ_QSTNR_TEMPLATES_B B,

HRQ_QSTNR_TEMPLATES_TL L

WHERE

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

HRQ_QSTN_ANSWERS_VL

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

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')

HRQ_QUESTIONNAIRES_VL

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

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

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')

HRQ_QUESTIONS_VL

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

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

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')

HRQ_RESPONSE_TYPES_VL

Details

  • Schema: FUSION

  • Object owner: HRQ

  • Object type: VIEW

Columns

Name

BUSINESS_GROUP_ID

RESPONSE_TYPE_ID

RESPONSE_TYPE_CODE

QUESTION_TYPE

NAME

USE_AS_DEFAULT

VIEW_ID

NUM_ROWS

QSTN_WIDTH_PCT

MODULE_ID

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.BUSINESS_GROUP_ID, B.RESPONSE_TYPE_ID, B.RESPONSE_TYPE_CODE, B.QUESTION_TYPE, L.NAME, B.USE_AS_DEFAULT, B.VIEW_ID, B.NUM_ROWS, B.QSTN_WIDTH_PCT, 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

FROM HRQ_RESPONSE_TYPES_B B, HRQ_RESPONSE_TYPES_TL L

WHERE B.BUSINESS_GROUP_ID = L.BUSINESS_GROUP_ID AND B.RESPONSE_TYPE_ID = L.RESPONSE_TYPE_ID

AND L.LANGUAGE = USERENV('LANG')

HRQ_SUBSCRIBERS_VL

Details

  • Schema: FUSION

  • Object owner: HRQ

  • Object type: VIEW

Columns

Name

SUBSCRIBER_ID

BUSINESS_GROUP_ID

SUBSCRIBER_CODE

NAME

INCLUDE_NA_OPT

INCLUDE_NA_TEXT

INTERFACE_CLASS

DEFAULT_QUESTIONNAIRE_ID

DEFAULT_RATING_MODEL_ID

MODULE_ID

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

B.SUBSCRIBER_ID,

B.BUSINESS_GROUP_ID,

B.SUBSCRIBER_CODE,

L.NAME,

B.INCLUDE_NA_OPT,

L.INCLUDE_NA_TEXT,

B.INTERFACE_CLASS,

B.DEFAULT_QUESTIONNAIRE_ID,

B.DEFAULT_RATING_MODEL_ID,

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

FROM

HRQ_SUBSCRIBERS_B B,

HRQ_SUBSCRIBERS_TL L

WHERE

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

HRQ_SUB_QUESTIONS_VL

Details

  • Schema: FUSION

  • Object owner: HRQ

  • Object type: VIEW

Columns

Name

BUSINESS_GROUP_ID

SUB_QUESTION_ID

QSTN_VERSION_NUM

QUESTION_ID

TEXT

CORRECT_ANSWER_ID

CORRECT_RTG_LVL_ID

MODULE_ID

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.BUSINESS_GROUP_ID, B.SUB_QUESTION_ID, B.QSTN_VERSION_NUM, B.QUESTION_ID, L.TEXT, B.CORRECT_ANSWER_ID, B.CORRECT_RTG_LVL_ID, 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

FROM HRQ_SUB_QUESTIONS_B B, HRQ_SUB_QUESTIONS_TL L

WHERE B.BUSINESS_GROUP_ID = L.BUSINESS_GROUP_ID AND B.SUB_QUESTION_ID = L.SUB_QUESTION_ID

AND L.LANGUAGE = USERENV('LANG')