1. Tables and Views for Procurement
  2. POQ_RESPONSE_REPOSITORY

POQ_RESPONSE_REPOSITORY

POQ_RESPONSE_REPOSITORY stores responses to questions from the question library. When a new response is received to a question for a given supplier, an entry is created in this table with response details such as response submission date, response acceptance date. The response value to a question is stored in POQ_RESP_REPOSITORY_VALUES. POQ_RESPONSE_REPOSITORY table can also be updated due to changes in the supplier profile or a response from a supplier to a sourcing document. For a site level question, the response is stored in a context of a supplier site.

Details

  • Schema: FUSION

  • Object owner: POQ

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

POQ_RESPONSE_REPOSITORY_PK

RESPONSE_REPOSITORY_ID

Columns

Name Datatype Length Precision Not-null Comments
RESPONSE_REPOSITORY_ID NUMBER 18 Yes Identifier to the question 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.
BATCH_ID NUMBER 18 If this response was loaded from the Repository Interface tables, the batch id from the response repository interface row.
QUESTION_ID NUMBER 18 Yes Identifier to the question in question library.
SUPPLIER_ID NUMBER 18 Yes Identifier of the supplier responding to a question.
SUPPLIER_SITE_ID NUMBER 18 Identifier of the supplier site.
RESPONSE_STATUS VARCHAR2 30 Yes Status of the response to a question.
FIRST_SUBMISSION_DATE TIMESTAMP Yes First time the response got submitted by responder.
RESPONSE_SUBMISSION_DATE TIMESTAMP Yes Date response to a question is submitted by responder.
RESPONSE_ARCHIVE_DATE TIMESTAMP Date when this response got archived because a new resposne got entered in the repository.
RESPONSE_COMMENTS VARCHAR2 1000 The text of a manually entered response comments value.
ACCEPTANCE_DATE TIMESTAMP Date when the response to the question was accepted.
ACCEPTANCE_NOTE VARCHAR2 1000 Note entered by acceptor at the time of acceptance.
ACCEPTED_BY NUMBER 18 Person who accepted the qualification response.
DATA_SOURCE_TYPE VARCHAR2 30 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 Stores the identifier of document from the source system (such as Bid Number, Questionnaire Response Id, Profile Identifier driving profile change, Supplier Registration Identifier).
RESPONDER_TYPE VARCHAR2 30 Yes Indicates whether the response responder is a supplier or an internal user.
INTERNAL_RESPONDENT_ID NUMBER 18 Person identifier of the internal responder.
SUPPLIER_CONTACT_PARTY_ID NUMBER 18 Identifier of the contact person for a supplier or supplier site.
ORIGINAL_QUESTION_ID NUMBER 18 Yes Column to store the original question id for the question revision for which this is a response.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
MERGE_REQUEST_ID NUMBER 18 Unique identifier that references merge_request_id from POZ_SUPPLIER_MERGE_REQUESTS.
SURROG_RESPONSE_FLAG VARCHAR2 1 Flag to indicate if a response is a surrogate response entered by qualification manager on behalf of supplier or internal responder.
SURROG_ENTRY_DATE TIMESTAMP This column is used for the surrogate response. Surrogate entry date is the date on which qualification manager submitted the response in the system. The date will be left empty for the non-surrogate response.
SURROG_ENTERED_BY NUMBER 18 This column is used for the surrogate response. It captures party id of the person entering a response on behalf of a supplier or an internal responder.
AGGREGATE_RESPONSE_FLAG VARCHAR2 1 Flag indicating whether the record is of aggregate type.
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_RESPONSE_REPOSITORY poq_questions_b QUESTION_ID
poq_resp_repository_values poq_response_repository RESPONSE_REPOSITORY_ID
poq_resp_repos_bus_class poq_response_repository RESPONSE_REPOSITORY_ID
poq_qual_responses poq_response_repository RESPONSE_REPOSITORY_ID

Indexes

Index Uniqueness Tablespace Columns
POQ_RESPONSE_REPOSITORY_N1 Non Unique Default QUESTION_ID, SUPPLIER_ID, RESPONSE_STATUS, SUPPLIER_SITE_ID
POQ_RESPONSE_REPOSITORY_N2 Non Unique Default ORIGINAL_QUESTION_ID
POQ_RESPONSE_REPOSITORY_N3 Non Unique Default DATA_SOURCE_ID, DATA_SOURCE_TYPE
POQ_RESPONSE_REPOSITORY_N4 Non Unique Default REQUEST_ID, MERGE_REQUEST_ID
POQ_RESPONSE_REPOSITORY_PK Unique FUSION_TS_TX_DATA RESPONSE_REPOSITORY_ID
POQ_RESPONSE_REPOSITORY_U1 Unique Default SUPPLIER_ID, SUPPLIER_SITE_ID, QUESTION_ID, FIRST_SUBMISSION_DATE