Enrollment

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