1. Tables and Views for Procurement
  2. POQ_QUESTNAIRE_RESP_HEADERS

POQ_QUESTNAIRE_RESP_HEADERS

POQ_QUESTNAIRE_RESP_HEADERS stores header level information, such as questionnaire response status, supplier and supplier contact information, questionnaire submission date. Supplier qualification creates a record in this table for every questionnaire sent at the time of initiative launch.

Details

  • Schema: FUSION

  • Object owner: POQ

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

POQ_QUESTNAIRE_RESP_HEADERS_PK

QUESTNAIRE_RESP_HEADER_ID

Columns

Name Datatype Length Precision Not-null Comments
QUESTNAIRE_RESP_HEADER_ID NUMBER 18 Yes Internal system identifier for a questionnaire 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.
CR_OUTCOME_CODE VARCHAR2 30 This column contains the outcome of the change request that was created for thie response header.
CHANGE_REQUEST_ID NUMBER 18 Indicates the unique identifier of the supplier profile change request that was created for this response, if any.
QUESTNAIRE_ID NUMBER 18 Yes Indetifier of the questionnaire.
SUPPLIER_ID NUMBER 18 Yes Identifier of the Supplier who is being responded.
SUPPLIER_SITE_ID NUMBER 18 Identifier of the Supplier site.
PRC_BU_ID NUMBER 18 Yes Procurement business unit identifier for questionnaire response.
INITIATIVE_ID NUMBER 18 Unique identifier for initiative.
SUPPLIER_REG_ID NUMBER 18 Unique identifier for supplier registration.
RESPONSE_STATUS VARCHAR2 30 Yes Status of the response to questionnaire. The possible value are NOT_STARTED, DRAFT, SUBMITTED, REJECTED, ACCEPTED, RESUBMISSION_REQD, PENDING_CHANGE_MGMT, and CANCELED.
SUPPLIER_CONTACT_PARTY_ID NUMBER 18 Identifier of the contact person for a supplier or supplier site.
INTERNAL_RESPONDENT_ID NUMBER 18 Person identifier of the internal responder.
INITIATIVE_SUPP_CONTACT_ID NUMBER 18 Supplier contact identifier specified on the initiative for a questionnaire to be sent to supplier or supplier site.
SUBMISSION_DATE TIMESTAMP Date response to questionnaire is submitted.
SUBMITTED_BY NUMBER 18 Person who submitted the response to questionnaire.
SURROG_RESPONSE_FLAG VARCHAR2 1 Flag to indicate if a response is a surrogate resposne 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 resposne 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.
ACCEPTANCE_DATE TIMESTAMP Date on which response to questionnaire is accepted.
ACCEPTED_BY NUMBER 18 Person who accepted the response to questionnaire.
ACCEPTANCE_NOTE VARCHAR2 1000 Note entered by acceptor at the time of acceptance.
CANCELED_DATE TIMESTAMP Indicates the date of cancelation of response header
CANCELED_BY NUMBER 18 The id of the user who canceled the response. The response could be canceled directly or an action on a related entity led to the cancelation of the entity.
CANCELED_REASON_CODE VARCHAR2 30 The reason for cancelation of the response. A system populated reason if this entry was canceled due to action on a related entity.
CANCELED_REASON_USER_TEXT VARCHAR2 1000 User input reason when the questionnaire is cancelled manually.
RETURNED_BY NUMBER 18 Identifier of the person who returned the response to the responder.
RETURNED_DATE TIMESTAMP Date on which the response was returned to the responder.
RETURN_MESSAGE_CONTENT CLOB The message content sent to the responder when the response was returned.
REQUEST_ERROR_REASON VARCHAR2 4000 This column contains the reasons why the questionnaire response was rejected or could not be processed.
RECENT_NOTIFICATION_FLAG VARCHAR2 1 An internal flag to indicate that the supplier contact or internal responder for this response has been updated and a respond to questionnaire notification needs to be sent to this new contact.
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 POZ_SUPPLIER_MERGE_REQUESTS.Merge_Request_id.
CLOSE_DATE TIMESTAMP Date on which the survey is closed for responding.
CLOSED_BY NUMBER 18 Person who close the survey for responding.
ACCEPTANCE_PROCESSED_STAGE VARCHAR2 30 Save point stage when acceptance is in progress.
ACCEPTANCE_RECOVERED_CODE VARCHAR2 1 To indicate if acceptance recovery has started and another process doesn’t pick the record for processing.
RECOVERED_BY NUMBER 18 The id of the user who recovered the questionnaire.
RECOVERED_DATE TIMESTAMP Indicates when the questionnaire was recovered.
ACCEPTANCE_INSTANCE_ID NUMBER 18 BPEL instance id for acceptance process.
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_QUESTNAIRE_RESP_HEADERS poq_questnaires_b QUESTNAIRE_RESP_HEADER_ID
POQ_QUESTNAIRE_RESP_HEADERS poq_initiatives INITIATIVE_ID
poq_questnaire_resp_sections poq_questnaire_resp_headers QUESTNAIRE_RESP_HEADER_ID
poq_questnaire_responses poq_questnaire_resp_headers QUESTNAIRE_RESP_HEADER_ID

Indexes

Index Uniqueness Tablespace Columns Status
POQ_QUESTNAIRE_RESP_HDRS_N1 Non Unique Default RESPONSE_STATUS
POQ_QUESTNAIRE_RESP_HDRS_N2 Non Unique Default SUPPLIER_ID
POQ_QUESTNAIRE_RESP_HDRS_N3 Non Unique Default INITIATIVE_ID, SUPPLIER_ID, RESPONSE_STATUS
POQ_QUESTNAIRE_RESP_HDRS_N4 Non Unique Default QUESTNAIRE_ID, SUPPLIER_ID, SUPPLIER_SITE_ID, INTERNAL_RESPONDENT_ID
POQ_QUESTNAIRE_RESP_HDRS_U2 Unique Default SUPPLIER_REG_ID
POQ_QUESTNAIRE_RESP_HEADERS_PK Unique FUSION_TS_TX_DATA QUESTNAIRE_RESP_HEADER_ID
POQ_QUESTNAIRE_RESP_HEADERS_U1 Unique Default QUESTNAIRE_ID, SUPPLIER_ID, SUPPLIER_SITE_ID Obsolete