Milestones
- Kyle McGrogan
Milestones in this context are events that last longer than 1 day. This usually means things like long-running surveys.
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 |
days_since_start | Number of days since this participant started | 20 |
[event name] There will be an additional column for each event in the study lasting longer than 1 day
| The completeness of the event This is Null when the participant does not have the event | “Completes”/”Skipped”/”Future”/”Open”/Null |
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? | No |
|
Improvements | This does not currently take into account events scheduled by source/offset that last longer than a day |
|