surveyaudit
The surveyaudit table describes all user activity associated with using or completing a survey.
As a participant fills out a survey, audit information is captured at each step. This audit information is useful to report on partially completed surveys, step dropoff, and the path that the participant followed through the survey.
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. |
| surveyauditkey | VARCHAR |
Primary key. A unique, auto-generated internal identifier to specify a unique instance of a survey audit (survey activity). |
| application | VARCHAR |
The application that recorded the survey activity. |
| event | VARCHAR |
A description of the survey activity. |
| time | TIMESTAMP |
The time the survey activity was recorded. |
| nextsteptime | TIMESTAMP |
Date and time associated with the next survey activity. Used to compute the duration of the current activity. |
| path | VARCHAR |
Audit Path. Not available for all studies |
| surveyresultkey | VARCHAR |
Reference to the response associated with this survey activity. |
| stepcompleted | BOOLEAN |
True if this survey activity is associated with a completed survey step. |
| stepduration | INTEGER |
The total time in seconds this step took the participant to complete. -1 if the step was not completed. |
| organizationcode | VARCHAR |
Code of the organization that owns the survey of this audit. |
| organizationname | VARCHAR |
Name of the organization that owns the survey of this audit. |
| 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. |
| surveystepidentifier | VARCHAR |
A unique identifier associated with the survey step. |
| surveysteporder | INTEGER |
The order in which the steps are completed within a survey. |
| surveystepcriticalpath | BOOLEAN |
True if the survey step is part of the critical path for the survey. |
| stepchainid | VARCHAR |
Internal identifier. |
| previousstepchainid | VARCHAR |
Reference to the previous survey step. |
| taskuuid | VARCHAR |
Internal reference. |
| recordedsurveyversion | INTEGER |
The version of this survey as recorded at the time of audit. |
