surveytask
The surveytask table contains all the survey tasks delivered to participants who have joined an RKStudio project, along with various status information about each task. This data can be used to track which participants have been responding to surveys and which may have incomplete surveys.
Survey tasks correspond to the tasks the participant sees when they open the surveys tab in MyDataHelps.
Consult the RKStudio User Guide for more information about the related Survey Tasks 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.
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. |
| surveytaskkey | VARCHAR |
Primary key. A unique, auto-generated internal identifier to specify a unique instance of a survey task. |
| 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. |
| status | VARCHAR |
The current status of the task. One of Complete, Incomplete or Closed. |
| duedate | TIMESTAMP |
The date and time the task was due. |
| inserteddate | TIMESTAMP |
The creation date of the task. |
| completedate | TIMESTAMP |
The completion date of the task |
| 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. |
| hourstocomplete | INTEGER |
Hours between inserted date and completion date |
| overduedays | INTEGER |
The number of days this task has been in an overdue status |
| completedaysago | INTEGER |
The number of days since this task was completed. |
| inserteddaysago | INTEGER |
The number of days since this task was completed. |
