QuestionnaireResponsesquestionnaireResponseSectionsquestionnaireResponseDetails
Captures individual answers or notes for each question in a questionnaire section, reflecting the respondent’s input.
Columns
| Name | Type | Description |
| QuestionnaireResponsesQuestionnaireRespHeaderId [KEY] | Long | The unique identifier for the questionnaire response header associated with the detailed section data, linking the section details to a specific questionnaire response. Example: 1001 for Questionnaire Response Header 1001. |
| QuestionnaireresponsesectionsQuestionnaireRespSectionId [KEY] | Long | The unique identifier for the questionnaire response section, linking the section details to a specific section in the questionnaire response. Example: 2001 for Section ID 2001. |
| QuestionnaireResponseId [KEY] | Long | The unique identifier for the questionnaire response, linking the section details to the overall questionnaire response. Example: 3001 for Questionnaire Response ID 3001. |
| QuestionnaireRespHeaderId | Long | The identifier for the questionnaire response header, linking the section details to the parent questionnaire response. Example: 1001 for Questionnaire Response Header 1001. |
| QuestionnaireRespSectionId | Long | The unique identifier for the section in the questionnaire response, providing the context for the section details. Example: 2001 for Section ID 2001. |
| QuestionnaireQuestionId | Long | The unique identifier for the specific question within the section, linking the question details to the section. Example: 4001 for Questionnaire Question ID 4001. |
| ParentQuestionnaireQuestId | Long | The unique identifier for the parent question if the current question is part of a hierarchical structure. Example: 5001 for Parent Question ID 5001. |
| HasNewerResponseFlag | Bool | Indicates whether a newer response exists for the question. Example: True if a more recent response has been submitted for the same question. |
| FailedPozValidationFlag | Bool | Indicates whether the response failed POZ (Purchase Order Zero) validation. Example: True if the response did not pass the validation. |
| QuestionDisplayedFlag | Bool | Indicates whether the question was displayed to the respondent. Example: True if the question was shown to the user. |
| AcceptanceNote | String | Any additional notes provided during the acceptance of the questionnaire response. Example: 'Approved by the manager' for a response that has been accepted. |
| ResponseComments | String | The comments provided by the respondent for the question. Example: 'The pricing information is correct.' |
| DisplayNumber | String | The display number for the question, used to identify its position in the questionnaire. Example: 'Q1' for the first question. |
| DisplaySequence | Int | The sequence number used to define the order of the question in the questionnaire. Example: 1 for the first question in the section. |
| QuestionId | Long | The unique identifier for the question, linking it to the response details. Example: 6001 for Question ID 6001. |
| QuestionName | String | The name of the question, providing a descriptive label for the question. Example: 'Supplier Name'. |
| QuestionTypeCode | String | The code representing the type of the question, such as multiple choice or text. Example: 'MC' for multiple-choice question. |
| QuestionType | String | The full description of the question type, such as 'Multiple Choice' or 'Short Answer'. Example: 'Text Response' for a question that requires text input. |
| ResponseTypeCode | String | The code representing the type of response expected, such as text, number, or selection. Example: 'TEXT' for a text-based response. |
| ResponseType | String | The full description of the expected response type. Example: 'Numeric' or 'Text' for a text-based response. |
| QuestionText | String | The full text of the question being asked in the questionnaire. Example: 'What is your supplier name?' |
| QuestionPlainText | String | The plain text version of the question, without any formatting or HTML. Example: 'What is the total order value?' |
| QuestionHint | String | A hint or guidance provided with the question to assist the respondent in answering. Example: 'Enter the total amount of your latest order'. |
| DisplayPreferredRespFlag | Bool | Indicates whether the preferred response should be displayed to the respondent. Example: True if the system suggests a preferred response. |
| PreferredResponseText | String | The text of the preferred response, which is typically displayed to the respondent as a suggested answer. Example: 'Yes' for a yes/no question. |
| PreferredResponseDate | Date | The date when the preferred response was given. Example: '2023-06-01' for the date of the preferred response. |
| PreferredResponseDatetime | Datetime | The exact date and time when the preferred response was given. Example: '2023-06-01 10:30:00' for the preferred response submission timestamp. |
| PreferredResponseNumber | Decimal | The numeric value of the preferred response, if applicable. Example: 5 for a rating scale question where 5 is the preferred answer. |
| AttachmentAllowedCode | String | The code representing whether attachments are allowed for the question. Example: 'YES' if attachments are allowed. |
| AttachmentAllowed | String | The description of whether attachments are allowed for the question. Example: 'Yes' if attachments are permitted. |
| ResponseRequiredFlag | Bool | Indicates whether a response is required for the question. Example: True if the respondent is required to provide an answer. |
| AllowRespCommentFlag | Bool | Indicates whether comments are allowed for the response. Example: True if the respondent can add comments to their answer. |
| ParentAcceptableResponseId | Long | The unique identifier for the acceptable parent response, if the current response is linked to a parent response. Example: 7001 for the parent response ID. |
| SupplierAttributeCode | String | The code representing the supplier attribute associated with the question. Example: 'SUPPLY_QUAL' for a supplier quality attribute. |
| SupplierAttributeFlag | Bool | Indicates whether the question is related to a supplier attribute. Example: True if the question is related to supplier attributes. |
| CategoryCode | String | The category code associated with the question, used to group related questions. Example: 'CAT1' for Category 1 questions. |
| Category | String | The category name associated with the question, providing context for its grouping. Example: 'Product Information'. |
| BranchLevel | Int | The level of the branch in a multi-level questionnaire, indicating how deep the question is in the hierarchy. Example: 1 for top-level questions. |
| MappedToPrereqQuestionFlag | Bool | Indicates whether the question is mapped to a prerequisite question. Example: True if the question is part of a dependent sequence. |
| Finder | String | A reference or placeholder used for searching and locating specific questionnaire response section details. Example: 'Search by Question ID' or 'Search by Response Type'. |