surveyquestionresult
The surveyquestionresult table contains the results produced by Question Steps and Form Steps on a survey.
Consult the RKStudio User Guide for more information about the related Survey Question Results Export Format.
Related tables in the RKStudio Model:
- Overview of the RKStudio Model for relationships with other tables in the RKStudio data model.
- Description of the participant table.
- Survey question results are contained by a survey step result, described in the surveystepresult table.
- A survey question result contains zero to many survey answers, described in the surveyanswer table.
Table Schema
| Name | Type | Description |
|---|---|---|
| personid | VARCHAR |
Internal identifier to specify a unique instance of a person. This column is used to partition data tables in the Bulk Data API and should be included on all table joins. Use personid to join to tables in other models within the Bulk Data API. |
| surveyquestionresultkey | VARCHAR |
Primary key. A unique, auto-generated internal identifier for this question result result. |
| surveystepresultkey | VARCHAR |
The key for the survey step result in which this survey question result is contained in. Key relationship with the surveystepresult table. |
| identifier | VARCHAR |
The identifier of the result, determined when the survey was created. For Question Steps, this will be the same as the stepidentifier of the related survey step result. For Form Steps, this will be the name of the Form Item. |
| label | VARCHAR |
Display text associated with the question. |
| labelorder | INTEGER |
The order of the question with respect to other questions contained within this survey step result. |
| answerprofile | INTEGER |
A concatenated string of all answers recorded to the survey question. For a structured representation of each answer, see the Key relationship with the surveyanswer table |
| startdate | TIMESTAMP |
The date and time the participant started answering the question. |
| enddate | TIMESTAMP |
The date and time the participant finished answering the question. |
| hasassessment | BOOLEAN |
True if the question has an assessment. |
| iscorrect | BOOLEAN |
True if the question is answered correctly. |
