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

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
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