1. Tables and Views for Procurement
  2. POQ_REPOS_SURVEY_RESPONSES

POQ_REPOS_SURVEY_RESPONSES

POQ_REPOS_SURVEY_RESPONSES is used to store the accepted responses of each Internal Responder from Questionnaire Response Headers and Questionnaire Responses tables after the acceptance of Questionnaire Response.

Details

  • Schema: FUSION

  • Object owner: POQ

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

POQ_REPOS_SURVEY_RESPONSES_PK

REPOS_SURVEY_RESPONSE_ID

Columns

Name Datatype Length Precision Not-null Comments
REPOS_SURVEY_RESPONSE_ID NUMBER 18 Yes System-generated unique identifier of the Survey Responses of Internal Responder.
QUESTION_ID NUMBER 18 Yes Identifier to the question in question library.
SUPPLIER_ID NUMBER 18 Yes Identifier of the supplier for which the question is answered.
SUPPLIER_SITE_ID NUMBER 18 Identifier of the site if the question is for a supplier site.
INTERNAL_RESPONDENT_ID NUMBER 18 Yes Person identifier of the internal responder.
RESPONSE_SUBMISSION_DATE TIMESTAMP Yes Date at which response to a question is submitted by responder.
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 the Internal Responder. Possible values are: QUESTNAIRE_RESPONSE.
DATA_SOURCE_ID NUMBER 18 Stores the identifier of document from the source system (such as Questionnaire Response Header Id).
LATEST_RESP_FLAG VARCHAR2 1 Yes Flag indicating whether the question's response is latest for a given Supplier, Supplier Site and Internal Responder.
ORIGINAL_QUESTION_ID NUMBER 18 Column to store the original question id for the question revision for which this is a response.
MERGE_REQUEST_ID NUMBER 18 Unique identifier that references MERGE_REQUEST_ID from POZ_SUPPLIER_MERGE_REQUESTS.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
QUESTION_RESP_SCORE NUMBER The response score calculated for the current record's 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.
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.

Indexes

Index Uniqueness Tablespace Columns
POQ_REPOS_SURVEY_RESPONSES_N1 Non Unique Default QUESTION_ID, SUPPLIER_ID, INTERNAL_RESPONDENT_ID, SUPPLIER_SITE_ID
POQ_REPOS_SURVEY_RESPONSES_PK Unique Default REPOS_SURVEY_RESPONSE_ID