1. Tables and Views for Procurement
  2. POQ_RESP_REPOS_INT

POQ_RESP_REPOS_INT

The POQ_RESP_REPOS_INT table contains question responses to be loaded into the POQ_RESPONSE_REPOSITORY table by the supplier qualification response repository API. These rows will be grouped by BATCH_ID.

Details

  • Schema: FUSION

  • Object owner: POQ

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

POQ_RESP_REPOS_INT_PK

RESP_REPOS_INTERFACE_ID

Columns

Name Datatype Length Precision Not-null Comments
RESP_REPOS_INTERFACE_ID NUMBER 18 Yes System generated unique identifier reflecting the order responses were loaded into the interface table.
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.
REQUIREMENT_ID NUMBER 18 Identifier for response requirements.
QUESTION_ID NUMBER 18 Yes Identifier of the question to which this response belongs. This references the question_id of the poq_questions_b table.
SUPPLIER_ID NUMBER 18 Yes Identifier of the supplier to whom this response belongs.
SUPPLIER_SITE_ID NUMBER 18 Identifier of the supplier site to which this response belongs.
DATA_SOURCE_TYPE VARCHAR2 30 Yes This column indicates the source system which captured the response from supplier. Source system could be response to sourcing document, response to qualification questionnaire or an update to supplier profile. Possible values are: QUESTNAIRE_RESPONSE, NEGOTIATION_RESPONSE, SUPPLIER_PROFILE, or SUPPLIER_REGISTRATION.
DATA_SOURCE_ID NUMBER 18 Yes Stores the identifier of document from the source system, such as Bid Number, Questionnaire Response Id, Profile Identifier driving profile change, Supplier Registration Identifier.
BATCH_ID NUMBER 18 Yes Identifies a set of related changes. Identifies all the records to be loaded by a single call to the Response Repository API.
PRC_BU_ID NUMBER 18 Yes Procurement business unit identifier for the response.
RESPONDER_ID NUMBER 18 Yes The identifier of the responder. If responder type is a supplier, the identifier of the contact person for a supplier or supplier site. If responder type is internal, the person identifier of the internal responder.
RESPONDER_TYPE VARCHAR2 20 Yes The type of the responder. Valid values are SUPPLIER or INTERNAL.
RESPONDER_COMMENTS VARCHAR2 1000 Comments submitted by the responder.
RESPONSE_SUBMISSION_DATE TIMESTAMP Yes Date response to a question is submitted by responder.
RESPONSE_ACCEPTED_BY NUMBER 18 Yes Identifier of the person who accepted the response.
RESPONSE_ACCEPTANCE_DATE TIMESTAMP Yes Date when the response to the question was accepted.
RESPONSE_ACCEPTANCE_NOTE VARCHAR2 1000 Note entered by acceptor at the time of acceptance.
PROCESS_STATUS VARCHAR2 30 Yes The status of the processing of this response. Either NEW or PENDING_CHANGE_MANAGEMENT.
CHANGE_REQUEST_ID NUMBER 18 If a change management request was submitted to supplier model for this response, the change request id for that request.
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_INT poq_questions_b QUESTION_ID
poq_resp_repos_value_int poq_resp_repos_int RESP_REPOS_INTERFACE_ID

Indexes

Index Uniqueness Tablespace Columns
POQ_RESP_REPOS_INT_N1 Non Unique Default BATCH_ID
POQ_RESP_REPOS_INT_N2 Non Unique Default QUESTION_ID
POQ_RESP_REPOS_INT_PK Unique Default RESP_REPOS_INTERFACE_ID