ADO.NET Provider for Oracle Fusion Cloud Financials

Build 24.0.9175

SupplierRegistrationQuestionnaireResponsesquestionnaireResponseSectionsquestionnaireResponses

Stores the supplier’s answers to each question in a section, capturing all responses for thorough review.

Columns

Name Type Description
SupplierRegistrationQuestionnaireResponsesQuestnaireRespHeaderId [KEY] Long A unique identifier for the header of the questionnaire response. This ID links all related questionnaire responses within the system.
SupplierRegistrationQuestionnaireResponsesSupplierRegistrationKey [KEY] String A unique key that links the questionnaire responses to the supplier’s registration process. This ensures the responses are associated with the correct supplier.
QuestionnaireresponsesectionsQuestnaireRespSectionId [KEY] Long A unique identifier for the specific section in the questionnaire response. This ID links the response to a section within the questionnaire.
QuestnaireResponseId [KEY] Long A unique identifier for the response given to the specific question in the questionnaire. This allows tracking of the answer.
QuestnaireRespHeaderId Long ID linking the response to the questionnaire header. This allows the system to associate the section response to a larger questionnaire.
QuestnaireRespSectionId Long Unique identifier for the section within the questionnaire that the response belongs to. It helps organize and group related questions.
QuestnaireQuestionId Long Unique identifier for the question in the questionnaire. It helps track specific questions and their responses.
ParentQuestnaireQuestId Long ID of the parent question if the current question is part of a branching or dependent set of questions.
DisplayNumber String The order or number displayed for the question within the section. This number helps in organizing the sequence in which questions are presented.
QuestionId Long ID of the specific question within the questionnaire. It helps identify which question is being answered.
QuestionName String The name or identifier of the question being answered. This is typically the title or label of the question.
QuestionTypeCode String Abbreviation that identifies the type of question. Valid values include multiple choice and text input. Accepted values can be found in the lookup type PON_QUESTION_TYPE.
QuestionType String The type of the question. Values can include Multiple Choice or Text Entry. A list of accepted types is defined in the lookup type PON_QUESTION_TYPE.
ResponseTypeCode String Abbreviation that identifies the type of response expected for the question. Common types include Text, Number, and Date. Accepted values are defined in the lookup type PON_RESPONSE_TYPE.
ResponseType String The type of response expected for the question, such as Text, Number, Date. The full list of accepted response types can be found in the lookup type PON_RESPONSE_TYPE.
QuestionText String The actual text of the question that will be displayed to the responder. This is the content that the supplier will read and answer.
QuestionHint String A hint or additional guidance that may be displayed with the question to help responders understand how to answer.
DisplayPreferredRespFlag Bool Indicates if the preferred response (if any) should be displayed to the responder. If true, the preferred response will be shown. Default is false.
PreferredResponseText String The preferred response to the question, if defined. This text represents the recommended answer.
PreferredResponseDate Date The preferred response value for a question where the expected response type is a date.
PreferredResponseDatetime Datetime The preferred response value for a question where the expected response type is a datetime.
PreferredResponseNumber Decimal The preferred response value for a question where the expected response type is a number.
AttachmentAllowedCode String Abbreviation indicating whether attachments are allowed for the response. Accepted values include YES, NO, and CONDITIONAL. A list of valid values is defined in the lookup type PON_QUESTION_ATTACHMENT.
AttachmentAllowed String Indicates whether attachments are allowed with the response. Values include YES, NO, or CONDITIONAL.
ResponseRequiredFlag Bool Indicates whether a response is required for the question. If true, the response is mandatory. If false, the response is optional.
AllowRespCommentFlag Bool Indicates whether responders can provide additional comments for the question. If true, comments are allowed; if false, comments are not allowed.
ResponseComments String Comments provided by the responder when submitting their response.
QuestionDisplayedFlag Bool Indicates whether the question is displayed to the user. If true, the question will be shown; if false, it will be hidden.
BranchLevel Int Indicates the level of branching for this question, if applicable. A higher value indicates a deeper level of branching in the questionnaire.
ParentAccResponseId Long ID of the parent acceptable response, if this response is part of a branching question set.
QuestionPlainText String Plain-text version of the question text, displayed to the responder.
SupplierAttributeFlag Bool Indicates whether the question is mapped to a supplier profile attribute. If true, the question relates to an attribute in the supplier profile.
RegReadOnlyFlag Bool Indicates whether the question is read-only during the registration process. If true, the question cannot be modified by the responder.
CategoryCode String The category code associated with the question for classification purposes. Accepted values can be found in the lookup type PON_QUESTION_CATEGORY.
Category String The category associated with the question for classification purposes. A list of accepted categories can be found in the lookup type PON_QUESTION_CATEGORY.
Finder String A keyword or search term used to locate the question or related responses.
SupplierRegistrationKey String The unique key that links the question response to the supplier’s registration process.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175