surveyresult
The surveyresult table contains the results of surveys that have been completed as part of an RKStudio project.
When a participant completes a survey, it generates a Survey Result. Each survey result contains multiple step results (corresponding to each step of the survey), and each step result can contain multiple child results (answers to questions, results produced by active tasks, etc.). In some cases (e.g., instruction steps, or if a step was skipped)—a step result may not have any child results.
Consult the RKStudio User Guide for more information about the related Survey 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.
- Description of the surveytask table.
- A survey result contains many survey step results, described in the surveystepresult 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. |
| participantkey | VARCHAR |
Internal identifier to specify a unique instance of a participant in an RKStudio project. Key relationship with the participant table. |
| surveyresultkey | VARCHAR |
Primary key. A unique, auto-generated internal identifier to specify this instance of a survey response. |
| surveyname | VARCHAR |
The name of the survey this result was for. Used to manage surveys in RKStudio. |
| surveydisplayname | VARCHAR |
The name of the survey this result was for. Displayed to participants in MyDataHelps. |
| surveyversion | INTEGER |
Identifies which version of the survey was active at the time the data was collected. This allows you to adapt data processing if your survey changes. |
| surveytaskkey | VARCHAR |
The key for the task used to deliver this survey. Key relationship with the surveytask table. Will be empty for Consent survey results - results captured during the consent process do not have a survey task. |
| type | VARCHAR |
Type of survey result. One of Survey or Consent. |
| startdate | TIMESTAMP |
Date and time that the participant began taking the survey that generated this response. |
| enddate | TIMESTAMP |
Date and time that the participant finished taking the survey that generated this response. |
| duration | INTEGER |
Duration (in seconds) representing the sum of the duration of all related survey steps. This will be different than the time span between startdate and enddate if the participant paused between steps. |
| inserteddate | TIMESTAMP |
Date and time that this survey response was recorded. |
| rdrresponseid | VARCHAR |
Internal identifier. |
| inserteddatecovidstatusdate | TIMESTAMP | |
| starthour | INTEGER |
Hour of the day that the participant began taking the survey that generated this response. -1 if startdate is null |
| taskcompletiondays | INTEGER |
NA |
| taskuuid | VARCHAR |
Internal Reference |
