Repeating Events in this context are Data Collection, Survey, or Conversation events that repeat within an intervention arm

Column	Description	Example Data

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	`"HUP MRN"/"PMC MRN"/"PAH MRN"/"CCH MRN"/"MR"`
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
last_completed_[event name] There will be an additional column for each repeating event in the study	The date and time of the last time this participant completed the given repeating event This will be null if they never completed the event, or they are in an arm that does not have this event	“2018-04-09 13:28:50”/Null
last_missed_[event_name] There will be an additional column for each repeating event in the study	The start date and time of the last time this participant skipped the given repeating event This will be null if they never skipped the event, or they are in an arm that does not have this event	“2018-04-09 13:28:50”/Null

Additional information


How often does this run?	Daily at around 4:30 AM
Can it be run per-study?	No
Incremental?	No. Rebuilds tables and data every time
Updates existing rows?	Yes, not that it ever happens