1. Tables and Views for Procurement
  2. POQ_RESP_REPOS_VALUE_INT

POQ_RESP_REPOS_VALUE_INT

POQ_RESP_REPOS_VALUE_INT stores response values for its parent row in POQ_RESP_REPOS_INT table. For a POQ_RESP_REPOS_INT row which is an input text question, there will always be one child row in this table. For a POQ_RESP_REPOS_INT row that is a single-select multiple-choice question, there will either 0 or 1 child row in this table. For a POQ_RESP_REPOS_INT row for a multiple-select multiple-choice question, there will be 0 or more rows in this table. Note that for multiple-choice questions with a null value, there will be no child value row in this table.

Details

  • Schema: FUSION

  • Object owner: POQ

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

POQ_RESP_REPOS_VALUE_INT_PK

RESP_REPOS_VAL_INTERFACE_ID

Columns

Name Datatype Length Precision Not-null Comments
RESP_REPOS_VAL_INTERFACE_ID NUMBER 18 Yes System generated unique identifier.
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.
RESP_REPOS_INTERFACE_ID NUMBER 18 Yes Identifier of the response repository interface row.
RESPONSE_VALUE_TXT VARCHAR2 4000 Response value for an input text question with a response type of single or multi line text.
RESPONSE_VALUE_DATE DATE Response value for an input text question with a response type of date.
RESPONSE_VALUE_DATETIME TIMESTAMP Response value for an input text question with a response type of datetime.
RESPONSE_VALUE_NUM NUMBER Response value for an input text question with a response type of number.
ACC_RESPONSE_ID NUMBER 18 Unique identifier for question acceptable response.
ACC_ATTR_ID NUMBER 18 Numeric id used to lookup a supplier attribute value in another table for a multiple selection or single selection question that is mapped to a profile attribute.
ACC_ATTR_CODE VARCHAR2 30 Code used to lookup a supplier attribute value in another table for a multiple selection or single selection question that is mapped to a profile attribute.
ACC_ATTR_CODE2 VARCHAR2 30 Code used to lookup a supplier attribute value in another table for a multiple selection or single selection question that is mapped to a profile attribute.
ACC_CATEGORY_ID NUMBER 18 The identifier of a products and services category response value in the question acceptable response table.
ATTACH_FROM_ENTITY_NAME VARCHAR2 40 The UCM entity name for attachment files associated with this response value.
ATTACH_FROM_PK1 NUMBER 18 The UCM entity name for attachment files associated with this reponse value.
ATTACH_FROM_PK2 NUMBER 18 The UCM PK2 value for attachment files associated with this response value.
ATTACH_FROM_PK3 NUMBER 18 The UCM PK3 value for attachment files associated with this response value.
ATTACH_FROM_PK4 NUMBER 18 The UCM PK4 value for attachment files associated with this response value.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP 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.

Foreign Keys

Table Foreign Table Foreign Key Column
POQ_RESP_REPOS_VALUE_INT poq_resp_repos_int RESP_REPOS_INTERFACE_ID

Indexes

Index Uniqueness Tablespace Columns
POQ_RESP_REPOS_VALUE_INT_N1 Non Unique Default RESP_REPOS_INTERFACE_ID
POQ_RESP_REPOS_VALUE_INT_PK Unique Default RESP_REPOS_VAL_INTERFACE_ID