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

[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

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