1. Tables and Views for Procurement
  2. POQ_QUES_ACC_RESPONSES_B

POQ_QUES_ACC_RESPONSES_B

POQ_QUES_ACC_RESPONSES_B stores acceptable responses for a multiple choice question along with other details such as preferred response and display sequence. It also stores acceptable responses for multiple choice questions mapped to the supplier profile.

Details

  • Schema: FUSION

  • Object owner: POQ

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

POQ_QUES_ACC_RESPONSES_B_PK

ACC_RESPONSE_ID

Columns

Name Datatype Length Precision Not-null Comments
ACC_RESPONSE_ID NUMBER 18 Yes Internal identifier of the acceptable response
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.
QUESTION_ID NUMBER 18 Yes Internal identifier of the Question this acceptable response applies to
DISPLAY_SEQUENCE NUMBER 9 Yes Specifies the order in which the acceptable responses should be displayed to the responder on a Questionnaire for this specific question.
PREFERRED_RESPONSE_FLAG VARCHAR2 1 Indicates that this response value is the preferred response value for this question when evaluating responses.
ATTACHMENT_ALLOWED_CODE VARCHAR2 30 Yes Specifies whether the responder is allowed to attach any documents to their responses
MAPPED_TO_PREREQ_ACC_RESP_ID NUMBER 18 If this is an acceptable response to a checklist type of question mapped to a prerequisite question as denoted in MAPPED_TO_PREREQ_QUESTION_FLAG of POQ_QUESTIONS_B, this column identifies the corresponding acceptable response id of the prerequisite question.
ATTRIBUTE_ID NUMBER 18 Numeric ID used to lookup a supplier attribute value in another table.
ATTRIBUTE_CODE VARCHAR2 30 Code used to lookup a supplier attribute value in another table.
ATTRIBUTE_CODE2 VARCHAR2 30 Code used to lookup a supplier attribute value in another table.
CATEGORY_ID NUMBER 18 When the question is mapped to the supplier attribute Products and Services, specifies either a browse category id in POR_BROWSE_CATEGORIES_VL or an item category in EGP_CATEGORIES_VL
CATEGORY_NAME VARCHAR2 250 If a question is mapped to Products and Services, this column indicates the category name of browse category or item category. Category name is always stored in buyer's session language the first time a question is created.
PARENT_CATEGORY_ID NUMBER 18 When the question is mapped to the supplier attribute Products and Services, this column specifies immediate parent browse category of a given node (if there is a parent category).
PURCHASING_CAT_FLAG VARCHAR2 1 When the question is mapped to the supplier attribute Products and Services, Y indicates this is an item category in EGP_CATEGORIES_VL. N indicates this is a browse category in POR_BROWSE_CATEGORIES_VL
ORIGINAL_ACC_RESPONSE_ID NUMBER 18 For manually entered acceptable response rows, this column captures the original acc_response_id for propagate responses for a new question revision.
EXCLUDE_SCORING_FLAG VARCHAR2 1 Specifies whether this response results in exclusion of question from scoring
SCORE NUMBER Score that is automatically assigned to the question response if the user selects the corresponding acceptable value as the question response.
CRITICAL_RESPONSE_FLAG VARCHAR2 1 Specifies whether a response is critical for evaluation.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table Foreign Table Foreign Key Column
POQ_QUES_ACC_RESPONSES_B poq_questions_b QUESTION_ID
poq_resp_repository_values poq_ques_acc_responses_b ACC_RESPONSE_ID
poq_questnaire_acc_resps poq_ques_acc_responses_b ACC_RESPONSE_ID
poq_question_branches poq_ques_acc_responses_b ACC_RESPONSE_ID
poq_questnaire_resp_values poq_ques_acc_responses_b ACC_RESPONSE_ID

Indexes

Index Uniqueness Tablespace Columns
POQ_QUES_ACC_RESPONSES_B_N1 Non Unique Default QUESTION_ID, ATTRIBUTE_ID
POQ_QUES_ACC_RESPONSES_B_PK Unique Default ACC_RESPONSE_ID