This creates a table for each study with it turned on named “Participant Modules [Study Name]”. Modules are the individual blocks of events that are created throughout a participants intervention. A participant can have any number of blocks, and can have the same block multiple times if there is a reason it was repeated.

Column	Description	Example Data

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	`Closed` - When a block is closed early due to logic `Deleted` - When a module has been deleted (either manually or by rescheduling) `Future` - All of the modules events are in the future `Current` - Some of the events (but not all) have been completed/skipped `Past` - All of the events in the module are in the past

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