Participant Variable Values
- Kyle McGrogan
Analytics
This will create a table named “Variable Values [Study Name]" when turned on
Column | Description | Example Data |
|---|---|---|
participant_id | The participants Way to Health ID |
|
first_name | The participants first name | Jane |
last_name | The participants last name | Doe |
cell_phone | The participants cell phone number | +18887775555 |
home_phone | The participants home phone number | +18887775555 |
mrn | The participants MRN number |
|
mrn_type | A descriptor of what entity the MRN number is associated with |
|
date_of_birth | Participants date of birth in Way to Health | 1991-01-25 |
info_link | A link to the participants general info page in Way to Health | https://app.waytohealth.org/admin/study/1/participants/12345 |
inbox_link | A link to the participants inbox in Way to Health | https://app.waytohealth.org/admin/study/1/participants/12345/inbox |
status | Participant status | “Enrolled”/”Ready”/”Started” etc |
arm | Name of the arm the participant was enrolled into | Control |
start_date | Date & time of participant start | 2022-02-01 14:45:23 |
account_created | Date & time of account creation | 2022-02-01 12:41:16 |
additional_info | Text field studies can store random data in |
|
[variable_name] There will be an additional column for each variable in the program.
| The most recent value of this variable for the participant | Highly dependent on what type the variable is |
[variable_name]_as_of There will be an additional column for each variable in the program.
| The “as of” date & time that the provided value for this variable was generated. Usually the last time the variable was evaluated | 2021-08-11 08:50:37 |
Additional information
|
|
|
|---|---|---|
How often does this run? | Daily at around 3-4 AM |
|
Can it be run per-study? | No |
|
Incremental? | No. Rebuilds tables and data every time |
|
Updates existing rows? | Yes, not that they ever do |
|