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

notification_status

The Way to Health “Feedback Status” setting

“Active”/”Disabled”/”Paused”/”Silenced”

last_changed

The last time this value was changed

“2018-04-09 13:28:50”/Null

days_since_last_change

Number of days since this value was last changed

70

How often does this run?

I don’t think this does?

Can it be run per-study?

No

Incremental?

No. Rebuilds tables and data every time

Updates existing rows?

Yes, not that they ever do