surveyconsentresult
The surveyconsentresult table contains the results of consent review steps on a 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.
- Survey consent results are contained by a survey step result, 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. |
| surveyconsentresultkey | VARCHAR |
Primary key. A unique, auto-generated internal identifier for this consent signature result. |
| surveystepresultkey | VARCHAR |
The key for the survey step result in which this survey consent result is contained in. Key relationship with the surveystepresult table. |
| identifier | VARCHAR |
The identifier of the result, determined when the survey was created. |
| consented | BOOLEAN |
Whether the participant hit agree (True) or disagree (False). |
| enddate | TIMESTAMP |
The date and time that the consent step was completed. |
| startdate | TIMESTAMP |
The date and time that the consent step was begun. |
