W2H Participant Profile
This will create a table named “w2h_profile_[study_name]" when turned on. These are all values that are stored in Way to Health related to the participant.
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 |
age | The participants age (if a Date of Birth exists) | 48 |
additional_info | Text field studies can store random data in |
|
email_address
| The participants email address | jane.doe@hotmail.com |
username | The participants username | jdoe22 |
access_groups | A comma separated list of the participants access groups | HUP,PCAM |
cohort | If the participant is in a cohort, the cohort number they are in | 387 |
strata | If the participant is in a strata, the name of the strata | High Risk |
external_id | The external ID field in Way to Health which can be used to store a different values on a per-study basis | 0288473 |
clincard_number | The participants clincard number, if they have been assigned one | 02883721 |
locale | The participants language preference | “en”/”es”/”ko”/”ru” |
last_login | The date & time of the last time the participant logged into the platform (for either enrollment, or the dashboard) | 2022-02-28 12:20:14 |
timezone | The participants timezone set in the system. Defaults to “America/New_York” | "America/New_York" |
street_address | Participants listed first line of address | 3600 Civic Center Boulevard |
street_address2 | Participants potential second address line | Floor 8, Cubicle 34 |
city | Participants city if provided | Philadelphia |
state | The state code for the participants location if given | PA |
postal_code | Participants postal code if provided | 19104 |
country | Participants country, if provided. | United States |
csn | The participants CSN if provided | 123456789 |
provider_npi | The NPI number of the participants provider if provided | 19778299172 |
notify_email | Whether or not the participant wants to receive notifications via email | “Yes”/”No” |
notify_text | Whether or not the participant wants to receive notifications via text message | “Yes”/”No” |
notify_voice | Whether or not the participant wants to receive notifications via phone | “Yes”/”No” |
notify_voice_choice | Which phone number the participant prefers to be called on | “home”/”cell”/”work” |
send_window_email Note: This is always going to be “All the time”. The field exists in Way to Health but doesn’t appear to see use | The time window we should send emails in to the participant | “All the time” or “08:00 AM to 10:00 PM” |
send_window_text | The time window we should send text messages in to the participant | “All the time” or “08:00 AM to 10:00 PM” |
send_window_voice | The time window we should start phone calls in to the participant | “All the time” or “08:00 AM to 10:00 PM” |
feedback_status | The state of the participants logic preferences | “Active” “Disabled” “Paused” “Silenced” |
payment_preference | How the participant will be paid if a payment is sent | “Manual” “Mastercard ClinCard Physical” “Visa ClinCard Virtual” “Visa ClinCard Physical” … |
Additional information
|
|
|
|---|---|---|
How often does this run? | Daily at around 3-4 AM | Currently disabled, not running |
Can it be run per-study? | No |
|
Incremental? | No. Rebuilds tables and data every time |
|
Updates existing rows? | Yes, not that they ever do |
|