This creates a table for each study with it turned on named “Enrollment [Study Name]”. There will be a row for each enrollment for each participant. For many programs, this will mean there’s one enrollment per participant, but for some programs that allow a participant to be re-enrolled, this could lead to multiple rows per 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 |
account_created | Date & time of account creation | 2022-02-01 12:41:16 |
additional_info | Text field studies can store random data in | |
contact_verified | Boolean yes or no | 1/0 |
access_groups | Comma separated list of access group names | HUP,PCAM |
[enrollment_step_name] There will be an additional column for each enrollment step in the program. | The completeness of the enrollment step | “Complete”/”Not Complete” |
Additional information
How often does this run? | Daily at around 2:40 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 |