Participant Status Changes
- Kyle McGrogan
This will create a table named “Participant Status Change [Study Name]" when turned on. Each row in the table will represent a moment in time when a participant in the studies status was updated.
Useful transitions:
Enrolling → Enrolled: The participant was randomized at this time
Enrolled → Ready: The participant finished Enrollment
Ready → Started: The participant started in the program at this time
Some programs with re-enrollment might have other transitions to find that which depend on program configuration
Column | Description | Example Data |
|---|---|---|
study_id | The id of the study | 72 |
study_name | The name of the study | Demo study |
participant_id | The participants Way to Health ID |
|
status | The participants current status |
|
old_value | The status the participant was in before this change |
|
new_value | The status the participant was set to |
|
description | Standard english description of the status change | status changed from 'Enrolling' to 'Enrolled' |
change_author_user_id | If the change was caused by the actions of a logged in user, the guard user id of that user (which isn’t super useful in these datasets…) | Null or 28937 |
created_at | The timestamp of when the change occurred | 2023-08-27 12:33:58 |
updated_at | If this record was updated, the time it was updated. I don’t think these records ever change so this should always match the created_at | 2023-08-27 12:33:58 |
Additional information
|
|
|
|---|---|---|
How often does this run? | Daily at around 7 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 |
|