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 |
Primary key. A unique, auto-generated internal identifier to specify a unique instance of a participant in an RKStudio project.
|
participantidentifier |
VARCHAR |
A unique identifier for the participant in this project. This can be set up via the invitation sent to the user, or will be auto-generated if the identifier was not specified in the invitation. Only unique with respect to the RKStudio project associated with this participant.
|
projectname |
VARCHAR |
The name of the project to which this participant is associated. The project name is displayed in RKStudio to project coordinators.
|
projectdisplayname |
VARCHAR |
The display name of the project to which this participant is associated. The project display name is displayed to participants in the MyDataHelps app.
|
organizationname |
VARCHAR |
The name of the related organization in RKStudio.
|
email |
VARCHAR |
The email address the participant used to create their account.
|
hasemail |
BOOLEAN |
True if the participant has listed an email address, False otherwise.
|
hasverifiedemail |
BOOLEAN |
True if the participant has verified their email, False otherwise.
|
firstname |
VARCHAR |
The given name of this participant.
|
middlename |
VARCHAR |
The middle name of this participant.
|
lastname |
VARCHAR |
The surname of this participant.
|
gender |
VARCHAR |
The current gender of this participant.
|
dateofbirth |
TIMESTAMP |
Birthdate of the participant. In some data marts, this will be represented as January 1 of the decade of the birthdate.
|
date |
TIMESTAMP |
The default date for the participant that represents the last time the participant changed their relationship with this project. This should be used when reporting on a general date for associating the participant with the project.
|
enrollmentdate |
TIMESTAMP |
The date the participant was enrolled in the RKStudio project.
|
lastactivitydate |
TIMESTAMP |
The start time of the participant’s last completed response. This should be used when determining completed result engagement.
|
registrationdate |
TIMESTAMP |
The date the participant’s user registered with MyDataHelps.
|
registrationcontent |
VARCHAR |
The content identifier of the UTM campaign that resulted in this participant’s registration as a MyFHR user.
|
registrationmedium |
VARCHAR |
The medium of the UTM campaign that resulted in this participant’s registration as a MyFHR user. For example: organic, email, referral, social, newsfeed.
|
registrationname |
VARCHAR |
The name of the UTM campaign that resulted in this particpant’s registration as a MyFHR user.
|
registrationsource |
VARCHAR |
The source of the UTM campaign that resulted in this particpant’s registration as a MyFHR user.
|
registrationterm |
VARCHAR |
The term of the UTM campaign that resulted in this particpant’s registration as a MyFHR user.
|
age |
INTEGER |
Current participant age, in years.
|
agecohort |
VARCHAR |
Current participant age, expressed in the following cohorts: 0-17, 18-25, 26-35, 36-45, 46-55, 56-65, 66-75, 76-85, 86 and over.
|
agecohortubr |
VARCHAR |
Current participant age, expressed in the following cohorts: 0-17, 18-24, 25-34, 35-44, 45-54, 55-64, 65-74, 75-84, 85 and over.
|
preferredlanguage |
VARCHAR |
The preferred language of the participant.
|
city |
VARCHAR |
The city from the home address of the participant.
|
postalcode |
VARCHAR |
The zip code from the home address of the participant.
|
state |
VARCHAR |
The state from the home address of the participant.
|
completetasks |
INTEGER |
The number of tasks that are complete.
|
incompletetasks |
INTEGER |
The number of tasks that are not complete.
|
overduetasks |
INTEGER |
The number of tasks with a due date prior to today.
|
useroffset |
VARCHAR |
The participant’s most recently listed UTC offset from their home address.
|
userid |
VARCHAR |
The application user ID associated with the participant. This is null if the participant does not have a user.
|
dayssinceenrollment |
INTEGER |
The number of days that have passed since this participant was enrolled in the project.
|
sensordatacollectionenddate |
TIMESTAMP |
The date that the participant’s sensor data collection ended. If null, the field may not be set for the project or the participant has not yet ended collection.
|