Participant Modules

This creates a table for each study with it turned on named “Participant Modules [Study Name]”

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