This creates a table for each study with it turned on named “Participant Modules [Study Name]”
Column | Description | Example Data |
---|---|---|
participant_id | The participants Way to Health ID | |
block_id | The ID of the Event block that represents this module | 1847 |
block_name | The name of the Event Block that represents this module | “Participant Start” |
block_created_at | The date and time that this specific instance of the Module was added to the participants schedule | 2021-07-24 00:03:46 |
block_date | The start date and time for the specific instance of the Module | 2021-08-07 00:00:00 |
block_status | The status of this instance of the Module |
|
Additional information
How often does this run? | Daily around 2-4 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 |