Demographics from Clarity
- Kyle McGrogan
This creates a table for each study with it turned on named “Demographics [Study Name]”
Column | Description | Example Data |
|---|---|---|
participant_id | The participants Way to Health ID |
|
first_name | The participants first name from Clarity (or Way to Health if Clarity doesn’t have it) | Jane |
last_name | The participants last name from Clarity (or Way to Health if Clarity doesn’t have it) | 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 |
|
date_of_birth | Participants date of birth from Clarity (or Way to Health if Clarity doesn’t have it) | 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 |
middle_name | The participants middle name from Clarity | Jingleheimer |
language
| The participants language from Clarity | “English”/”Chinese”/”Russian”/”Unknown”etc |
race | The participants race from Clarity | “Asian”/”Black”/”American Indian”/ etc |
ethnicity | The participants ethnicity from Clarity | “As”/”WHITE”/”WHI”/”Blk”/”Unknown”/etc |
sex | The participants sex from Clarity | “Female”/”Male”/”X”/etc |
payor_name | The participants payor from Clarity | “AETNA”/”BLUE CROSS”/ etc |
financial_class | The participants financial class from Clarity | “Managed Care”/”Managed Medicare”/”Blue Shield”/”Self-Pay”/etc |
mychart_status | The participants MyChart status from Clarity | “Activated”/”Pending Activation”/”Patient Declined”/”Inactivated”/”Non Standard MyChart Status”/etc |
Additional information
|
|
|
|---|---|---|
How often does this run? | Daily around 7-8 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 |
|