QuestionnaireResponsesquestionnaireResponseSectionsquestionnaireResponseDetailsquestionnaireResponseValues
Holds the actual data points (for example, text, dates, numeric values) provided in response to each question, enabling detailed analysis.
Columns
| Name | Type | Description |
| QuestionnaireResponsesQuestionnaireRespHeaderId [KEY] | Long | The unique identifier for the questionnaire response header associated with the value, linking the value 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 value to a specific section within the questionnaire. Example: 2001 for Section ID 2001. |
| QuestionnaireresponsedetailsQuestionnaireResponseId [KEY] | Long | The unique identifier for the questionnaire response, linking the value to a specific response record. Example: 3001 for Questionnaire Response ID 3001. |
| QuestionnaireRespValueId [KEY] | Long | The unique identifier for the questionnaire response value, used to track the response value for the specific question. Example: 4001 for Response Value ID 4001. |
| QuestionnaireResponseId | Long | The identifier for the questionnaire response, linking the value to the overall response. Example: 5001 for Questionnaire Response ID 5001. |
| QuestionnaireAccResponseId | Long | The unique identifier for the accepted response, used to track the response that is considered acceptable for the question. Example: 6001 for Accepted Response ID 6001. |
| ResponseValueDate | Date | The date associated with the response value, typically used for date-based responses. Example: '2023-06-01' for a date-based response. |
| ResponseValueDatetime | Datetime | The exact date and time associated with the response value, providing more precision. Example: '2023-06-01 10:30:00' for a datetime-based response. |
| ResponseValueNumber | Decimal | The numerical value of the response, typically used for rating scales or numeric input. Example: 5 for a rating of 5. |
| ResponseValueText | String | The text response provided by the respondent. Example: 'Yes, the information is correct.' |
| AcceptableResponseId | Long | The unique identifier for the acceptable response, linking the response to a predefined acceptable answer. Example: 7001 for the acceptable response ID. |
| ResponseText | String | The text of the response, providing the detailed answer provided by the respondent. Example: 'The product meets the specifications.' |
| PreferredResponseFlag | Bool | Indicates whether the response is preferred or suggested by the system. Example: True if the response is marked as preferred. |
| AttachmentAllowedCode | String | The code indicating whether attachments are allowed for the response. Example: 'YES' if attachments are allowed. |
| AttachmentAllowed | String | A description of whether attachments are allowed for the response. Example: 'Yes' if the system allows attachments to the response. |
| IsSelectedFlag | Bool | Indicates whether the response has been selected. Example: True if the response was selected by the respondent. |
| DisplayNumber | String | The display number used to identify the response in the questionnaire, often for organizational or sequential purposes. Example: 'Q1' for the first response. |
| DisplaySequence | Int | The sequence number that determines the order in which the response is displayed. Example: 1 for the first response in the section. |
| HasBranchingFlag | Bool | Indicates whether the question has branching logic based on the response. Example: True if the response leads to a new set of questions. |
| FromUI | String | Indicates whether the response was provided via the user interface (UI). Example: 'YES' if the response was submitted through the web interface. |
| ResponseAttachments | String | The attachments associated with the response, providing links or references to any uploaded files. Example: 'file1.pdf, file2.jpg' for attached documents. |
| Finder | String | A reference or placeholder used for searching and locating specific response values. Example: 'Search by Response ID' or 'Search by Question ID'. |
| QuestionnaireRespHeaderId | Long | The unique identifier for the questionnaire response header, linking the response value to the specific questionnaire response. Example: 1001 for Questionnaire Response Header 1001. |